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.

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.