Replacing all references to a file, with a new file name. Lots!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a new worksheet for the new year. I have copied the last years
formula's over into this new worksheet. THe problem i need to get around is
changing a reference to a file to a new file name in about 3000 cells. I have
tried to copy and paste after changing 1 manually but as it refers to cells
that are 3 apart each time in the other workbook it wont do it. Nor can i
manually modify say 5 and drag the corner box. It simply replicate the
original 5 over and over. Is there a macro or something i can use that checks
for all references to file ***2006-2007.xls and replaces it with
***2007-2008, for the entire worksheet?
Thanks in advance
Phil
 
You must log in or register to reply here.

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

How do I create a formula that references a specific tab in Excel? 1
Possible to refer to a sheet's object name ? 1
Auto Update worksheet references as new worksheets are added 1
Absolute References and worksheets 0
Assigning a Worksheet Name to a Cell 4
Changing worksheet references 3
static reference in formula to worksheet 1
Reference the same cell based on tab name 1

Back
Top