auto numbering

Hello! I have a vba code which copies data from multiple workbooks into one based on criteria. The criteria value is being copied as well to the generated worksheet at column D. Now, I may have 3 rows for value=Criteria1 in column D and other 5 rows for value=Criteria2 in column D. I want to...

I am creating a list of all assigned document numbers for the company. The document numbers are assigned sequentially based on the components of the numbering system (Region-Dept-Document Type-XX). I want to automatically assign the document number to all new documents added to the list to...

We have an Excel table we use to create work orders. The work order numbers are structured as Fiscal Year - incremental 3 digit number. For example, 2018-001 2018-002 2018-003 etc. Right now the numbers are entered manually in a table column each time a new WO is created. I've had some...

How do I start auto numbering 1,2,3 ect staring at A2, but only when data is entered in the row? A2 needs to start with "1"

Can someone help me get a way to generate ID's by avoiding duplicates and permanent values, unless changed manually. Lets say I have: <tbody> A B C D E F 1 Country State City Submarket Use ID 2 Mexico Baja California Tijuana Florido Industrial MBTFI-0001 3 Mexico Baja California Tijuana...

I need to have the corresponding row numbers auto update in column A, if it is blank, whenever new data is added. i.e. If there is no row number in A7 when I enter data in D7 then auto enter the row number into the corresponding row in col A, A7 in this case. Obviously do nothing if there is a...