kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 928
- Office Version
- 365
Hi,
I have the following table:
In Sheet 1, I have the actual expenses. In Sheet 2, I have the budgeted expenses. In Sheet 3, I would like to populate only the details from Sheet 2 after the last date of Sheet1. In this case, the last date in Sheet 1 is 20 Nov 2023. As such, the details from 21 Nov 2023 to 30 Nov 2023 from Sheet 2 should be populated in Sheet 3. Is this possible via a formula ? The correct result is shown in Sheet 3. Appreciate all the help.
I have the following table:
Book2.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | |||
2 | Sheet 1- Actual Expense | Sheet 2- Budgeted Expense | Sheet 3- Balance Budgeted | ||||||||||
3 | Date | Expense | Amount | Date | Expense | Amount | Date | Expense | Amount | ||||
4 | 12/11/2023 | Food | 50 | 12/11/2023 | Food | 35 | 21/11/2023 | Food | 35 | ||||
5 | 13/11/2023 | Travel | 50 | 13/11/2023 | Travel | 35 | 22/11/2023 | Travel | 35 | ||||
6 | 14/11/2023 | Gadgets | 50 | 14/11/2023 | Gadgets | 35 | 23/11/2023 | Gadgets | 35 | ||||
7 | 15/11/2023 | Food | 50 | 15/11/2023 | Food | 35 | 24/11/2023 | Food | 35 | ||||
8 | 16/11/2023 | Travel | 50 | 16/11/2023 | Travel | 35 | 25/11/2023 | Travel | 35 | ||||
9 | 17/11/2023 | Gadgets | 50 | 17/11/2023 | Gadgets | 35 | 26/11/2023 | Gadgets | 35 | ||||
10 | 18/11/2023 | Food | 50 | 18/11/2023 | Food | 35 | 27/11/2023 | Food | 35 | ||||
11 | 19/11/2023 | Travel | 50 | 19/11/2023 | Travel | 35 | 28/11/2023 | Travel | 35 | ||||
12 | 20/11/2023 | Gadgets | 50 | 20/11/2023 | Gadgets | 35 | 29/11/2023 | Gadgets | 35 | ||||
13 | 21/11/2023 | Food | 35 | 30/11/2023 | Gadgets | 35 | |||||||
14 | 22/11/2023 | Travel | 35 | ||||||||||
15 | 23/11/2023 | Gadgets | 35 | ||||||||||
16 | 24/11/2023 | Food | 35 | ||||||||||
17 | 25/11/2023 | Travel | 35 | ||||||||||
18 | 26/11/2023 | Gadgets | 35 | ||||||||||
19 | 27/11/2023 | Food | 35 | ||||||||||
20 | 28/11/2023 | Travel | 35 | ||||||||||
21 | 29/11/2023 | Gadgets | 35 | ||||||||||
22 | 30/11/2023 | Gadgets | 35 | ||||||||||
Sheet1 |
In Sheet 1, I have the actual expenses. In Sheet 2, I have the budgeted expenses. In Sheet 3, I would like to populate only the details from Sheet 2 after the last date of Sheet1. In this case, the last date in Sheet 1 is 20 Nov 2023. As such, the details from 21 Nov 2023 to 30 Nov 2023 from Sheet 2 should be populated in Sheet 3. Is this possible via a formula ? The correct result is shown in Sheet 3. Appreciate all the help.