Use a macro to copy data from rows into destination range
Closed
Subradeep
-
Updated on Dec 19, 2017 at 12:37 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Dec 19, 2017 at 01:32 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Dec 19, 2017 at 01:32 AM
Hello,
I want to create a macro to copy data from one range (eg. A2 to C2) and paste it to another destination in the same file.
then select next range (eg. A3 to C3) and paste is to same destination as earlier.
this needs to be done for n no. of rows.
can anyone help with a macro?
Can we create a button or something, so each time we click the button the next row gets selected and copy pasted to desired destination.
PS. the destination is fixed. Only the range selection varies
I want to create a macro to copy data from one range (eg. A2 to C2) and paste it to another destination in the same file.
then select next range (eg. A3 to C3) and paste is to same destination as earlier.
this needs to be done for n no. of rows.
can anyone help with a macro?
Can we create a button or something, so each time we click the button the next row gets selected and copy pasted to desired destination.
PS. the destination is fixed. Only the range selection varies
Related:
- Use a macro to copy data from rows into destination range
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Data transmission cable - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Dec 19, 2017 at 01:32 AM
Dec 19, 2017 at 01:32 AM
Hello Subradeep,
If you use another column with a certain criteria placed at the end of a relevant row of data, this can be done for all the relevant rows of data together. Are you open to suggestions?
Cheerio,
vcoolio.
If you use another column with a certain criteria placed at the end of a relevant row of data, this can be done for all the relevant rows of data together. Are you open to suggestions?
Cheerio,
vcoolio.