Merge information - Microsoft Community
i have task specific problem , i'm using excel 2003. have spreadsheet need create canvassing form in excel different layout. need multiple people on same sheet. specifically, master list has such information first name, last name, address, , phone in specific columns. second 1 puts several people in specific sections includes check-off list.
| <ln>, <fn> | <phone> | verify info? | attend? | volunteer? |
| <street address> | <email> | o yes | o yes | o yes |
| <county> | <age> | o no | o no | o no |
| o maybe | o maybe | |||
| <ln>, <fn> | <phone> | verify info? | attend? | volunteer? |
| <street address> | <email> | o yes | o yes | o yes |
| <county> | <age> | o no | o no | o no |
| o maybe | o maybe |
i can fit around 14 per page , i'd hate have hand.
Office / Excel / Windows 10 / Older versions
Comments
Post a Comment