how to create a running list on one sheet using data from another

[masterintraining]

As part of an ISO process metric I want to track backlog of parts in a certain department. Luckily, there is a spreadsheet already in use that is updated each day. I modified that sheet so that the backlog of parts is calculated and summed into a single cell. What I need now is for that number, each day, to be logged or listed on a separate sheet. Copy/paste would work but shop guys will struggle. I hope I can get advise on how to automate. Scenario: Shop updates the working sheet first thing. (my backlog sum changes) They click a macro button and the changed sum is copied to sheet 2, column A, next available cell. After 30 days of updating the working sheet and running the macro I can look at sheet 2 and see 30 entries in column A, each corresponding to the backlog for that day. Help on getting this done is much appreciated.

[AlvaroSiza]

What is the location of the 'single cell' calculation (the source)?

[masterintraining]

source is sheet 1, cell G1
I want to move the value to sheet 2, column A, descending with a new entry each day.

[AlvaroSiza]

I think this will do what you are after. Please make a copy of of your workbook and test it.

Please Login or Register  to view this content.

[masterintraining]

AlvaroSiza rocks! I made some small changes in order to auto open when the workbook is opened. That was an easy mod, having your code already. Works great. Thanks.