Can Excel act as Access?
 

I have a worksheet that acts as a database with information updated daily.
I'd like to create an invoice form on a new worksheet that would only pull
one data record at a time.

Is that possible in Excel?

Can Excel act as Access?
 

You can use VLookup formulas to return information for the selected
invoice number. There's a sample file he

http://www.contextures.com/excelfiles.html

Under 'Data Validation' look for 'Invoice for Selected Number'

Dawn wrote:
I have a worksheet that acts as a database with information updated daily.
I'd like to create an invoice form on a new worksheet that would only pull
one data record at a time.

Is that possible in Excel?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html