Johnny_Human_Torch
New Member
- Joined
- Nov 16, 2005
- Messages
- 3
Hi all, sorry if this is the wrong place for this or if it's so basic it's been covered. If it has, I'd appreciate a nudge in the right direction.
I recorded a simple macro that copies values from sheet one coming from various unformatted places and moves them to sheet two in the same row. It works great, however, because I recorded it, it does the same thing over and over into the same row.
My question is, how do I make the macro paste to a row, then advance the cursor to the next row, then paste it again across the next sequential row?
I know my range is defined as the particular cell, and I should have a more general definition, but again, I don't know how. And I'm not sure how to advance the cursor to the next row.
I'll post what I have in the next post for anyone that would like to see it.
I recorded a simple macro that copies values from sheet one coming from various unformatted places and moves them to sheet two in the same row. It works great, however, because I recorded it, it does the same thing over and over into the same row.
My question is, how do I make the macro paste to a row, then advance the cursor to the next row, then paste it again across the next sequential row?
I know my range is defined as the particular cell, and I should have a more general definition, but again, I don't know how. And I'm not sure how to advance the cursor to the next row.
I'll post what I have in the next post for anyone that would like to see it.