Jennifer Van
New Member
- Joined
- Apr 22, 2022
- Messages
- 41
- Office Version
- 2016
- Platform
- Windows
I have my data in a spreadsheet and was wondering if is possible to have the line copied (automatically if possible) to a word form.
I know I can do this by designing a form on another sheet in the workbook and linking the cells but this only works for one row.
What I was hoping for was once one row was finished, I would save the form as a word document so that became a record with all the same information as the spreadsheet in and ready to be used - already completed with referral information in - saving staff having to retype the same information again - in the spreadsheet and then again in the word document.
But when I move to the next line, I have to relink that row cells to the form, which takes just as much time - is there some way around this?
Spreadsheet attached
I know I can do this by designing a form on another sheet in the workbook and linking the cells but this only works for one row.
What I was hoping for was once one row was finished, I would save the form as a word document so that became a record with all the same information as the spreadsheet in and ready to be used - already completed with referral information in - saving staff having to retype the same information again - in the spreadsheet and then again in the word document.
But when I move to the next line, I have to relink that row cells to the form, which takes just as much time - is there some way around this?
Spreadsheet attached