VBA to Copy Columns Using Headers but Ignore Columns without Data

[phelbin]

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

[jolivanes]

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.

[phelbin]

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

[Winon]

Hello phelbin,

If I look at your issue from a different angle, is it not true that you actually only want to hide "Empty" Columns in "TimeSheet1"?

Regards.

[phelbin]

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.

[AB33]

Please Login or Register  to view this content.

[phelbin]

AB33, that worked perfectly!! You are awesome!

[Winon]

Hello phelbin,

Try it this way,

Please Login or Register  to view this content.

@ AB33,

Great stuff my friend!

Regards.