Hi all,
I've seen many similar requests for help to this but I cannot put it all together to get the desired result and would greatly appreciate some help.
I have assigned a macro to a button on a sheet and would like the macro to do the following:
Copy a range from U to AW. The 1st row is 4 and the last would be variable to the last used row.
Paste this data to a closed workbook that originates in the same file. I'd need to select "sheet2" to paste to and to paste from the 1st blank row. The range of columns to paste to is A to AC.
Thanks all and apologies this is so similar to a number of other questions.
Chris
I've seen many similar requests for help to this but I cannot put it all together to get the desired result and would greatly appreciate some help.
I have assigned a macro to a button on a sheet and would like the macro to do the following:
Copy a range from U to AW. The 1st row is 4 and the last would be variable to the last used row.
Paste this data to a closed workbook that originates in the same file. I'd need to select "sheet2" to paste to and to paste from the 1st blank row. The range of columns to paste to is A to AC.
Thanks all and apologies this is so similar to a number of other questions.
Chris