VBA to Copy Columns Using Headers but Ignore Columns without Data

Hi!

I use the following code to move data from one worksheet to another using column headers (see attached workbook). My issue is that if there isn't data in the column it copies the header into the second row.

Is it possible to ignore columns without data?

Please Login or Register  to view this content.

Thanks!!
Kate

Have not checked anything but noticed the period missing in front of Rows.
Does that make a difference?

Please Login or Register  to view this content.

Thanks for your help, Jolivanes! But the period doesn't change anything.

No, I don't want to hide the empty columns on the Timesheet1 tab. This file goes to payroll and they want to keep it all visible.

I could do a second bit of code that would delete non-numbers in that range. But I'd rather alter the code to account for it.

Please Login or Register  to view this content.

AB33, that worked perfectly!! You are awesome!