PDA

View Full Version : How to search and modify existing record



yogeshwarv
08-07-2010, 12:04 AM
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)

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

Aussiebear
08-07-2010, 12:07 AM
Please post your workbook so we can evaluate your request.

yogeshwarv
08-07-2010, 12:44 AM
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...

yogeshwarv
08-11-2010, 04:34 AM
somebody help me please.......!