| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Access data -work in Excel- save in Access | Excel Programming | |||
| Getting Access Error Messages when running Access through Excel | Excel Programming | |||
Linear Mode
