Return number from the last filled row of the last worksheet

DH613

New Member
Joined
Dec 3, 2019
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
Hi!
I am trying to reference a number from the last filled row in column "I" on the last worksheet in a different workbook.
The workbook I'm updating contains the expected end of month revenue of business this month.
The workbook I'm referencing contains the expected commissions we will need to pay our sales team.
That number is always contained in the last sheet of that workbook, I add a new sheet every month.
That number is also always contained in the last filled row in column "I" of that sheet, the row number changes based on the active salespeople that month.
So basically, I want to add The last filled row of Column"I" in the last sheet of workbook "commissions" to the outgoing monies in this months workbook.
Any help would be greatly appreciated.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

DH613

New Member
Joined
Dec 3, 2019
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
This is what I tried, but it doesn't seem to work.
I put a VBA for LastSheetName() in the "commissions" workbook:

Public Function LastSheetName()
Application.Volatile
LastSheetName = ThisWorkbook.Sheets(Sheets.Count).Name
End Function

I then tried to reference that using the INDIRECT formula.
The problem I encountered was that the first code returned different answers than were actually true!!
 

Watch MrExcel Video

Forum statistics

Threads
1,129,593
Messages
5,637,294
Members
416,963
Latest member
zazama

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top