I have one 52 spreadsheets that are linked (example: sheet 1 - Precinct
workb to sheet 1 Compstat master workb. There are 52 spreadsheets on both
workbooks and 1 pulls from 1, 2 from 2, etc all the way to 52. Problem,
several rows were added to the master so now the formulas for the compstat
master are off is pulling the wrong row of the precinct workb. Is there an
easy way to update the correct formula information into the new cells of the
master, keeping in mind 1 is linked to 1, 2 is linked to 2, etc all the way
for 52 worksheets. To do this manually for 52 sheets will be so time
consuming. I have excel 2003.
Thank you.