Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Auto Numbering of data except blanks starting from number n Auto Numbering of data except blanks starting from number n
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2018, 02:26 PM
Marcia's Avatar
Marcia Marcia is offline Auto Numbering of data except blanks starting from number n Windows 7 32bit Auto Numbering of data except blanks starting from number n Office 2007
Expert
Auto Numbering of data except blanks starting from number n 		 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

The macro doesn't work if I add another month with separate serial numbers in sheet 1.
Reply With Quote
  #2  
Old 09-08-2018, 02:29 PM
Logit Logit is offline Auto Numbering of data except blanks starting from number n Windows 10 Auto Numbering of data except blanks starting from number n Office 2007
Expert
  
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
Quote:
Originally Posted by Marcia View Post
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.
Reply With Quote
  #3  
Old 09-08-2018, 02:41 PM
Marcia's Avatar
Marcia Marcia is offline Auto Numbering of data except blanks starting from number n Windows 7 32bit Auto Numbering of data except blanks starting from number n Office 2007
Expert
Auto Numbering of data except blanks starting from number n 		 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Remiss of me. My knowledge of macro is limited to recording of repetitious commands. I am excited when others like you introduce a macro that I could practice on in my work. I have attached the sample transactions, and added some data. I'm living in the boondocks, internet signal here is erratic.
Attached Files
File Type: xlsm Number NonBlank Rows (1).xlsm (25.5 KB, 10 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Numbering of data except blanks starting from number n Return Multiple values from data except blanks with two criteria Marcia Excel 7 09-07-2018 12:38 AM
Auto Numbering of data except blanks starting from number n Delete starting number *) and delete Unneeded data in series frustrated teacher Word VBA 5 12-07-2014 06:53 PM
Auto Numbering of data except blanks starting from number n Starting page numbering after initial pages plradoff Word 3 02-15-2014 08:59 PM
Auto Numbering of data except blanks starting from number n Copying data from sheet with deleted columns creates blanks ZGreyArea Excel 1 11-20-2013 10:12 AM
Auto Numbering of data except blanks starting from number n 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.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft