Hello all,
I am trying to create a passenger manifest form. I have sheets for each day. I Have a userform that outputs to sheet called "Master", need to copy Cells D2:N2 from sheet "Master" and paste into a specific location on a specific day based on user entry. I would like to prompt the user to ask for the day and type of Aircraft (i.e. 15-Mar / Transport 1, Transport 2, Helicopter 1, Helicopter 2, etc... and copy from "Master" and paste to a different location on the dated sheet(i.e. sheet "15-mar) based on what the user entered. The restriction being, Transport one is D2:D23 (22 seats available); (show error box if more than 22 passengers reached) Transport two is D29:D50 the entries need to be pasted below each previous entry so not to overwrite.
So summarization user enters passenger information on a form. Clicks save data, the prompt asks what day the passenger is traveling, and via what means. The form copys the data to "master" (not needed to save data only to copy and paste to its intended location) The data is then copied to a dated sheet in specific row locations based on means of travel. Need each entry to populate a different row i.e Row 1, next entry populates Row2, Row 3, etc. Once 22 rows have been filled, error box saying all seats are filled.
Any help is greatly appreciated.
I am trying to create a passenger manifest form. I have sheets for each day. I Have a userform that outputs to sheet called "Master", need to copy Cells D2:N2 from sheet "Master" and paste into a specific location on a specific day based on user entry. I would like to prompt the user to ask for the day and type of Aircraft (i.e. 15-Mar / Transport 1, Transport 2, Helicopter 1, Helicopter 2, etc... and copy from "Master" and paste to a different location on the dated sheet(i.e. sheet "15-mar) based on what the user entered. The restriction being, Transport one is D2:D23 (22 seats available); (show error box if more than 22 passengers reached) Transport two is D29:D50 the entries need to be pasted below each previous entry so not to overwrite.
So summarization user enters passenger information on a form. Clicks save data, the prompt asks what day the passenger is traveling, and via what means. The form copys the data to "master" (not needed to save data only to copy and paste to its intended location) The data is then copied to a dated sheet in specific row locations based on means of travel. Need each entry to populate a different row i.e Row 1, next entry populates Row2, Row 3, etc. Once 22 rows have been filled, error box saying all seats are filled.
Any help is greatly appreciated.
