Copy/Paste

[Shamsuddin M]

I am new to VBA someone please help me ,
My data Range is ("A2:H17"), this may vary, I mean the row will sometimes till H16, some times H3, etc.,
Coloumn "E" is always with some value(some name)
I want to copy only the populated rows and paste it in next sheet.
when I tried to do it with a macro recording, it is copying the entire range ("A2:H17") and pasting it in the next sheet. with lots of blank rows in each time.

 

[SanjayGMusafir]

I tried to do it with a macro recording

I would suggest post your recorded macro here along with a sample data and explain what exactly you want to get from VBA.

This makes convenient for anyone who wants to help you.

 

[Shamsuddin M]

Thanks in advance

 

[Shamsuddin M]

View attachment 74779View attachment 74780
Thanks in advance

 

[Shamsuddin M]

I would suggest post your recorded macro here along with a sample data and explain what exactly you want to get from VBA.

This makes convenient for anyone who wants to help you.

Sir, thanks in advance.
Here I have attached the details