Forum Discussion
summarizing data to auto fill in another worksheet.
I have a workbook with around 20 worksheets, all the final values get consolidated onto page#1. Page #1 has over 300 rows and several columns that have the quantities and costs brought into it by s...
MichaelK, I would suggest you make yourself familiar with Power Query.
PQ can consolidate many worksheets into one. It can filter, sort and you can add new columns and lots more.