Select Visible Cells in Specific Columns

Hi Guys,

Ok, this might be quite tricky to explain but please bare with me.

I have a spreadsheet (which is used as an order form and contains historical order information). I need to select the new products and copy & paste this onto a different sheet.

I intend to Auto-Filter the sheet to show the new products and then select the specific columns I need to copy.

This means that the first visible row below the header is always different. Also, the only columns I need information for are Columns E, H:J, M and P.

However I am getting really stuck on selecting the specific columns I need whilst, which makes me wonder if I'm barking up the wrong tree entirely!

I've been experimenting with combining Union,

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

but I've only managed to get confused.

I don't suppose anyone would be able to assist? I have some example codes if it helps make things clearer...

Many Thanks,
Ryan

This would assume that you are filtering on Column D. Not sure if this helps.

Please Login or Register  to view this content.

Thanks guys, thanks for your responses. Sorry for the delay in replying, by the way.

I've been experimenting with this and it appears to work well (the copy & paste comes after):

Please Login or Register  to view this content.

I shall play around with both of your ideas - John, your idea seems very appealing. I'll let let you know what happens.

Thanks again,
Ryan

I should mention, I saw the code in aother post:

http://stackoverflow.com/questions/1...anges-with-vba

Hi Harry,

I've attached it at this link.