mimick an access database within Excel

[hnoshea]

I am trying to find a way to do a few things to mimick an access database within Excel. I created a workbook in Excel that operates like a form. One tab is for entry, the second is for a report view of the 1st tab. I want the form to be used as a data entry point feeding that information into a seperate report tab. I don't want to have to create a new data entry page for each new customer. I wanted to find a way to use that form to fill the report tab and then clear itself out when done for another entry without removing the data from the report tab.

Any ideas???

Heather

[Bryan Hessey]

I am trying to find a way to do a few things to mimick an access database

Why? 'Access' reports are so distinctive, why would you wish to 'mimic' them?

within Excel. I created a workbook in Excel that operates like a form. One tab is for entry, the second is for a report view of the 1st tab. I want the form to be used as a data entry point feeding that information into a seperate report tab. I don't want to have to create a new data entry page for each new customer. I wanted to find a way to use that form to fill the report tab and then clear itself out when done for another entry without removing the data from the report tab.

Any ideas???

Heather

I think you need to familiarize youself with Excel, rather than try to 'mimic' either Access or Word in Excel.

To produce the report you seek, the idea would appear to be to keep the 'database' sheet with all of the information required, then, for each 'report' select to a worksheet the items to report on.
Produce the report and clear the worksheet.

I use a similar idea with

Please Login or Register  to view this content.

where the rows for reporting were the result of a Filter selection in the data sheet.

Does this help?

---