Copy Cell Value wich is changing every day to cell in another sheet

Hello,

I have one cell for example in Sheet1 cell E13 which is changing every day. And I want copy value of this cell every day to another sheet to column which is next to column which dates. Its possible?

For example 31.03.2012 I change E13 on "183" and I want that value "183" copy to another sheet

A23 = 31.03.2012 B23 = "183"

next day 01.04.2012 I change E13 to "199" and another sheet must see like

A23 = 31.03.2012 B23 = "183"
A24 = 01.04.2012 B24 = "199"

....etc for 365 days in year.

Thank you.

Give this code a shot, it should go in the sheet module of sheet1

Please Login or Register  to view this content.

from the VBE instead of rightclick and inserting a new module, just double click on the sheet, it will open a code window, you can paste the code in that section.

could you attach the workbook?

this will cause the function to triger when ever there is a change in any cell range E1:E11, regardless of date.

if this is not what you are looking for, could you be more specific as to when you want the macro to trigger?

Please Login or Register  to view this content.

ok, so i could have it trigger based on any entry in E, it will take the value from E1 (the sum) and enter than with today's date on the next sheet, if you update it today, it will just update that value on the other sheet, but if it is a different date, it will create a new line? is that it?

Try this code and sample file, it will do as described in my previous post.

Please Login or Register  to view this content.

glad i could help you out, good luck with the rest of the project.