Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a function that will work using multiple work books and sheet
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a function that will work using multiple work books and sheet
need a function that will work using multiple work books and sheet
To reference a cell from another workbook, use something like: '[FFFF]SSSS'!$B$4 where FFFF is the file name (e.g., test.xls) and SSSS is the sheet name. For another sheet in the same workbook, it's simply: =SSSS!$B$4 If that doesn't answer the intended question, provide more information about the current data setup and what you're trying to accomplish. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to make changes to multiple excel work books at one time | Excel Discussion (Misc queries) | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Histogram made from multiple exel work books. | Charts and Charting in Excel | |||
Work books | Excel Worksheet Functions |