VBA to double click a cell and paste value into different worksheet

**Ozarius** · 02-08-2015, 04:54 PM

I am a total rookie at VBA, so please be patient. I have a workbook with 19 worksheets (all have different names other than “Sheet1”, “Sheet2”, etc.) On worksheets 2 through 15, I would like to be able to double-click in any cell in column A and automatically perform the following: (1) copy and paste (values only) that cell’s contents into the next empty row of column D of worksheet 16, and (2) go to that column D cell in worksheet 16. Please note that column A of worksheets 2 through 15 is protected such that a “read only” error message is generated when double-clicked now. Please help me set up the VBA code for this.

**davesexcel** · 02-08-2015, 05:10 PM

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Ozarius** · 02-08-2015, 06:18 PM

Here's the sample workbook. I had to delete some of the sheets to make it fit the 1 MB requirement. Also, per the VBA editor, it appears that the sheets 2 through 15 I previously referenced should now be sheets 9 through 19, and the sheet 16 should be sheet 2 ("Transactions"). Thanks.