Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking worksheets
I want to pull data from about 100 different Excel files. They are located in
the same folder and drive and the data I want is in consistent cell locations. I would to find a fast way to reference the files. something like S:\Folder\January\CaseNumber1.xls that will allow me to pull-down the folumula and copy the month and case number from two separate fields on my spreadsheet. So I would specify the month and case numbers and have them automatically populate my link formula. Any suggestions??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
Linking Several Worksheets to One Worksheet | Excel Discussion (Misc queries) | |||
Linking across worksheets not working as desired | Excel Worksheet Functions | |||
Linking set of worksheets between different workbooks! | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel |