folks, the powers that be insist on our reporting being presented in word documents. Being rather busy with all their other requirements, i do not want to have to manually go through each Word doc to copy and paste in values here and there. I thought of setting up the required text entries in Excel as formulas (eg: ="Total sales this month ("&A8&" ) are $"&A10, where A8 is the date and A10 the $$. Once again, I would like to avoid the copying and pasting of these text entries.
can it be done the other way around? where the word document is set up as a template that links to the specific values within the excel file. sort of like Total sales this month ("&'[Money File.xlsx]Sheet1'!$A$8&" ) are $"&'[Money File.xlsx]Sheet1'!$A$10
plenty of posts around about embedding files into the word doco but nothing i can find to actually link in the value into statements in word.
can it be done the other way around? where the word document is set up as a template that links to the specific values within the excel file. sort of like Total sales this month ("&'[Money File.xlsx]Sheet1'!$A$8&" ) are $"&'[Money File.xlsx]Sheet1'!$A$10
plenty of posts around about embedding files into the word doco but nothing i can find to actually link in the value into statements in word.