Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 06-24-2020, 09:44 PM
kingston123 kingston123 is offline Deleted entire row, but numbering series gone wrong. Help me. Windows 10 Deleted entire row, but numbering series gone wrong. Help me. Office 2013
Advanced Beginner
Deleted entire row, but numbering series gone wrong. Help me.
 
Join Date: Sep 2018
Posts: 85
kingston123 is on a distinguished road
Default


Quote:
Originally Posted by logit View Post
.
What column and what starting and ending cell do you want the auto numbering to work ?

a58 is start cell


a130 is end cell
Reply With Quote
  #17  
Old 06-25-2020, 08:16 AM
Logit Logit is offline Deleted entire row, but numbering series gone wrong. Help me. Windows 10 Deleted entire row, but numbering series gone wrong. Help me. Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Ok .. then paste the following in A58 :

=IF(ISBLANK(B58)," ",COUNTA($B$58:B58))

Then follow the same instructions as before :

Once you have the formula in the cell, click on the cell and a small dot will appear
in the lower right hand corner of the cell. Hover your cursor over that tiny black
dot until the cursor becomes a cross symbol. While it remains the cross, double
click the dot. The formula should auto-fill all the cells in Col A that are adjacent
to a cell in Col B that has some data.

Be sure to delete the macro from the worksheet module.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Occurence appt invitees showing on entire series doresa69 Outlook 0 11-11-2016 01:32 PM
Deleted entire row, but numbering series gone wrong. Help me. Series numbering ericjowens Excel 2 09-03-2015 11:20 AM
deleted items in wrong mailbox Flip Outlook 2 03-12-2014 03:51 AM
Deleted entire row, but numbering series gone wrong. Help me. Header numbering is wrong Scaffold Word 2 02-13-2014 03:08 AM
Continue Auto Numbering Throughout Entire Presentation craigfu PowerPoint 3 05-04-2012 05:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:50 AM.


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