Forum Discussion
Solved
consolidate data
I have a workbook with 31 (they are actually dates of a month) exactly same worksheets. Each sheet has a few cells that contain the total of different columns. Column A of the summary sheet contains ...
SergeiBaklan Thanks for your kind help. Your solution worked quite well. As it will take at least one month when I have sufficient real-life data to test it. I think it should work. I'll get back to you if I need more help on this issue. I've another issue related to the same project. Now, the sheet I shared was for one month. I'll have twelve such sheets. I'm attaching the sheet. How can I easily get data of 12 months in this single sheet?