Hi,
I need to log the inspection details in master sheet from the different sheet. Please help on this regard.
Hi,
I need to log the inspection details in master sheet from the different sheet. Please help on this regard.
Can you give more details :
Do you want to copy all data from all sheets to sheet "Master Sheet" ?
Do you want to delete previous data or new one at the bottom ?
Is there filter to apply ?
Are duplications to check ?
- Battle without fear gives no glory - Just try
Hi,
I want to connect 8 sheets data in to my master log sheet. I am dealing with 8 vendor for inspection related activities and all of their data are keeping in separate sheets. But, as a cumulative report, i need a to make a master sheet without manually adding the same in it.
Best way would be to create the master table using PowerQuery. You would need to convert each of the grids into proper Excel tables first, but that's easy enough to do.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Could you please assist me how to do this
Hello Basil,
Try the following code placed in a standard module and assigned to a button:-
Please note that you have a space after "Table" in the sheet name "Pivot Table". I've allowed for this in the above code.Please Login or Register to view this content.
I've attached your sample workbook with the code implemented. Click on the "CONSOLIDATE" button to see it work.
I hope that this helps.
Cheerio,
vcoolio.
See next code.
It seems you want to delete previous data in sheet "Master Sheet", if not delete
Please Login or Register to view this content.
Please Login or Register to view this content.
Dear PCI,
Can you update the code in excel sheet. when i tried to copy the same. it is not working properly. I have a similar use of such tables.
See your file attached
Macro is put in a module
Dear PCI,,
In that Agency name is not showing. Agency name shall be the sheet names.
in the provided excel sheet , instead of agency name , it is dates. Can you please change that
"Agency" column exits only in sheet "Master Sheet", is it possible to shift this column at the 1 column or at the last one : Code simpler ... and time treatment shorter ...!
If it is shown as per the master sheet it is better. and if you feel any difficult, then it can be moved to first or last.
See next code and file attached
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks