ok got this far and the masg box shows last row values but having trouble on figuring out how to put those values in Sh5 column O , so it finds the last row in sheets 1 -4 , just want to paste the last row value into 4 cells starting at O1= lastrow hS1, O2=lastrow Sh2,O3= lastrow Sh3 and O4= lastrow Sh4.SheetList = Array("Sh1", "Sh2", "Sh3", "Sh4")
For Count = 0 To UBound(SheetList)
Dim lrow As Long
lrow = Range("A" & Rows.Count).End(xlUp).Row
It's used to check if extra rows are added to any of these sheets after updating from website to see if rest of vba script will run or not.