copy paste macro help

[derek7467]

Hi! The below code works fine. Wht I need is when the copy function happens, to skip row A since I don't need the headers:

Please Login or Register  to view this content.

[AB33]

Derek,
Please use code tags with your code as per forum's rule.

Please Login or Register  to view this content.

[derek7467]

sorry about that. Thanks for the help!

[derek7467]

Weird, now its creating 2 blank rows after it, before it didnt. It does what i asked (appends just the data and not the headers).

Please Login or Register  to view this content.

[AB33]

I do not see what are in your data. Please attach your sample

[derek7467]

Attached a copy of my xlsm

[AB33]

Derek,
Usedrange is not 100% reliable. It looks at the entire row for data. Despite some cells appear to be blank, they may not be empty, hence the code assumes that there are data to be copied.
I have adjusted the code to use column range.