Saveas macro question

Hey guys. I was wondering if anyone would be able to help me with a problem I am having



I have a spreadsheet that is like a form that everyone can access. I want to create a button at the botton which saves the data in a sperate file, as a sort of list, like a database for later analysis. So many people can use this form.xls, and when they click the submit button, it is saved onto a seperate file which collates all the answers from all the forms in one column.



I have tried to work it out myself, I know how to use the saveas function to save it as a seperate file, but I wanted to know if there was a way this could be done.



Thanks a lot!!

It almost sounds like what you want to do is copy the data from the individual sheet into some sort of master sheet or database table, right?

Yes, pretty much. Just a button that automatically does this.