Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.datamap,microsoft.public.excel.programming
|
|||
|
|||
database to store data entered from a spreadsheet?
Hi,
I'm looking for a little direction.... I have about 6 different spreadsheets that people enter data into. The layout of the spreadsheets are identical. They each have one worksheet per month on the year and then a summary page. Survey results and statistical information are entered into these spreadsheets by different people. What I would like to do is to able to summarize each monthly worksheet and each summary sheet from all six spreadsheets (separate files). I know I could link the six sheets to a new summary sheet, but that would be cumbersome due to the number of items being entered in. Is there a better way....like having each of those sheets dump into a database? What is the best way to accomplish this and where is a good place to read up on how to do it? Thanks! Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete columns in spreadsheet after data entered so it wont scroll | Excel Worksheet Functions | |||
formula to show time that data was entered on spreadsheet | Excel Worksheet Functions | |||
how do I record the time data is entered into a spreadsheet? | Excel Worksheet Functions | |||
Capture and Store the date that data is entered in Excel? | Excel Worksheet Functions | |||
Retrieving previously entered userform data from saved spreadsheet | Excel Programming |