

April 21, 2015

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.


Trusted Members

December 20, 2019



April 21, 2015

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.
1 Guest(s)
