loop through each sheet last row

[Prabhudharun]

Hi,

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.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...gh-each-last-row-post5341084.html#post5341084

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.