AutoNumber Like 1F, 2F, 3F
Oct 9, 2008Here is what I am trying to do. I want to autonumber like this
1F
2F
3F...
ALSO
JPG1F1
JPG2F1
JPG3F1...
Is there a way to do this.
ADVERTISEMENT
Autonumber Function
Mar 14, 2007I am creating a quotation system, where each quotation created needs a unique quotation number. The first quotation created will be put into row A8 and will be No1, when a new quotation is created and therefore a new A8 inserted, i want the number 2 put in and on the next inserted line no3 and so on.
Is there a function to do this?
Autonumber, Add Row, Sort
Aug 16, 2006I am trying to write a macro that copies 2 columns from page2 (column a & b) and paste it into sheet1 (column B & C), deletes the info from sheet2 so it is always available for the next info to cut and paste, in sheet1 column A I have 1,2,3,4,5 so I would like that the macro adds the next number down where the info will be pasted, I know it is an easy one, but I am going in circles,
View 9 Replies View RelatedAutonumber While Skipping Rows?
Dec 21, 2012I am trying to get excel to autocount starting in a7 and ending at a600, skipping 3 rows in between, and only gng from 1-10 then repeating and inserting a page break after the 10th line i have put an example in.
SAMPLE1.xlsx
Autonumber Based On Criteria -
May 17, 2007I'm trying to think of how to create a code that would autonumber based on criteria. I am trying to autonumber a type of invoice for an estimate.
1) Use the initials of the person creating the at the beginning of the number - we have 4 users of the form.
2) The form is an original and once completed it would be saved as an alternate file - maintaining the blank original.
3) Would it be possible to keep a running list (on a hidden sheet) so that the autonumber knows what number to use next.
I was thinkiing that it could be generated at the press of a button, since these estimates would be looked at again and again. I wouldn't want it renumbering everytime the workbook is opened.
Autonumber/transfer Of Data To Other Sheet
Apr 5, 2007i am trying to create a macro button that will take a new customer on the first page and transfer this new customer entry on to the existing customer page. i know i need to use a paste special to make the customer data to go from virtical to horizontal, but my main problem is that i need to give all my customers a autonumber with letters and numbers.
This is my problem i need to create a macro that will keep createing my format of CID1101,CID1102,CID1103 and so on and so forth as a autonumber and also be able to send my customer data across from the new customer table to the existing customer table. i have attached my spreadsheet i have had to zip it to get the size down and also remove pictures.
Autonumber/highlight Stock Levels
Apr 9, 2007to create an order ID so when customer is transferred from the new order to Existing orders it will automatically generate CUW001 for first order then CUW002 for the second order and so on I have added a column form Order ID so this may have affected the macros pasting location. Also one last thing could you also tell me how I could highlight stock items red if the stock levels fall below 5
i have attached the spreadsheet