Userform to seperate workbook

Jlombard_

New Member
Joined
Sep 26, 2018
Messages
21
Hi there,

I've currently got two spreadsheets;

1) AOK Form (v2) -
[This spreadsheet will be stored locally for over 100 users individually] This is where the form is located and it serves no other purpose than opening the form (there is a hidden sheet for lookup lists for combo boxes)

2) AOK Submissions -
[This sheet will be stored in a locked shared folder] - This is where the data collected through the form will be submitted automatically.

I've got all of the columns set up with headings ready to have the data sent from the form into the designated cells the problem is I'm not sure how to do that. - I also need the spreadsheet to add a new row everytime a new submission is made so that any new submissions are at the top of the spreadsheet.

I also have a couple of questions about whether a few things are possible or not:
1) If we password protected the Submissions spreadsheet would the form still communicate the data across?
2) With multiple users the risk of error is increased, is it possible to click submit --> submit data --> auto-check AOK Submissions for data --> if not there then pop-up asking to click resend appears
3) Is it possible to have a popup message once the data is submitted confirming such - when you click okay on the pop-up box it then closes the entire AOK Form (V2) spreadsheet?
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top