Please Login or Register to view this content.
I am trying to copy non adjacent cell from Invoice sheet and past the in Register sheet in consecutive row starting in A5- D5. I have tried the VBA below however , it copies all the non adjacent cell in A5 one at a time. how do I get them to go A5, B5, C5, D5, then next transfer to the last row.
Bookmarks