Prev: .csv to .txt
Next: complicated drop down menu question
From: TaralearningExcel on 8 Apr 2010 11:01
Hello,

I have a master spreadsheet that has multiple links in it from 150 other
spreadsheets. Needless to say it was very time consuming to link certain
rows from each spreadsheet. If there is a way to automate this for the
future, I would very much appreciate the info. I have no exp in VB by the
way. :) A co-worker was helping me do the links and accidently linked to the
wrong file name. Is there a way to change each link to the correct one
without it being such a manual process? For example, I have a spreadsheet
named County.xls. In that spreadsheet I have multiple rows linked to a
master spreadsheet which is another workbook with many different tabs which
are named after each row I am linking. My coworker linked the master to a
file called County 2010.xls.

Thanks so much in advance. It's extremely time consuming to copy and paste
each row.

Tara
From: Paul C on 8 Apr 2010 12:32
Use Find and Replace, simply replace all instances of County 2010.xls with
County.xls
--
If this helps, please remember to click yes.


"TaralearningExcel" wrote:

> Hello,
>
> I have a master spreadsheet that has multiple links in it from 150 other
> spreadsheets. Needless to say it was very time consuming to link certain
> rows from each spreadsheet. If there is a way to automate this for the
> future, I would very much appreciate the info. I have no exp in VB by the
> way. :) A co-worker was helping me do the links and accidently linked to the
> wrong file name. Is there a way to change each link to the correct one
> without it being such a manual process? For example, I have a spreadsheet
> named County.xls. In that spreadsheet I have multiple rows linked to a
> master spreadsheet which is another workbook with many different tabs which
> are named after each row I am linking. My coworker linked the master to a
> file called County 2010.xls.
>
> Thanks so much in advance. It's extremely time consuming to copy and paste
> each row.
>
> Tara
 | 
Pages: 1
Prev: .csv to .txt
Next: complicated drop down menu question