Hello, fairly new to VB and I've tried to do this with limited success. I have a worksheet with data in columns A, B, C, D.
Basically I would like the user to be able to select two rows of data for use in calculations elsewhere in the sheet. I'd like them to be able to double click on the first desired cell in column A (e.g. A15) and the data in adjacent cells in columns B, C, and D (e.g. B15, C15 and D15) be copied to N1, O1 and P1 respectively. On double clicking a second cell in column A (e.g. A20) the same will happen except the data (B20, C20, D20) will be pasted into N2, O2 and P2 respectively.
If the user clicks on a third cell in column A it will do the same but overwrite the data in N1, O1 and P1. So basically it will just keep cycling between pasting in N1:P1 and N2:P2.
Is this possible? Hope I've been clear enough.
Thank you for any help
Bookmarks