Auto Numbering of data except blanks starting from number n

		Microsoft Office Forums > Microsoft Excel > Excel
Auto Numbering of data except blanks starting from number n

09-08-2018, 02:29 PM

Logit

Windows 10 Auto Numbering of data except blanks starting from number n

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Quote:

Originally Posted by Marcia

The macro doesn't work if I add another month with separate serial numbers in sheet 1.

That's because your post didn't mention anything about additional ranges where you would be starting over with a new number.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return Multiple values from data except blanks with two criteria	Marcia	Excel	7	09-07-2018 12:38 AM
Delete starting number *) and delete Unneeded data in series	frustrated teacher	Word VBA	5	12-07-2014 06:53 PM
Starting page numbering after initial pages	plradoff	Word	3	02-15-2014 08:59 PM
Copying data from sheet with deleted columns creates blanks	ZGreyArea	Excel	1	11-20-2013 10:12 AM
Page numbering starting on 2 after section break	pamm13	Word	1	06-22-2011 11:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:59 AM.