Shamsuddin M
New Member
- Joined
- Sep 26, 2022
- Messages
- 6
- Office Version
- 2013
- Platform
- Windows
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.
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.