Ask Your Question

How can I have a cell show the value of another cell only during a 1 month window?

asked 2016-05-11 05:53:17 +0100

Anov229 gravatar image

Here's the beginning of my formula: =IF(SUM(E44:E51)>0, "",)

For the "otherwise" portion I want it to show the value that a cell in another sheet had during a date window and hold that value even if the cell from the other sheet changes in value, is this possible?

I may not be clear here so I'll explain again in a different way. If the cell in sheet1J84 currently reads 25 on May 10, 2016 then I want the cell Sheet2E43 to read 25 as well, If cell Sheet1J84 is changed to 30 on May 21, 2016 then I want Sheet2E43 to change to 30, but if Sheet1J84 is changed to 10 on say June 3, 2016 (or any day after May 31) I still want cell Sheet2E43 to read 25 and never change again.

Is there anyway of making this happen?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-05-11 12:38:18 +0100

Lupp gravatar image

updated 2016-05-11 12:39:12 +0100

Spreadsheets are not history aware. Thus what you want cannot be done without a severe violation of the basics. If you dedicate, adjacent to sheet1.J84 e.g., as many cells as needed to contain dates of editing and previous values, You have to ensure that they are used in the correct way. Again violating the spreadsheet paradigm you may, however, do this relying on a "macro" assigned to the appropriate sheet event. You should try to avoid these complications.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-11 05:53:17 +0100

Seen: 27 times

Last updated: May 11 '16