youngbella
New Member
- Joined
- Sep 27, 2020
- Messages
- 19
- Office Version
- 2010
- Platform
- Windows
Hi, I'm new to VBA.
I have some problem which I have some list of data and I need to transfer the list to other sheet. For each list, I need to skips 7 blanks cell for remark. I tried to copy and paste and do some looping but it didnt work.
The code does copy the data but it did not skips 7 blank rows when pasting. very grateful if you could help me.
Below is the list and the outcome that I need.
I have some problem which I have some list of data and I need to transfer the list to other sheet. For each list, I need to skips 7 blanks cell for remark. I tried to copy and paste and do some looping but it didnt work.
The code does copy the data but it did not skips 7 blank rows when pasting. very grateful if you could help me.
Below is the list and the outcome that I need.