Hello all,
First time poster here, with a question about how to handle something.
I have a spreadsheet that I maintain, where I copy data in from a report. As I copy in this data, I'd like Excel to copy/paste from a cell for each item copied. So an example
The sheet is currently populated to Row 1816.
I now paste 200 more rows in one lump, with columns 1-8. I'd like the worksheet to copy for each of these rows from cell R2, and R3, and paste them in column 9 & 10 respectively for each line.
I'd like to share the workbook; however the information contained is financial and I'm not certain of how that would work.
Is what I am looking for possible? Can someone help with the code and explain it so that I learn as well?
First time poster here, with a question about how to handle something.
I have a spreadsheet that I maintain, where I copy data in from a report. As I copy in this data, I'd like Excel to copy/paste from a cell for each item copied. So an example
The sheet is currently populated to Row 1816.
I now paste 200 more rows in one lump, with columns 1-8. I'd like the worksheet to copy for each of these rows from cell R2, and R3, and paste them in column 9 & 10 respectively for each line.
I'd like to share the workbook; however the information contained is financial and I'm not certain of how that would work.
Is what I am looking for possible? Can someone help with the code and explain it so that I learn as well?