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.
LVL 1
agwalshAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
You could have  have a separate table of recurring entries and use multiple tables to create a PivotTable
agwalshAuthor Commented:
I have a table set up with the entries as a dropdown for accurate entry...but let's say a user wants to quickly enter all the payees rather then individually choosing them...any suggestions?
Roy CoxGroup Finance ManagerCommented:
You would probably need VBA, can you attach an example of the workbook. Change in sensitive names, etc
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

agwalshAuthor Commented:
@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
Roy CoxGroup Finance ManagerCommented:
How do you know when the next course is due?
agwalshAuthor Commented:
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?
Roy CoxGroup Finance ManagerCommented:
I don't think you will manage without a macro, if you try using formulas you would need toa use probabaly TODAY(), but that is volatile so it would not change.

I would have a list of recurring entries then a macro to transfer the data that you select.
agwalshAuthor Commented:
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 ?
Roy CoxGroup Finance ManagerCommented:
Recorded macros are generally inefficient. If you want to provide a dummy workbook I'll adapt something that I use.
Roy CoxGroup Finance ManagerCommented:
Here's a very quick example, is this something like what you want?
AutoUpdate.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
agwalshAuthor Commented:
@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
Roy CoxGroup Finance ManagerCommented:
I'll have a look  as soon as I can.
Roy CoxGroup Finance ManagerCommented:
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.
Roy CoxGroup Finance ManagerCommented:
Still need input from Author to complete
agwalshAuthor Commented:
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.
agwalshAuthor Commented:
Thanks for your help - much appreciated as always.
Roy CoxGroup Finance ManagerCommented:
Pleased to help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.