Need to return a cell's value from a cell that changes number of rows each day

[johnsvikings]

I am in need of the VBA code for the following:
1. I am starting in cell B3 on worksheet "Mapped_Totals"
2. I need to retrieve the last cell value in column B on worksheet "Baltimore". This column has 3 blank cells then a header column labeled "0-30 days" and then the data flows after that (each new daily report may have a different number of rows/customers listed and I only need the total for that column B on worksheet "Baltimore") and put it back in cell B3 on worksheet "Mapped_Totals"

 

[Fluff]

Hi & welcome to MrExcel.
How about

   Sheets("Mapped_Totals").Range("B3").Value = Sheets("Baltimore").Range("B" & Rows.Count).End(xlUp).Value

 

[johnsvikings]

That worked great! Thanks so much

 

[Fluff]

You're welcome & thanks for the feedback

 

[johnsvikings]

What if the cell value is a text like ("37 customers") and I only want to retrieve all characters from the left minus the 1st ten (would leave off " customers"?

 

[johnsvikings]

I meant from the right, sorry!

 

[Fluff]

If you want everything before the first space try

With Sheets("Baltimore").Range("B" & Rows.Count).End(xlUp)
   Sheets("Mapped_Totals").Range("B3").Value = Left(.Value, InStr(1, .Value, " ") - 1)
End With