How to get Excel to automatically continue a pattern which is form as 001-01-01 ....003-03-03

BobBridges · #3 04-14-2018, 07:58 PM

I don't know about Excel's pattern abilities. I thought at first I'd do it with IF statements, but the more I tested that the more complicated it got. Instead I treated it as a base-number calculation, using ROW() as the sequential number and calculating each of the three columns. See the attached x.xlsx.

I'm used to R1C1 notation, but most folks prefer A1 so I'll give it a try despite its limitations. Columns X, Y and Z calculate the value of each position—except to make the calculation simpler they go from 0 to 2, 0 to 20 and 0 to 99. Then U, V and W add 1 to each value and convert it to a character string with leading zeroes. In column A you concatenate the three values together with hyphens. You can skip U-V-W and do the conversion and concatenation in column A if you'd rather.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2013 Forms (how to questions)- Quick opening of a form file & Linking form's data to Excel	gamin2407	Outlook	0	01-21-2017 10:14 PM
Check box form field automatically checked	Eduardo Care	Word	8	09-07-2015 03:31 PM
Trouble automatically running user form	Lostinvba	Word VBA	3	11-23-2013 07:22 PM
Automatically generating paragraphs with form data	mkellar	Word	1	03-22-2013 10:10 PM
Form field to automatically be added to header?	razberri	Word VBA	3	02-22-2010 03:48 PM