agwalsh
asked on
Any way to quickly enter duplicate data for a different month - for example.
Is there a way to quickly enter repeat entries e.g. I have a list of payments I make to the same people every month. I need to record these entries every month. I am currently using a table to record these entries (so I can run a pivot off them). Any suggestions on how to quickly update my table with these repeated entries (ensuring that my table then keeps doing its beautiful auto entry of formulas etc). Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You would probably need VBA, can you attach an example of the workbook. Change in sensitive names, etc
ASKER
@Rox Cox ,sigh, I was hoping to do this without macros..am attaching a file with dummy data. Basically I have list of users in the data entry sheet and I want to enter every user again with a row for each mandatory course as on the Course Data sheet - what's the fastest way to do this? Am open to ideas - maybe do it via an Excel 365 form? The idea is to be able to track the people who have courses to do but haven't done them...i.e. you are listed to do a mandatory course but if there is no entry in the start date or finish date - you haven't done it.
EE_how_to_quickly_enter_data.xlsx
EE_how_to_quickly_enter_data.xlsx
How do you know when the next course is due?
ASKER
Have another sheet that will list the courses due with renewal dates etc. But I'm more interested in identifying a way to do a block entry of data e.g. 10 names that have 4 different courses because this is an issue that has come up a few times e.g. if 3 payments are made to the same organisations every month, they need to be entered for every month i.e. each organisation has 3 lines for every month - is there a way to do that...based on what I am seeing so far, it looks like it would have to be a macro scenario...Access would be better but that's not an option...any suggestions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, I thought as much...would it be enough to just record the macro or would there be a bit of extra VBA jiggery-pokery required ?
Recorded macros are generally inefficient. If you want to provide a dummy workbook I'll adapt something that I use.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Roy Cox, that is very close to what I want. I'm attaching a file that shows the sort of data I have and the sort of outcome I'd like to get. Thanks again.
EE_rapid_data_entry.xlsx
EE_rapid_data_entry.xlsx
I'll have a look as soon as I can.
There's no dates in your workbook so do you just want the data copying when a button is clicked?
Also, which sheet is the main data sheet to copy to.
I will probably not be available to answer for a while, I have an appointment later, but I should be able to amend my code for you later.
Also, which sheet is the main data sheet to copy to.
I will probably not be available to answer for a while, I have an appointment later, but I should be able to amend my code for you later.
Still need input from Author to complete
ASKER
Found a workaround with this by using Power Query and merging two data sets..possibly not the most user friendly solution in the history of the Universe but it got the job done. Thanks for all your suggestions though.
ASKER
Thanks for your help - much appreciated as always.
Pleased to help
ASKER