Forum Discussion
Help! Is this possible??
Hello- I would like to set up multiple sheets within an excel workbook where people can go to their tab and input data and then have that data transfer to a "totals" sheet also within the workbook. I...
Hi,
There are different ways to do that, whether by nested Functions, Macros & VBA or Power Query.
Just to give you an example of the concept (although it is a little different than your exact request) In the attached File, I have 87 Sheets (Each for a different day). I would like to consolidate the records from all the sheets in One single Summary report and display a message box showing the total number of records. There is a code created in VBA which will do all the magic when triggered with the Shortcut CTRL + SHIFT +P
In your case, minor modification to the code (like you do not want to delete the original sheet after copying it's data) can be done.
Again:
If your question is : Is it feasible
The answer is : YES
Thanks
Nabil Mourad