Dear All
Please can someone advise how I can get excel to populate the data on the master sheet from the individual daily sheets. I have attached sample excel.
In the sample sheet excel, on a daily basis I nned the data to be entered on the date sheets of the month, 1,2,3,4 etc and then wnat the master sheet to capture this information on the master sheet. If i went back to a day later on to add an extra entry, would the master sheet be updated also.
Thank you.
vba1234
As tabs 1 2, 3 appear to DAYs of a month it would be more sensible (best practice!) to put ALL your data in the MASTER sheet and avoid the "daily" sheets.
Adding daily data will require VBA.
In the attached:
In "Mater", click on "Developer" then "Form" (far right) and now there is a ready-made input form.
Last edited by JohnTopley; 04-13-2022 at 11:56 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Oh, I'm late. Hi to all.
Well the only way I can do this is with vba, so here's what I came up with. On request (to be done after updating data), the macro (to be pasted in a module) when launched will clear sheet Master and then consolidate data from the other sheets once again.
Please Login or Register to view this content.
Last edited by rollis13; 04-13-2022 at 11:41 AM.
@rollis13: I would take the same approach and the macro could be invoked on Workbook.Close.
One potential issue is if the data in Master is updated independent of the Daily so that data is lost in the refresh (but no easy answer to this!)
@JohnTopley, not sure if the function Workbook.Close would be the only moment to update the master, maybe OP needs to look at the Master before closing, but could be usefull if one forgets to manually launch the macro; twice is better than nothing.
Maybe with event Workbook_SheetChange it would be more immediate.
Dear All
Thank you all so much for your help. I have tried this and it works. Is there any way to get a short cut button to run the macro on the Master sheet, rather than having to select the macro?
See attached
Dear John and rollis123
Sorry for the late update, but busy. I had a look at the sample excel and see that John has kibldy provided a quck update link and the link and VBA work.
Thank you.
Will this VBA routine work in this maner for any number of columns?
vba1234
In my macro post #3 the column range is hard-coded B-K so needs some code adjustment to become dynamic.
This could be a solution with dynamic columns (but always with data starting from column B row 3):Please Login or Register to view this content.
Last edited by rollis13; 04-18-2022 at 05:34 PM.
Hi rollis13
Thank you.
I will try this and if any problems will advise.
vba1234
Oh, it has been tested, at most it differs from your expectations.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks