Consolidate Data from one tab to another

[rlsublime]

How could I edit the following code to take all non-blank cells from A2:E2 onwards and paste them in the OVERTIME_Condolidated tab from A2:E2 onwards. also i am trying to get it to keep pasting under the last entry every time the code is run again.
Thanks for the help

Please Login or Register  to view this content.

[Thalassa]

Try

Please Login or Register  to view this content.

[Thalassa]

Better

Please Login or Register  to view this content.

[rlsublime]

Thanks that worked, but instead of specifying the range ("A2:E7") is there a way to say copy anything within A2:E2 onwards...A1 to E1 has the headings.. but a to e has the data and the data will always have a different range. Thanks for the help

[Thalassa]

See my "better" offering http://www.excelforum.com/showthread...=1#post2832750

[rlsublime]

Thanks Thalassa! That workerd perfectly. How would I create code to clear consolidate data?For eg, I want to clear all non blank cells from A2 to E2 onwards? Thanks

[Thalassa]

Untested but try

Please Login or Register  to view this content.

[rlsublime]

This works if I click it once. But if the user clicks it twice by mistake then it deletes the headers as well and moved the button also. Any way to fix this . thanks

Please Login or Register  to view this content.

[Thalassa]

Try

Please Login or Register  to view this content.