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.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Customer Name[/TD]
[TD]Sales Amount[/TD]
[/TR]
[TR]
[TD]Srinivasan[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Prabhu[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]N number or Rows[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]









sheet 2 name is Srinivasan and last row of Column D has sales amount

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10/8/2019[/TD]
[TD]500[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12/8/2019[/TD]
[TD]300[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]13/8/2019[/TD]
[TD]400[/TD]
[TD]1200[/TD]
[/TR]
</tbody>[/TABLE]







sheet 3 name is Prabhu and last row of column D has sales Amount

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]15/8/2019[/TD]
[TD]2000[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]16/8/2019[/TD]
[TD]1000[/TD]
[TD]3000[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]17/8/2019[/TD]
[TD]500[/TD]
[TD]3500[/TD]
[/TR]
</tbody>[/TABLE]







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.