Copy a changing cell value onto another worksheet to create a history of values.

[cykamourn]

Hello, first off thanks for your guy's help in advance!

I'm trying to get my "History" sheet to update based on a inputs from a single cell within my "Leather" sheet. I manually change two values (C4 and C5) pretty often but instead of just losing the previous entries I'd like for them to auto populate my "History" sheet.

I know this is not correct coding as I'm very new with excel but I feel this describes what I'm trying to achieve.

Please Login or Register  to view this content.

These cell values are accurate to my attached sample workbook.

Thanks again!ExcelSample.xlsx

[cykamourn]

Found a solution after continuing to search.

Here's a solution that works for anyone else whom is interested.

Please Login or Register  to view this content.

[FoZi]

Found a solution after continuing to search.

Here's a solution that works for anyone else whom is interested.

Please Login or Register  to view this content.

Hi there,

Thanks for this solution. I was testing it and it really works. I just need to make a single change and i don't know why it's not working. Instead of recording all the changes of a single cell (ie: C4 in your case for example) i would like to record all the changes that are made in "column C" . I was testing with "C:C" but it doesn't seem to work. Can you guys help me with that ? I would like to record every change that it's made in a particular column but i don't know what i'm doing wrong.

Thanks in advance