I have 6 cells, A1-A6 in Sheet1.
A1,A3,& A5 contain numbers 1-3
A2,A4,& A6 contain the date the numbers changed.
A1 & A2 will be filled first. I want to display both cells in Sheet2 in B1 & B2.
When A3 & A4 are filled, I want to replace the contents of B1 & B2 with the new data.
Similarly, when A5 & A6 are filled I want to replace the contents of B1 & B2 with the new data.
I need to keep all the data in Sheet1 but only want the latest data displayed in Sheet2.
Is there a formula that can do this as I need it automatically? I am unable to use VBA or macros to do this.
No comments:
Post a Comment