Code:
Sub test_1()
Dim r As Range
Set r = Range("A" & Range("A" & Rows.Count).End(xlUp).Row)
r.Offset(1).Value = r.Value + 1
End Sub
i found these codes in your forum. which increase number. i need codes which can check number on sheet2 column A and than show next increment number on sheet1 cell.
for example if sheet2 column have 1 to 10 number, codes check sheet 2 column than show increment in sheet1 any given cell.
it all happen when i open workbook.
thanks