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.
Bookmarks