I was hoping someone can help me with a complicated issue.
I have a word document (2010) which is a 2 page cover sheets I need to send to over 50 people. The cover sheet will have to have each of the 50 places names on as well as their fax number.
I have this info in an excel spreadsheet in 2 columns.
I managed to link the cells I needed in word from excel, but here is my issue.
Is there a way of making it so I can press a button and it will update the word documents linked cells down to the next cell in the original excel spreadsheet.
IE word links cells A1 and A2, then press a button in word/or excel and it then links B1 and B2.
I currently have to either copy and paste all 50 names and then all 50 fax numbers in my hand, or I drag the excel cells from row B to replace row A and then update the link in word so it shows up. But this is a painful process.
Is there any possible solution to my woes?
I have a word document (2010) which is a 2 page cover sheets I need to send to over 50 people. The cover sheet will have to have each of the 50 places names on as well as their fax number.
I have this info in an excel spreadsheet in 2 columns.
I managed to link the cells I needed in word from excel, but here is my issue.
Is there a way of making it so I can press a button and it will update the word documents linked cells down to the next cell in the original excel spreadsheet.
IE word links cells A1 and A2, then press a button in word/or excel and it then links B1 and B2.
I currently have to either copy and paste all 50 names and then all 50 fax numbers in my hand, or I drag the excel cells from row B to replace row A and then update the link in word so it shows up. But this is a painful process.
Is there any possible solution to my woes?
