workbook referencing problem
 

I am trying to reference a cell in a different workbook. If I do each
individual reference with my mouse it works, but i have a lot of sheets to do
so I wanted to be able to copy and paste but it won't work.

I have one workbook that references all the others using the formula
='[04F1-10a.xls]Field 3'!$B$4. I want to be able to change field 3 to 4,5,6,
etc. When I copy the one formula multiple times it will display "4-3" which
is correct. but then when i try to change the 3 to a 4 it should display
"4-4" but instead it just displays the formula.

workbook referencing problem
 

Chris have you tried Edit, Find and Replace?
Copy all formulas into your worksheet then Edit, Find and Replace and
complete 'Find what:' Field 3 & 'Replace with:' Field 4 then you can 'Replace
All' or 'Replace' (replaces one entry at a time)
Does this help?

"Chris J." wrote:

I am trying to reference a cell in a different workbook. If I do each
individual reference with my mouse it works, but i have a lot of sheets to do
so I wanted to be able to copy and paste but it won't work.

I have one workbook that references all the others using the formula
='[04F1-10a.xls]Field 3'!$B$4. I want to be able to change field 3 to 4,5,6,
etc. When I copy the one formula multiple times it will display "4-3" which
is correct. but then when i try to change the 3 to a 4 it should display
"4-4" but instead it just displays the formula.