auto.pilot
Well-known Member
- Joined
- Sep 27, 2007
- Messages
- 734
- Office Version
- 365
- Platform
- Windows
I have an error prone process whereby users copy a range of data from one workbook (source) and paste values it into another workbook (destination). There are a couple hundred different source and destination workbooks. As an example, errors occur when the existing destination workbook includes 1,200 rows and the source book data has 1,000 lines. Users are instructed to click a button which clears out the destination workbook, but this step is sometimes skipped. As such, 200 line items at the bottom of the data will remain in place, but should have been cleared out. I am seeking a method to disable the Paste function until the Clear button is clicked.
How can I do this?
Thanks in advance.
How can I do this?
Thanks in advance.