Exporting data from an excel worksheet to a masterfile.
Hi Everyone,
What I am attempting to do is to create a user form in Excel that people will fill out. When it comes to submitting it what I want to happen is the data will be exported from the form and saved into a masterfile workbook. Each form will have one row on the masterfile, each field will be one cell in that row.
Any help in this would be greatly appreciated.
Is the UserForm in the master file?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
No, the user form needs to be a seperate workbook.
Why don't you have the form in the master workbook? It would be muchh simpler.
You will need to open the masterfile, presumably on a server then write to the sheet. Use the Macro Recorder to record opening this file to get the correct path.
Thinking about it, I suppose it could be a possibility, however the way I normally make forms is to save it as a template so each new user opens a blank copy. The form is going to be used by multiple users simultaneously. How do I ensure that when a user saves the form and it exports the data to a seperate sheet that it goes to the next available new row?
Are you talking about a UserForm or a sheet designed as a form?
To get the next row you need to use something like
Or
Dim R as Long 'this will get the Row number R=Sheet1.Cells(Rows.Count,1).End(xlUp).Row +1
'this will be the next empty cell in ColumnA Sheet1.Cells(Rows.Count,1).End(xlUp).Offseet(1,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks