Mass change of same cell in multiple files??????

  • Thread starter Thread starter Jim Fox
  • Start date Start date
J

Jim Fox

I have about 180 files that are price pages from a company we sell products
from. The same cell in every file, Sheet 1 P1 is a factor that is used in
formulas through out the files.

I guess I am wondering if there are 1 of 2 solutions.

1) Can I mass change that P1 cell in all 180 files to be a different number
instead of 1.0?

or

2) Can I mass change any reference to that cell in any sheet to point to
one cell that we can change anytime and only do 1 update for all 180 files?

Thanks in advance
 
Hi Jim

You can do this with a macro
http://www.rondebruin.nl/copy4.htm

You can use a formula that point to a file with the value.
This way you only have to update one file.
Only every time you open one of the files you get a dialog that
ask you if you want to update the link.
 
Hey Ron........thanks a bunch. I used the copyrange option 1 for this
one..........from the url you gave me.

WORKED GREAT...........Saved me lots of time.
 
Back
Top