Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference cells in 2 sep files
John,
Use something like Worksheets("Sheet1").Cells(i,j).Value = _ Workbooks("Book2.xls").Worksheets("Sheet2").Cells( i,j).Value -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "John" wrote in message ... Hi all, i wish to popolate cell(i,j) in one Excel File with values from a sheet inanother Excel File. e.g. sheets("Sheet1").cells(i,j) = Sheets("Sheet2").cells(i,j) but how do i refer to cells in a different file altogether? i've tried this (but it doesn't work!) Sheets("Sheet1).cells(i,j) = Windows("FileA.xls").Sheets ("Sheet1").cells(i,j) TIA, John. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference cells in 2 sep files
Thanks Chip,
that's worked a treat! john. -----Original Message----- John, Use something like Worksheets("Sheet1").Cells(i,j).Value = _ Workbooks("Book2.xls").Worksheets("Sheet2").Cells (i,j).Value -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "John" wrote in message ... Hi all, i wish to popolate cell(i,j) in one Excel File with values from a sheet inanother Excel File. e.g. sheets("Sheet1").cells(i,j) = Sheets("Sheet2").cells (i,j) but how do i refer to cells in a different file altogether? i've tried this (but it doesn't work!) Sheets("Sheet1).cells(i,j) = Windows("FileA.xls").Sheets ("Sheet1").cells(i,j) TIA, John. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference constant cells in different files from a master workbook | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Indirect Reference to Other files | Excel Discussion (Misc queries) | |||
Reference different files using vlookup | Excel Worksheet Functions | |||
Need to reference different files using vlookup | Excel Worksheet Functions |