Posts by nishalmenezes

    Hi,


    I am getting run time error 13 (type mismatch) once I clear the combobox1.


    VB:


    Thanks,
    Nishal

    Hi,


    I have two dates in my worksheet.


    In the first row the formula is working fine wherein the out date is equal to in date + one day extra.


    But in the second example it should also come as OK cause it should exclude a sunday which come between 6th & 8th Aug 2016.


    [TABLE="class: grid, width: 500, align: left"]

    [tr]


    [td]

    In Date

    [/td]


    [td]

    Out Date

    [/td]


    [td]

    Formula

    [/td]


    [/tr]


    [tr]


    [td]

    5-Aug-16

    [/td]


    [td]

    6-Aug-16

    [/td]


    [td]

    =if(Out date = (in date + Day (1)), "OK",""

    [/td]


    [/tr]


    [tr]


    [td]

    6-Aug-16

    [/td]


    [td]

    8-Aug-16

    [/td]


    [td][/td]


    [/tr]


    [/TABLE]







    Attached file as an example.


    Regards,
    NM.forum.ozgrid.com/index.php?attachment/69952/

    Hi,


    I have a data as below I need the value which is horizontal one below each other.


    [TABLE="class: outer_border, width: 287"]

    [tr]


    [td][/td]


    [td]

    Saswad

    [/td]


    [td]

    Suraj

    [/td]


    [/tr]


    [tr]


    [td]

    FROM

    [/td]


    [td]

    407

    [/td]


    [td]

    408

    [/td]


    [/tr]


    [tr]


    [td]

    ALANDI

    [/td]


    [TD="align: right"]4370[/TD]

    [td][/td]


    [/tr]


    [tr]


    [td]

    AHMEDNAGAR

    [/td]


    [TD="align: right"]7500[/TD]
    [TD="align: right"]7500[/TD]

    [/tr]


    [/TABLE]



    I need the data in output as below
    [TABLE="width: 500"]

    [tr]


    [td]

    ALANDI

    [/td]


    [td]

    407

    [/td]


    [td]

    Saswad

    [/td]


    [td]

    4370

    [/td]


    [/tr]


    [tr]


    [td]

    AHMEDNAGAR

    [/td]


    [td]

    407

    [/td]


    [td]

    Saswad

    [/td]


    [td]

    7500

    [/td]


    [/tr]


    [tr]


    [td]

    AHMEDNAGAR

    [/td]


    [td]

    408

    [/td]


    [td]

    Suraj

    [/td]


    [td]

    7500

    [/td]


    [/tr]


    [/TABLE]


    [TABLE="width: 287"]

    [tr]


    [td]

    Is there an excel formula or macro which can extract this result.


    Regards,
    NM

    [/td]


    [td][/td]


    [/tr]


    [/TABLE]

    Re: View only excel form but view other excel sheets


    Dear Stephen,


    My form I have set on modeless I do not have issues with accessing the other worksheets due to this function. My requirement is to have a form instead of the excel sheet which comes along with the form, secondly I used the code to make the application as False but in this scenario I cannot use other excel sheets which I need to use.


    Would be of a great deal if I crack how to do it.


    regards,
    NM

    Dear All,


    I have an excel form wherein I just want to view the form once I double click on excel for the same I am using the below code.


    Code
    Application.Visible = False


    But therein I cannot access and open other excel files due to this.


    Kindly suggest was is the best way I can hide the excel sheet of the form and view only the form and even open required excel sheets.


    Regards,
    Nishal

    Hi All,


    I am doing this for the first time and might be sounding dumb cause I am trying to get a solution for my current time consuming activity.


    I have been operating on SUN system and have back end interface provided to extract reports which is called (Vision) Q&A Excel.


    To access the reports I need to open the citrix and then login the SUN (ERP) system and access VISION.


    How can I create a excel based query wherein this is auto scheduled every hour without any human intervention.


    Need an insight on the above.


    Thanks,
    Nishal

    Re: Need to identify the missing file by number sequence


    Hi Ali,


    The input which I am talking about has a range in the above eg. 123PF126 -- the range is 123 to 126 and all the numbers in below are ending with these numbers within these range.


    [TABLE="width: 156"]

    [tr]


    [td]

    P456789123

    [/td]


    [/tr]


    [tr]


    [td]

    P456789124

    [/td]


    [/tr]


    [tr]


    [td]

    P456789125

    [/td]


    [/tr]


    [tr]


    [td]

    P456789126

    [/td]


    [/tr]


    [tr]


    [td]

    P456789127


    And if the above bold numbers matches the above said range then it is OK if not then NOT OK.


    Regards,
    Nishal

    [/td]


    [/tr]


    [/TABLE]

    Hi All,


    I am doing this for the first time in excel to identify a missing file through its number.


    For instance.


    The input is 123PF126


    The file wherein the above value needs to be checked is as below.


    P456789123 - OK
    P456789124 - OK
    P456789125 - OK
    P456789126 - OK
    P456789127 - NOT OK


    I need to identify the not ok ones.


    Need a formula or a macro.


    Regards,
    Nishal M

    Re: Need expert advise in userform lookup


    Dear Roy,


    Thanks for helping me out but the entry level here is a code in Type wherein there is a 10 alphanumeric code Eg. T912349871 in this code the last number 1 stands for shoes and so on. I need the type 1 to recognize the number 1 and display automatically as shoes then in combobox we can use the said codings by you.


    Can I get some help during the code entry recognition.


    Thanks
    Nishal

    Hi Team,


    I have a userform wherein the textbox1 value is entered by the user and this should give a vlookup value in the other textbox2. My sheet name is master and the range name is TOB.


    Need assistance in the above might be a formula.


    Once I get the value in textbox2 I need a selection range in my combobox1 as per the range allotted to the value received in textbox2.


    For instance.


    Textbox1 = 01
    Textbox2 = Shoes Size (Master has range with 01=Shoe Size / 02=Wardrobe / 03=Clothes)
    Combobox = 8,9,10,11 (Master has range Shoe Size=1,2,3,4,5,6,7,8,9,10,11,12,13 / Wardrobe=Pant, Shirt, Tie, etc. Clothes=Peter England, Nike, Puma)


    Please help in the above.


    Regards,
    Nishal

    Re: Need to paste data with value from three columns one below the other


    Hi Alan,


    Below is the illustration.


    [TABLE="class: cms_table_grid, width: 500, align: center"]

    [tr]


    [td]

    Company

    [/td]


    [td]

    Location

    [/td]


    [td]

    Product

    [/td]


    [td]

    MFG Date

    [/td]


    [td]

    Value 1

    [/td]


    [td]

    Value 2

    [/td]


    [td]

    Value 3

    [/td]


    [td]

    Mode

    [/td]


    [/tr]


    [tr]


    [td]

    Nike

    [/td]


    [td]

    NY

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jun-14

    [/td]


    [td]

    100

    [/td]


    [td]

    0

    [/td]


    [td]

    0

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Adidas

    [/td]


    [td]

    NJ

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jul-14

    [/td]


    [td]

    200

    [/td]


    [td]

    100

    [/td]


    [td]

    0

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Mangoe

    [/td]


    [td]

    PA

    [/td]


    [td]

    Shirt

    [/td]


    [td]

    1-Oct-14

    [/td]


    [td]

    0

    [/td]


    [td]

    0

    [/td]


    [td]

    300

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Vero Moda

    [/td]


    [td]

    NY

    [/td]


    [td]

    Jeans

    [/td]


    [td]

    18-Nov-14

    [/td]


    [td]

    0

    [/td]


    [td]

    300

    [/td]


    [td]

    300

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [/TABLE]



    Now the output should be as below.


    [TABLE="class: cms_table_grid, width: 500, align: center"]

    [tr]


    [td]

    Company

    [/td]


    [td]

    Location

    [/td]


    [td]

    Product

    [/td]


    [td]

    MFG Date

    [/td]


    [td]

    Value

    [/td]


    [td]

    Mode

    [/td]


    [/tr]


    [tr]


    [td]

    Nike

    [/td]


    [td]

    NY

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jun-14

    [/td]


    [td]

    100

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Adidas

    [/td]


    [td]

    NJ

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jul-14

    [/td]


    [td]

    200

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Adidas

    [/td]


    [td]

    NJ

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jul-14

    [/td]


    [td]

    100

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Mangoe

    [/td]


    [td]

    PA

    [/td]


    [td]

    Shirt

    [/td]


    [td]

    1-Oct-14

    [/td]


    [td]

    300

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Vero Moda

    [/td]


    [td]

    NY

    [/td]


    [td]

    Jeans

    [/td]


    [td]

    18-Nov-14

    [/td]


    [td]

    300

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Vero Moda

    [/td]


    [td]

    NY

    [/td]


    [td]

    Jeans

    [/td]


    [td]

    18-Nov-14

    [/td]


    [td]

    300

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [/TABLE]





    Thanks,


    Nishal

    Hi All,


    I need a macro code wherein I have the input as below and in three columns whichever column is greater than ZERO it should paste the entire row in the output sheet.


    Below is the illustration.


    [TABLE="class: grid, width: 500, align: center"]

    [tr]


    [td]

    Company

    [/td]


    [td]

    Location

    [/td]


    [td]

    Product

    [/td]


    [td]

    MFG Date

    [/td]


    [td]

    Value 1

    [/td]


    [td]

    Value 2

    [/td]


    [td]

    Value 3

    [/td]


    [td]

    Mode

    [/td]


    [/tr]


    [tr]


    [td]

    Nike

    [/td]


    [td]

    NY

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jun-14

    [/td]


    [td]

    100

    [/td]


    [td]

    0

    [/td]


    [td]

    0

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Adidas

    [/td]


    [td]

    NJ

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jul-14

    [/td]


    [td]

    200

    [/td]


    [td]

    100

    [/td]


    [td]

    0

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Mangoe

    [/td]


    [td]

    PA

    [/td]


    [td]

    Shirt

    [/td]


    [td]

    1-Oct-14

    [/td]


    [td]

    0

    [/td]


    [td]

    0

    [/td]


    [td]

    300

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Vero Moda

    [/td]


    [td]

    NY

    [/td]


    [td]

    Jeans

    [/td]


    [td]

    18-Nov-14

    [/td]


    [td]

    0

    [/td]


    [td]

    300

    [/td]


    [td]

    300

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [/TABLE]


    Now the output should be as below.


    [TABLE="class: grid, width: 500, align: center"]

    [tr]


    [td]

    Company

    [/td]


    [td]

    Location

    [/td]


    [td]

    Product

    [/td]


    [td]

    MFG Date

    [/td]


    [td]

    Value

    [/td]


    [td]

    Mode

    [/td]


    [/tr]


    [tr]


    [td]

    Nike

    [/td]


    [td]

    NY

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jun-14

    [/td]


    [td]

    100

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Adidas

    [/td]


    [td]

    NJ

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jul-14

    [/td]


    [td]

    200

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Adidas

    [/td]


    [td]

    NJ

    [/td]


    [td]

    Shoes

    [/td]


    [td]

    1-Jul-14

    [/td]


    [td]

    100

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Mangoe

    [/td]


    [td]

    PA

    [/td]


    [td]

    Shirt

    [/td]


    [td]

    1-Oct-14

    [/td]


    [td]

    300

    [/td]


    [td]

    AIR

    [/td]


    [/tr]


    [tr]


    [td]

    Vero Moda

    [/td]


    [td]

    NY

    [/td]


    [td]

    Jeans

    [/td]


    [td]

    18-Nov-14

    [/td]


    [td]

    300

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [tr]


    [td]

    Vero Moda

    [/td]


    [td]

    NY

    [/td]


    [td]

    Jeans

    [/td]


    [td]

    18-Nov-14

    [/td]


    [td]

    300

    [/td]


    [td]

    ROAD

    [/td]


    [/tr]


    [/TABLE]




    Thanks,


    Nishal