cells linked from worksheet to worksheet

  • Thread starter Thread starter Pammy
  • Start date Start date
P

Pammy

I have a workbook that has 52 worksheets. This main workbook has links from
an input spreadsheet. question, On the main workbook, each sheet has some
of the cells linked to the wrong cells from the input workbook Is there an
easy way to change the cell address? Sheet 1 input is linked to sheet 1 on
the main, sheet 2 from input to sheet 2 on main, etc. Can this be done
without correcting each sheet?
 
Use find and replace - with care! Example:

Highlight an area of you sheet that contains formula extracting information
from Sheet2 instead of Sheet1

Find What: Sheet2
Replace with: Sheet1

Excel will return an error if modifying formula would make the reference
invalid.

--
Lil



I have a workbook that has 52 worksheets. This main workbook has
links from an input spreadsheet. question, On the main workbook,
each sheet has some of the cells linked to the wrong cells from the
input workbook Is there an easy way to change the cell address?
Sheet 1 input is linked to sheet 1 on the main, sheet 2 from input to
sheet 2 on main, etc. Can this be done without correcting each
sheet?
Click to expand...



--
 
Back
Top