Double Click Macro and Offset Macro help

[johnny_p]

Hi all

I'm just looking to tap into your knowledge for some much needed help if you would be so kind.

My plan/idea is to assign a macro to all cells in column C when you double click any one of the cells.

The macro will need to copy and paste the corresponding data held in the same row in Column A. The data in Column A will always be different so the Macro will need to always select the offset cell which you have double clicked.

I hope this makes sense?

Any help will be greatly appreciated

Thanks

[Norie]

Perhaps.

Please Login or Register  to view this content.

[johnny_p]

Perhaps.

Please Login or Register  to view this content.

Thanks

Yes this does work, however I am trying to get the data held in column A to another sheets ("Selector").Range("A8").

I have tried amending your code but it does not seem to work

[Norie]

You only mentioned columns C and A and I assumed they were on the same sheet.

Can you explain further?

[johnny_p]

Sorry, my apologies

Instead of the data going from the cell in Column A going to Column C, the data in Column A needs to go to another sheet within the workbook ("Selector") cell A8.

It still needs to be activated by Double clicking in the corresponding cell in Column C.

Thanks