Forum

VBA copy from one t...
 
Notifications
Clear all

VBA copy from one table another - how to code for paste values

3 Posts
2 Users
0 Reactions
128 Views
(@crainaud)
Posts: 35
Trusted Member
Topic starter
 

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.

 
Posted : 24/04/2020 12:51 pm
(@purfleet)
Posts: 412
Reputable Member
 

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

 
Posted : 24/04/2020 1:22 pm
(@crainaud)
Posts: 35
Trusted Member
Topic starter
 

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.

 
Posted : 24/04/2020 2:46 pm
Share: