PDA

View Full Version : paste to another open workbook and return to original worbook



sncr137
06-04-2017, 08:24 AM
Here is what I am hoping to do:

I have a website that I open excel reports from. I need to copy the tables of each report and then paste them on top of each other in a new workbook creating one long report. Since I have to open each report individually, all 146 of them every two weeks, I need the macro to be on the quick access tool bar. With that said, here are the nuts and bolts:

In the open report, I would like to select "A3:I3" and a variable range down.
Then Copy
Then activate the new workbook, typically named Book1 (I rename and save it after completing the process)
Select cell "A1", or the next empty cell down
paste as values
reactivate original workbook
select cell A3

Thanks for any response and let me know if there are questions.