Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet?

Hi all,

I need (in a hurry) a simple macro that recognizes a clicked cell and transfers the contents of that cell to another accumulating sum of the contents of the cells clicked. Any help is highly appreciated. Thanks much in advance.

Best, Nash

Originally Posted by naragam

Hi all,

I need (in a hurry) a simple macro that recognizes a clicked cell and transfers the contents of that cell to another accumulating sum of the contents of the cells clicked. Any help is highly appreciated. Thanks much in advance.

Best, Nash

Thank you very much for helping me. It looks good and I will be trying it out immediately!

Best, Nash

Thank you very much for helping me. It looks good and I will be trying it out immediately!

Best, Nash

Originally Posted by porucha vevrku

Accumulating sum in "G2" cell of active sheet:

Please Login or Register  to view this content.

Hi again,

I am not sure what might be wrong with my Office 365 Excel version, but I can't seem to be able to get your code plugged into my spreadsheet and debug using stepping line by line. I can't get into execution mode although I am using the "Developer" tab needed in my Excel top menu! Can you please give me some simple instructions to plug in the macro into my worksheet? It's been a while since I have used macro in my excel and it looks like I need a tutorial. Any help?

Thanks much in advance,

Nash

Copy code, then right (mouse button) click on any/some sheet tab (e.g. "Sheet1") and choose 'View Code', then paste code in sheet module.
Change "G2" to the cell address where you want to sum the values from other cells you clicked, then close sheet module.