Prabhudharun
New Member
- Joined
- Feb 22, 2018
- Messages
- 7
Hi,
I have n number of sheets in the workbook. Sheet 1 contains Customer name on column A, Sales amount on column B.
<tbody>
</tbody>
sheet 2 name is Srinivasan and last row of Column D has sales amount
<tbody>
</tbody>
sheet 3 name is Prabhu and last row of column D has sales Amount
<tbody>
</tbody>
N number of sheets has the sales amount on last row of Column D.
now i need, in sheet 1, against each customer sales amount on column B.
Any help would be much apreciated.
I have n number of sheets in the workbook. Sheet 1 contains Customer name on column A, Sales amount on column B.
A | B |
Customer Name | Sales Amount |
Srinivasan | |
Prabhu | |
N number or Rows |
<tbody>
</tbody>
sheet 2 name is Srinivasan and last row of Column D has sales amount
A | B | C | D |
1 | 10/8/2019 | 500 | 500 |
2 | 12/8/2019 | 300 | 800 |
3 | 13/8/2019 | 400 | 1200 |
<tbody>
</tbody>
sheet 3 name is Prabhu and last row of column D has sales Amount
A | B | C | D |
1 | 15/8/2019 | 2000 | 2000 |
2 | 16/8/2019 | 1000 | 3000 |
3 | 17/8/2019 | 500 | 3500 |
<tbody>
</tbody>
N number of sheets has the sales amount on last row of Column D.
now i need, in sheet 1, against each customer sales amount on column B.
Any help would be much apreciated.