princessdy
New Member
- Joined
- Jul 29, 2022
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hello! I hope someone can help me.
I work with a lot of numbers. Here is my dilemma:
I want to designate a reference A1 to any amount I work on coming from different worksheets. What I want is when I designate a reference as A1, the amount of the left of A1 should automatically show under A1, including the description for that amount. The corresponding reference (eg B1, B2) should also show under A1 schedule.
Here is the mini worksheet below. I only link them manually now. But sometimes I have a lot of adjustments I want to show in A1 but I miss some of them.
Right now, the columns are fixed -- meaning all amount will be coming from Column D of that worksheet and all description will be coming from Column B of that worksheet -- all going to A1 column D and B respectively.
Is there any way I can automate this?
I work with a lot of numbers. Here is my dilemma:
I want to designate a reference A1 to any amount I work on coming from different worksheets. What I want is when I designate a reference as A1, the amount of the left of A1 should automatically show under A1, including the description for that amount. The corresponding reference (eg B1, B2) should also show under A1 schedule.
Here is the mini worksheet below. I only link them manually now. But sometimes I have a lot of adjustments I want to show in A1 but I miss some of them.
Right now, the columns are fixed -- meaning all amount will be coming from Column D of that worksheet and all description will be coming from Column B of that worksheet -- all going to A1 column D and B respectively.
Is there any way I can automate this?
Table template.xlsx | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
2 | [Sheet 1] | |||||
3 | A1 | Adjustments | $ | |||
4 | Bank interest income | $ 300.00 | B1 | |||
5 | Bank charges | $ 200.00 | B2 | |||
6 | Total | $5,300.00 | ||||
7 | ||||||
8 | [Sheet 2] | |||||
9 | B1 | Interest income | $ | |||
10 | Bank interest income | $ 300.00 | A1 | |||
11 | Loan interest income | $5,000.00 | ||||
12 | Total | $5,300.00 | ||||
13 | ||||||
14 | [Sheet 3] | |||||
15 | B2 | Expenses | $ | |||
16 | Bank charges | $ 200.00 | ||||
17 | Service fee | $ 150.00 | B2 | |||
18 | Total | $5,300.00 | ||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B4,D4 | B4 | =B10 |
B5,D5 | B5 | =B16 |
E4 | E4 | =B9 |
E5 | E5 | =B15 |
D6,D18,D12 | D6 | =SUM(D4:D5) |
E10 | E10 | =B3 |
E17 | E17 | =B15 |