| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking set of worksheets between different workbooks!
Hi,
We have a workbook A- with 50 worksheets named as Week1 Week2 etc. We have to create a new workbook B- with same number of worksheets, grabbing values of 3 cells from corresponding A's worksheets. B's Week1 will pull values from 3 cells in A's Week1 B'1 Week2 will pull values from same 3 cells in A's Week2 and so on.. HOw can this be accomplished without manually changing the SHeet name on the formulas. Thanks Priya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking worksheets | Excel Worksheet Functions | |||
| Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
| linking worksheets in same workbook | Excel Discussion (Misc queries) | |||
| Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
| Simplify Linking to several worksheets?? | Excel Worksheet Functions | |||
Threaded Mode
