loop through each sheet last row

Status
Not open for further replies.

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.

AB
Customer NameSales Amount
Srinivasan
Prabhu
N number or Rows

<tbody>
</tbody>









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

ABCD
110/8/2019500500
212/8/2019300800
313/8/20194001200

<tbody>
</tbody>







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

ABCD
115/8/201920002000
216/8/201910003000
317/8/20195003500

<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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,717
Office Version
365
Platform
Windows
Duplicate https://www.mrexcel.com/forum/excel-questions/1109659-loop-through-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.

 
Status
Not open for further replies.

Forum statistics

Threads
1,085,419
Messages
5,383,555
Members
401,836
Latest member
Bweston07

Some videos you may like

This Week's Hot Topics

Top