Solve the following problem/ Scenario below in a google excel sheet.

I have a google excel sheet that is appending data from a google form. The data contains the laptop cart being requested(EX, laptop A, B, C D), the period that it is being used for(EX. Period 1, 2, 3,4), the date that the person is being the date(Ex. Monday to Friday)and the person's name request for the item(email). Note. Each person can select multiple items on the list

The second google sheet, it contains different table sheets for the corresponding laptop carts. I want to create a google excel sheet that appends the person's request information into the right laptop cart data sheet. For example, in excel sheet 1, a user request information from the google form to have access to laptop cart A period 1 and 2 on Monday. On the second excel sheet, I want to automate the process and add the person's name to the requested item on the table. (the person's name will appear on the laptop Cart A, Period 1 and 2 ).

Please make a google form sheet and the excel sheet to do the above.

The following is sheet 1

The following is sheet 2 

Transcribed Image Text:

1 2 3 4 LO Timestamp A 5/31/2022 9:40:18 Tuesday 5/31/2022 9:40:43 Monday 5/31/2022 9:41:29 Tuesday 5/31/2022 9:42:10 Monday B Which Cart? BGH в Н I C D What period? Period 5, Period 6 Period 7 Period 5 Period 3 E Email Address F F linalan1231@gmail.com F linalan1231@gmail.com F 1 2 3 4 LO Timestamp A 5/31/2022 9:40:18 Tuesday 5/31/2022 9:40:43 Monday 5/31/2022 9:41:29 Tuesday 5/31/2022 9:42:10 Monday B Which Cart? BGH в Н I C D What period? Period 5, Period 6 Period 7 Period 5 Period 3 E Email Address F F linalan1231@gmail.com F linalan1231@gmail.com F

Answer rating: 100% (QA)

In order to accomplish this task you will need to first create a Google Form to collect the information from users Which Cart What period and Email Address Once you have the form set up you can then l... View the full answer