Posts by shaundas

    Issue has been solved. Thanks you RoyUK.

    Sorry I am new to coding not able to figure out how to counter check.

    If you want to keep order number length sorter you can remove "Order" text and order start serial number to 1, also you can reduce date format say yymm follow with serial number. it will be (20031) 2nd order will be (20032) it's less possibilities to get duplicate.

    Currently this method I am using for my quotation and invoicing.

    Insert following excell formula in (example) cell A1 and insert order start number example (100) in cell P1

    ="Order"&TEXT(TODAY(),"yymmdd")&P1


    Insert following vba code in sheet module, change cell address as per your location (example P1)


    You can change word "Oder" to anything else you want.


    The code will generate order number using current date and pretext text at the beginning "Order" and number end the end with auto increment, your order worksheet must be save to get auto incremental number at the end.




    Code
    1. Private Sub workbook_open()
    2. Range("P1").Value = Range("P1").Value + 1
    3. End Sub

    Hi RoyUk. Sorry my Apology . single cell working code is below, need modified code to work with multiple cell. Help will be great. Thanks.

    Hi All, Good morning.

    I am using following vba code for above subject from RK, its work great for me, but I need the code to be work in several cell Likewise (A1, G5, C10 etc) currently work only one cell.


    Help will be great. Thanks



    [Put Grayed Text Into Input Cells for Instructions which Reappears if Input is Deleted


    Code
    1. Sub workbook_open()
    2. Sheets("Sheet1").Range("A1").Value = "Type Company Name Here !!"
    3. With Selection.Font
    4. .Name = "Arial"
    5. .FontStyle = "Regular"
    6. .Size = 12
    7. .ColorIndex = 15
    8. End With
    9. End Sub




    Grayed text.txt

    Hi All, I need help with following:
    I have three workbook. Workbook-1 Master Data File (Picture below)). Workbook-2 dataFORM-1 and Workbook-3 dataFORM-2.
    Data FORM 1 and 2 send data to Master Data File using following code. When FORM-1 send data to Master Data file its occupied cell A2 to AD2, when data from FORM-2 arrived its insert one row down that is in AE3 instead of AE2, I wants data to be inserted next available column which is AE2. How to achieve that within below code . Also I want to close Master Data File automatically when Data FORM is closed.
    Thanks Shaun
    [ATTACH=JSON]{"data-align":"none","data-size":"full","data-attachmentid":1209039}[/ATTACH]


    Following code using in Data FORM-2 also same code use in Data FORM-1.


    [ATTACH=JSON]{"alt":"Click image for larger version Name:\texcel datafile snap.JPG Views:\t3 Size:\t39.9 KB ID:\t1208940","data-align":"none","data-attachmentid":"1208940","data-size":"full"}[/ATTACH]


    I have three workbook. Workbook-1 Master Data File (Picture above). Workbook-2 FORM-1 and Workbook-3 FORM-2.
    Data FORM 1 and 2 send data to Master Data File using following code. When FORM-1 send data to Master Data file its occupied cell A2 to AD2 when data from FORM-2 arrived its insert one row down that is in AE3 instead of AE2, I wants data to be inserted next available column columns which is AE2. How to achieve that within below code . Also I want to close Master Data File automatically when Data FORM closed.
    Thanks Shaun


    Following code using in Data FORM-2 also same code use in Data FORM-1.


    Hi There
    I am new to VB code and this form. I need help with how to delete row count in the code.
    I am using three Excel (2007) Workbook. 1: Database file, 2: Form-1 and 3: Form-2. Using following code - Form-1 transfer data to Database file and occupied Cell A2: Y2 work fine. Using same code transfer data from Form-2 to database file work fine except data goes to cell Z3 due to row count formula in the code, I want data to go to cell Z2 and not look for blank row. Will be great help. Thanks