Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and Replace | Excel Worksheet Functions | |||
Search and replace | Excel Worksheet Functions | |||
Search and Replace | New Users to Excel | |||
Search and replace | Excel Worksheet Functions | |||
search & replace | Excel Worksheet Functions |