Forum Discussion
Selecting data from multiple worksheets
From my workbook of 75 worksheets (more or less) I need to select rows of data for which one column holds specific data, most often, a date.
I'd like to copy those rows from across all of the worksheets into a single worksheet.
Essentially, I want to be able to use the "Find and Replace" function, and upon getting the "Find All" results, paste all of the corresponding rows into a single worksheet.
Is this possible?
2 Replies
Whaoo. That is such quite many sheets. Since there is over 1 million of rows in a single sheet, I suggest you put all the data in a single sheet. Then, you can use PivotTable and other Excel functionalities to achieve your desire report
It's our annual budget. Each budget line is on a separate worksheet. Every month as revenue and expenses accrue, the details of each transactions is added to the appropriate worksheet. By December some sheets have 200 rows, others only 2 rows. Combining all of the worksheets into one would be counter-productive.
I need to be able to do monthly tallies of the whole budget.
