- Mar 31, 2021
- Office Version
Need a summary page that pulls data from multiple worksheets in the same workbook. Each day an excel spreadsheet that has device readings is created and saved in a folder. The devices have unique identifiers. There are 20 devices. I have used a macro to place all of the sheets in one workbook. Need Excel to look through each tab of the worksheet for the 1. device identifier and 2. the date, then place the meter reading on the summary page which will be the first tab of the spreadsheet. I have spent hours researching and trying but I can't figure it out. The worksheets with the source data are auto-generated daily and are in two formats, not identical. The date is in a merged cell. The worksheets are in two basic formats. For some devices I need the summary page to pull the Daily Gross (gal) and for other devices I need the Daily Net MCF to be reflected on the summary page. How can I accomplish this without going through ALL 600 (20 devices * 30 days per month) tabs manually? I am praying hoping someone can assist. Small example attached. Forever Grateful! Thanks so much!