Thread: How to increase the rows from 16 to 36? (file attached)
View Single Post
 
Old 06-29-2020, 09:12 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
I thought this was covered in a previous post?

Put this in cell a2 - =ROWS($A$2:A2)&"." and drag down

Its and expanding range that counts rows, =ROWS($A$2:A2) is one, then the next one is =ROWS($A$2:A3)&"."

Insert rows and then redrag and it will count down
Attached Files
File Type: xlsm Dummy Excel_purfleet.xlsm (15.3 KB, 4 views)
Reply With Quote