Hi,
Trying to construct a macro that copies data from a form. lets say the form look like this:
Name: "User input box ( a cell in excel)"
Gender: "User input box ( a cell in excel)"
Hometown:"User input box ( a cell in excel)"
etc.
After the user have entered all data he hits the buttom "Done" and then all data should be copyed into the first empty row in another workbook.
For exampel:
User enters: (marked with fat letters)
Name: Per
Gender: Male
Hometown: Soolm
This should generate this row in the other workbook: (Marked with fat letters)
Name | Gender | Hometown
Per | Male | Soolm
Hope you get the point!
And last. I also want to publish this sheet on a homeoage. How do I publish excel sheets on the web so that my code and "buttons" still work . Is there a way doing so or do I have to construct the form in HTML and export the data to a XML-file ?
Thanks
/
Pero
Bookmarks