I have been provided with dynamic cell A1 inside workbook1 sheet1, which updates with temperature value once a day. I need to keep a log of monthly temperature variation and store it inside another workbook2 sheet2 column B across Column A that contains prefilled Dates (for example from 1-May-2024 to 31-May-2024). How can accomplish that using excel formula inside column B to avoid manual copying and pasting? I already know VBA version , I need easier way with formulas and logic.
Example.
Inside A1 cell dynamically changes value (lets say today 1-May-2024 temperature[20], but tomorrow 2-May-2024 temperature will show [25])
“Workbook1
Sheet1 ( 1-May-2024)”
Cell: A1 – Today shows value “20”
| ColumnA | ColumnB |
|---|---|
| 20 |
“workbook1 Sheet1 (2-May-2024)” Cell: A1 – Tomorrow shows value “25”
| ColumnA | ColumnB |
|---|---|
| 25 |
“What I need is to show in Workbook2, Sheet2 TODAY”
| Dates | ColumnB |
|---|---|
| 1-May-2024 | 20 |
| 2-May-2024 |
“I need in Workbook2, Sheet2 TOMORROW”
| Dates | ColumnB |
|---|---|
| 1-May-2024 | 20 |
| 2-May-2024 | 25 |
And so on. I need this workbook2 to update automatically when I open it. I intend to open it once a day everyday. Without VBA help.