Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: how to do the automatic formula of this???

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    web
    Posts
    8
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    i have a problem with declaring a macro to do an automated job. when the length and breadth is key in, the price and specification of die set must be automatically show up.
    it is like this...
    i have a excel file name Quote and Dieset
    quote have the following(lenght, breadth, height which is user input)
    Lenght: have to check the value of it from another excel file field(specification)which is written like this specification=lenght* breadth * height. check whether it equal to any cell then check breadth.

    Breadth:check whether the breadth equal to the field which have the lenght user input.

    Die set:refer to the die specification table (length* breadth* height(default 110)
    or can refer to the lenght, breadth just calculated for the die.

    Die price :refer to the table together with specifiaction. when the die specifiaction is found.

    Height:optional input by default is 110

    Specification have only the specification of die (select from quote the lenght* breadth* height) and the price of the die.

    i don't know how to check the dieset specifiaction when user key in the lenght and breadth. i know i can use index to check the price of the dieset. but i can't check the specifiaction.
    how m i goin to do this? using wat method??
    can help anyone??
    Thanks.

    [ This Message was edited by: apple on 2002-03-27 21:28 ]

    [ This Message was edited by: apple on 2002-03-27 21:38 ]

  2. #2

    Join Date
    Mar 2002
    Location
    Chennai, India
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    I could not exactly make out what you wanted.
    If you dont mind please send me a copy of the workbook to my mail id. I would bne happy to do it for you.
    Please send it to
    srinivas.ponugupaty@kla-tencor.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •