automatic update

**navwelch** · 08-10-2009, 03:25 AM

hi there,

i have in sheet1, where the client key in the data, and sheet2 where i have to give the latest data to my manager. i tried with isblank and sort but in vain.. attaching the sheet...

please let me know how i do it...

**ncmay** · 08-10-2009, 05:12 AM

Try using the MAX function.

Norman

**navwelch** · 08-10-2009, 10:39 AM

that was great but instead of date if i had a series say a list of account numbers
3010
1002
9803
i want it such that when the next row is filled up i want it to be updated to that... any help in that case would be great help..

**DonkeyOte** · 08-10-2009, 11:36 AM

Re: Sheet1 Column B content...

If the values are numeric

Sheet2!A4
=LOOKUP(9.99999999999999E+307,Sheet1!B:B)

If the values in are text

Sheet2!A4
=LOOKUP(REPT("Z",255),Sheet1!B:B)

**navwelch** · 08-10-2009, 10:45 PM

thanks a lot... i actually came to this site to learn more about excel functions and you people are doing me a great favor.... thanks a lot again..

regards,
navwelch