I have a monthly Excel report I'll call "Report" that I want to reference cells in another workbook "ExternalWB". ExternalWB will have data added to it each month and the current month row is the last data row of Sheet1. There are several cells in Report, Sheet1 tab, that I want to reference the very last data row for columns C, D, E, F in ExternalWB.

I need help with a formula and/or technique to do this.
Jerry

Howdy, Jerry. I was going to answer this, but work has been almost non-stop. Looks like my earliest time to setup and test is next Monday.

Hopefully someone else can provide you with a solution before then.

First we need to count the number of Rows

=countif(C:C,">0") will give a number of cell that are not blank

then we can do a =Index(C:C,countif(C:C,">0"),0)

ill also used the Offset() but that a bit hard to explan

Sub test()
ActiveWorkbook.Sheets("Sheet1").Activate
Range("A1", "A6335").Select


Do Until IsEmpty(ActiveCell) = True

ActiveCell.Offset(1, 0).Select

Loop
ActiveCell.Offset(-1, 0).Select
MsgBox (ActiveCell.Value)


End Sub