I spent hours finding the formula for auto numbering of column A of several linked sheets starting from a given number but I always got error messages after a blank cell. I do not know where to position the starting number in the formulas that I tried. If I type 58 on say Cell A34 of sheet 1, the rest of the numbers down the rows of the active sheet and other sheets should follow. There should be blank in the Number column if the data in Column B is blank. Please help.
Sheet 1
A-----------------------------B
No.--------------------------Data
58---------------------------Red
---------------------------
59---------------------------White
---------------------------
---------------------------
60---------------------------Red
Sheet 2
A----------------------------B
No.--------------------------Data
61---------------------------Apple
---------------------------
62---------------------------Lemon
63---------------------------Orange
Sheet 3
A----------------------------B
No.--------------------------Data
64---------------------------Cow
65---------------------------Carabao