Search and replace
 

Hi
I have 25 sheets in one workbook, and neet to copy a column from another
workbook into 25 sheets in woork book budsjett.xls

Have tried : =IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,0),"",F1)

but is did not work so I made just a easy one:

='507.xls'!$G$4

but I have 25 sheets an need to copy this formula from 507.xls to 508.xls,
how to change all the 507.xls to 508.xls in all 290 rows of formula, the 507
and 508xls is in the same folder


Or some better way tio do, I am stuck on 2003 excel :)

Just a regular user