Excel simulation help (Auto copy and paste)

[beamthegreat]

I have a complex simulation that displays different values on cell A1 upon editing any cell. I want to create a histogram for these data but instead of manually copying and pasting hundreds of times, is there anything I can do to make excel copy and paste the value on cell A2,A3,A4....etc each time the spreadsheet is edited?

Thanks in advance!

PS: In case I wasn't clear, the picture below should explain everything:

https://s32.postimg.org/cme49w2xh/image.png

In the case above, I could simply drag the values to the right but I cannot do that in my original simulation since it is too complex.

[MarvinP]

Hi beamer,

"Each time the sheet is edited" implies you need an EVENT macro that lives behind the worksheet. The event is "On_Change" and will trigger whenever something on that worksheet is changed. Then you need to find the LastRow in Column A and put something in it. I guess showing you is easier than telling you. See the attached with this code.

Please Login or Register  to view this content.

Log any sheet change in Col A.xlsm

[beamthegreat]

Hi beamer,

"Each time the sheet is edited" implies you need an EVENT macro that lives behind the worksheet. The event is "On_Change" and will trigger whenever something on that worksheet is changed. Then you need to find the LastRow in Column A and put something in it. I guess showing you is easier than telling you. See the attached with this code.

Please Login or Register  to view this content.

Attachment 469034

Thank you for your quick response! Unfortunately, I do not know how to code in excel. Could you please send me the code and tell me where I should paste it?

[beamthegreat]

Nevermind! I changed the Now() part to Range("A1") and got it working! Thank you so much.