Search and replace

R

Rockbear

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
 

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

Why dont this work? and copy functions 1
Help: vlookup from multiple sheets and spreadhseets 1
Using a vlookup to search multiple criteria for one result? 7
Index function - problem copying to other cells 5
Need help to fix vlookup function in macro 1
Remove workbook reference but keep worksheet references 2
Linking Workbooks using file names in a range 2
Dynamic named range reference from external workbook 2

Top