Hi,
I'm setting up a form in an excel table for the user to make daily entries, then at the end of each day, the data will be copied into a summary table and the daily entry table will be cleared for the next day.
My issue is the last line of code to paste values into the second table does not work. I'm sure it's something minor.
I've attached the file.
Any assistance is appreciated! Thanks.
Hi Carolyn
I assume you are talking about the Test() sub as is the only one in that workbook but its not the one referenced by the Complete Button?
The test sub seems to worlk fine for me, do you get an error?
Purfleet
OMG! Yes it is working...
When I cleaned up the file (removed a number of tabs etc.) to attached the file to this request it must have cleaned up the problem?
It's been a while since I've been in VBA land and it's just one of those days.
Thanks for taking a look and responding.