| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Input
I am trying to put together a database file with spreadsheets with
collected data and I was thinking to have one sheet for data input. Every month I would insert monthly data to the input sheet, identifying month, and macro would put this info into database under identified month. Does anybody know if it is possible to do in EXCEL and how? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Input
Hi Igor,
When you mention you want to put all the info into a database, do you mean into Access? If so, it is better to write the code in Access to pull the data in instead of pushing it in from Excel. If this is the case, you may want to post this question in an Access newsgroup. Warm Regards, Crystal Microsoft Access MVP 2006 * Have an awesome day ;) remote programming and training strive4peace2006 at yahoo.com * wrote: I am trying to put together a database file with spreadsheets with collected data and I was thinking to have one sheet for data input. Every month I would insert monthly data to the input sheet, identifying month, and macro would put this info into database under identified month. Does anybody know if it is possible to do in EXCEL and how? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data input into cell a1 drives c1 data gathered from a list | Charts and Charting in Excel | |||
| Data Input | Excel Worksheet Functions | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| how to display data of input that is within a data range??? | Excel Programming | |||
Linear Mode
