links not correct


P

Pammy

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.
 
Ad

Advertisements

Ad

Advertisements

P

Pammy

This changes all the sheets to the one I happen to be on. I am on sheet 1
and select all the sheets then the only change I make is changing the G33 to
J21 it changes all the sheets to the cell ref of J21 which is correct, but
now all the sheets are pointing to sheet 1. This is my formula:
=SUM('[09 input.xls]1'!G33) (example) So when I am on sheet 2 it should
now read: =sum('[09 input.xls]2'!J21) but all 52 sheets are 1.
Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link change 1
links 1
cells linked from worksheet to worksheet 1
Save Worksheet To Master Workbook 5
link issue 1
auto add page breaks 1
Excel "list" and paste link problem 1
Relative worksheet reference clarified 4

Top