VBA to copy visible (NOT hidden) rows of data to another tab

[NeerajS]

Hi,
I came across a similar thread VBA to copy range data with all visible and invisible cells to another sheet on MrExcel.com and was hoping to get some assistance on my scenario which is as follows:

What I have on a tab (name: origin)

Station	People	Cars
A	12	29
B	6	10
C	4	2
TBC (This row is hidden)
TBC (This row is hidden)
P	11	20

What I would want to be copied (only the visible rows) on another tab (name: destination)

Station	People	Cars
A	12	29
B	6	10
C	4	2
P	11	20

Also, I have some 10 tabs similar to origin, and was hoping to append all of them into the destination tab.
(I mean finding the next empty row in destination and then copying visible rows from subsequent tabs.)

I'll really appreciate any assistance on this query.

Thanks in advance.

Regards
NeerajS

 

[davesexcel]

Why not search for copying visible cells?

 

[NeerajS]

Why not search for copying visible cells?

Hi davesexcel
Thanks for replying.
I accessed the link, but wasn't able to find content for one of the listed options "Find Data copy and Paste to a new location-Excel VBA sample workbook"

Could you please share the same with me.

Thanks

 

[davesexcel]

That link you are referring to is in my signature, it is not part of the answer to your question.

The link you provided "copy range data with all visible and invisible cells".

I suggested to search instead for "copying visible cells" there are tons of threads on that.

A better string to search for: "excel VBA copy/paste visible cells"