Linking to other workbooks

  • Thread starter Thread starter jc132568
  • Start date Start date
J

jc132568

Dear Experts,
I have two excel files where File B collects/summarises data from File A for
the duration of 2007. They are situated in the one folder.

I want to have the same pair of files for 2008. When I copied the two files
into a folder for 2008, renamed them to include 2008 in the name all is not
well. File B is still looking for the 2007 file:

Typical reference:
='I:\General\2008 EXAMINER SEM2\Level 1 Sem2 2008\[Level1Sem2
2007.xls]EBRS'!$C5

I can understand why it is doing it but is there a way around it. I would
love not to have to set up all the references in File B again.

Your advice is greatly appreciated.
regards
jc132568
 
May be one way. Find and Replace
find = 2007.xls replace with =2008.xls
If the files of the two folders are same. ie 2007 and 2008
Initially have a backup
with regards
Sreedhar
 
Many thanks. You saved me hours of work.
Thanks again.
jc132568

yshridhar said:
May be one way. Find and Replace
find = 2007.xls replace with =2008.xls
If the files of the two folders are same. ie 2007 and 2008
Initially have a backup
with regards
Sreedhar
jc132568 said:
Dear Experts,
I have two excel files where File B collects/summarises data from File A for
the duration of 2007. They are situated in the one folder.

I want to have the same pair of files for 2008. When I copied the two files
into a folder for 2008, renamed them to include 2008 in the name all is not
well. File B is still looking for the 2007 file:

Typical reference:
='I:\General\2008 EXAMINER SEM2\Level 1 Sem2 2008\[Level1Sem2
2007.xls]EBRS'!$C5

I can understand why it is doing it but is there a way around it. I would
love not to have to set up all the references in File B again.

Your advice is greatly appreciated.
regards
jc132568
Click to expand...
Click to expand...
 
Welcome, thanks for feedback
With regards
Sreedhar

jc132568 said:
Many thanks. You saved me hours of work.
Thanks again.
jc132568

yshridhar said:
May be one way. Find and Replace
find = 2007.xls replace with =2008.xls
If the files of the two folders are same. ie 2007 and 2008
Initially have a backup
with regards
Sreedhar
jc132568 said:
Dear Experts,
I have two excel files where File B collects/summarises data from File A for
the duration of 2007. They are situated in the one folder.

I want to have the same pair of files for 2008. When I copied the two files
into a folder for 2008, renamed them to include 2008 in the name all is not
well. File B is still looking for the 2007 file:

Typical reference:
='I:\General\2008 EXAMINER SEM2\Level 1 Sem2 2008\[Level1Sem2
2007.xls]EBRS'!$C5

I can understand why it is doing it but is there a way around it. I would
love not to have to set up all the references in File B again.

Your advice is greatly appreciated.
regards
jc132568
Click to expand...
Click to expand...
Click to expand...
 

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

Sum the number of days between dates by Month 16
Specify a column by the month to calculate it's data 5
Specify columns to add for months MTD Diff 3
Refer to other tabs in formula 2
How can dynamically set a range name in a HLOOKUP command? 1
Linking certain cells from Multiple files in a folder onto a summa 1
pulling data from one workbook to another based on a condition 3
How do I use a cell as a referance to a file in a lookup statemen. 1

Back
Top