Import/export within Excel

Hi there, would you be so kind and point me out the right direction how could I get the data from one XLS sheet (a form that will be distributed to my co-workers to be filled and send back via email) to another "database" XLS sheet (data from a form goes as a new line into this XLS). I was thinking about ActiveX/macro button within the form that could do that, but I have no idea how... Thanks in advance for helping me out.

Originally Posted by JBeaucaire

I think this question belongs in the Programming forum. I'll ask the moderator...

Meanwhile, if your employees are filling out actual separate spreadsheets and sending them to you...I would use a process that goes like this:

1) Save emailed workbooks into a specific folder on your computer as they arrive
2) Your macro watches that folder for any files
3) When files found in that folder, the macro opens the file and imports the data data to the next empty row in your database
4) The macro closes the imported file
5) The macro moves the file from that folder into another folder so it does not get imported again

I have a few macros that use this method. If you're interested:

A) Provide the folder path to watch ("C:\2010\Forms\")
B) Provide the folder to move completed files into ("C:\2010\Forms\Imported\")
C) Provide information regarding where data is in the form and where it should in the database

A sample of the database and form would speed this along.

Thanks a lot for offered help, JBeaucaire - I REALLY appreciate it! Could you pls let me know how I can share those 2 speadsheets with you - if you PM me your email address I can make it available as shared file on my Google Docs or send it directly to you to your email - it is altogether 418KB of data... And I have also the list of links inbetween particular cell in a form and destination collumn in a "database"... Please let me know. Thanks in advance! MartinN.