| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Autofill with data from multiple sheets from a different workbook
Good morning,
I have a summary sheet in one workbook, that I need to fill with data from weekly sheets from another workbook, and I can't get them to autofill correctly. I've tried using the INDIRECT function, but I can't seem to nail the references down. So in my summary workbook- I need to fill C39-F39 with data from [workbook 2.xlsx]wk1 B7-E7 And I need to autofill down so that C40-F40 contains the data from [workbook 2.xlsx]wk2 B7-E7 Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you chart data from multiple sheets within a workbook? | Excel Programming | |||
| How to chart data from multiple sheets in Workbook | Excel Programming | |||
| How can collect data from multiple sheets in the same workbook? | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| merge data from multiple excel sheets into a workbook | Excel Programming | |||
Linear Mode
