Auto-Fill from list of names

[rizmomin]

Hello:

This is what i like accomplish.
Sheet1 will have a list of Payee Names in Column A


Sheet2 : i will need to enter date, Payee and $ amount ( Column A, B and C) in each row.

Sheet2 will have
Column A Date
Column B would have a heading as Payee.
I need a feature where when i start typing the name of Payee in Column B, it
needs to start auto-fill from Payee Names in sheet1.
Is this possible and if so please help me accpmplish this.

Thanks..help is always appreciated

RM

[Richard Buttrey]

Hi,

I believe Autofill requires there to be a contiguous run of values above the cell you're completing. The best you can do with a list of names on Sheet 1 is to name that list and use the name in a Data Validation List on Sheet 2 and pick the names from the cell drop down.

[caveat]unless someone knows better of course [/caveat]

[rizmomin]

can you explain me how to name the list in Sheet1 and use in Sheet2.
Thank U so much.

RM

[rizmomin]

I think i got it ...Thank u so much

RM

[jaslake]

Hi rizmomin
You could use the approach described here
http://www.contextures.com/xldataval10.html
It can be a pain to get set up...but once set up it functions well.