Hello!
I'm hoping to take a list of data from one workbook (constantly rewritten from a Google Form) to 1) make a new sheet with the name, then 2) copy the data so I can more easily populate a template with it.
So this file is always going to be named the same thing ( 面接練習希望用紙 (Responses).xlsx ), but the data will constantly be getting updated from Google Forms and will probably be around 100 total entries. I'd like to read that info and copy it into a new sheet on a separate workbook that I can use as cell reference to fill out a template I made and will just copy into the sheet as necessary.
The English at the bottom of the table is for easier reference for anyone who can help. In the actual file, it will just be the Japanese at the top as the titles and the names starting from B2 (with the data in row 2 being what I want to copy).
Sorry if this is hard to understand, it's been awhile since I've had to use English like this.
I'd really appreciate any and all help!
I'm hoping to take a list of data from one workbook (constantly rewritten from a Google Form) to 1) make a new sheet with the name, then 2) copy the data so I can more easily populate a template with it.
| 面接練習希望用紙 (Responses).xlsx | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 1 | 名前 | 組 | 出席番号（数字のみの記入で） | 受験校 | 設置区分 | 学部 | 学科 | 試験日 | 出発予定日(試験日と同じでも記入ください) | 受験形態 | 出願書類 | 小論文 | 面接の形態 | 備考（放課後、練習ができない曜日・時間など） | ||
| 2 | 高橋翔也 | 9 | 13 | 北海道大学 | 国立 | 医学部 | 保健学科 放射線 | 11/20/2022 | 11/20/2022 | 総合型 | 志望理由書, 自己推薦書, 活動報告書, コンピテンシー評価書 調査書 個人評価書 | なし | 口頭試問（教科は「その他」のところへ） | 11月4日に、一次試験の結果が出るので、結果次第では練習いりません。 月曜日、火曜日、金曜日の放課後は、塾のため練習できません。 | ||
| 3 | 石川そよか | 11 | 14 | 東京歯科大学 | 私立 | 歯学部 | 歯学科 | 11/20/2022 | 11/19/2022 | 学校推薦型（公募制） | 志望理由書, 自己推薦書 | あり | 個人面接 | 練習できない日→火曜日、木曜日、土曜日 | ||
| 4 | 山形友翔 | 9 | 18 | 筑波大学 | 国立 | 情報学群 | 情報メディア創成学類 | 10/12/2022 | 10/11/2022 | 総合型 | 志望理由書, 自己推薦書 | なし | 個人面接 | 月曜以外は基本的に大丈夫です。 | ||
| 5 | ||||||||||||||||
| 6 | ||||||||||||||||
| 7 | ||||||||||||||||
| 8 | Name | Class | Number | College | Type | Department | Subject | Exam Date | Departure Date | Exam Type | Documents | Essay | Interview Type | Misc | ||
Form Responses 1 | ||||||||||||||||
So this file is always going to be named the same thing ( 面接練習希望用紙 (Responses).xlsx ), but the data will constantly be getting updated from Google Forms and will probably be around 100 total entries. I'd like to read that info and copy it into a new sheet on a separate workbook that I can use as cell reference to fill out a template I made and will just copy into the sheet as necessary.
The English at the bottom of the table is for easier reference for anyone who can help. In the actual file, it will just be the Japanese at the top as the titles and the names starting from B2 (with the data in row 2 being what I want to copy).
Sorry if this is hard to understand, it's been awhile since I've had to use English like this.
I'd really appreciate any and all help!
