Consulting

Results 1 to 4 of 4

Thread: How to search and modify existing record

  1. #1

    How to search and modify existing record

    Hi,

    I have a sheet called City which has three columns.. (from, two and distance)

    In Another sheet i have a used dget formula to calculate distance based on critera (From and to field)

    Now i want another sheet which could modify the distance value in database sheet "City" based on criteria (From and Two)

    how do i do this.... please help!!

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,058
    Location
    Please post your workbook so we can evaluate your request.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    In the modify sheet If I modify the Distance Value of the two stations, it should search the given record in CITY Sheet and change the distance value in Database sheet based on the criteria given.

    Kindly help...

  4. #4
    somebody help me please.......!

Posting Permissions

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