Search results

It works !!! Thanks Luke & Shrivallabha

Hi Shrivallabha I ran the above and got a Run-time error'52 Bad file name or number Regards Siva

Hi A B C D 1 Group1_20_08_2013 Group2_20_08_2013 Group4_20_08_2013 Group4_20_08_2013 2 56 67 45 34 3 46 23 45 45 4 45 56 767...

Done, sent the workbook to your Email Regards Siva

Hi Narayan I am getting the following error Run time error '91': Object variable or With block variable not set Regards Siva

HI Narayan Thanks for your reply. The formulas in B2:G2 are fixed, just the results changes. I tried the codes above, but am getting an error on "Set Precedent_range = check_range.DirectPrecedents" Thanks Regards SivaK

Thanks

Hi Narayan It doesn't seem to be working with my actual worksheet The cells B2:G2 are cells with formulas. =IF(E$52=1, "Black", IF(E$62=1,"White","")) It does not seem to be working with the formulas there. If I manually key in something in B2, it works. Regards Siva

Hi Narayan IT WORKS !!! Thanks Regards Siva

Hi Narayan Thanks for the quick reply. Answer to your questions. 1)The data in Cell B2:H8 will have formulas that will pull data from another table. The formula is a True/False. If the formula is True it will populate the cell. 2)When cell B2 gets populated, B3:B8 will be auto populated...

Hi Narayank Please see the sample data file : http://www.sivasharm.com/sample_data.xlsx The info on the first table is populated from another table. The Second table is the stored info from the first table. Thanks Regards SivaK

Hi Need some assistance in creating a function in Excel 2007. Attached is a sample of a table I am working with Actual data table and Stored data table. In the first table in cell B2..G2, that has formula which are based on live data. When the formula is correct, it will display a figure...