copy manual selection, then paste

I get a worksheet each week with about 27 pages of data. I currently select a range of cells, copy, then paste to another sheet, which outputs some results, then repeat about 100 times.

I have created a button on sheet2, I would like to manually select the range of cells, then click this button and have it paste the selected cells to sheet1!F3.

Thank you for your assistance. This would save me about an hour each week.

Hi iturnrocks,

This code will take whichever cells you have selected and paste them to Sheet1!F3:

Please Login or Register  to view this content.

However, it will not clear out the previous range of data you pasted, so if you're pasting selections of various sizes, old data may be left showing after pasting a smaller range of cells. This, of course, can be handled in VBA, too.

That works great! Thank you.

I have another button on Sheet1 that says Next. When I click it, it clears all the data from F3:G1000 and sends me back to Sheet2.

One other thing I need-

The data that is pasted to F3 goes thru a series of filters and the results are shown in A1:A540. I then copy and paste this data to a different workbook.

I would like a button that selects and copies A1:A540

In the other workbook, it goes in various locations so I will just manually paste there.

Thanks again.

Hey again,

I would think you could simply use:

Please Login or Register  to view this content.

Thanks again. Im pretty new to VBA, and although I have learned a lot since finding this forum last year, I seem to have missed most of the basics.