Hello,
I have a master excel spreadsheet. What I’d like to do is insert word documents in separate tabs on this worksheet. I have done that (although only 1 page is visible until I go into edit them, then the whole document shows up – is it possible to see all pages of the word doc at once?).
What I’d like to do next is add into that word document an excel table(?) where I can use a formula to get certain cell values from the initial excel worksheet and add them into the new word document page. Does that make sense?
If it’s easier to understand with details – I have a master price sheet for all products, in excel. I’d like to have our on-line product sheets (usually done in word and/or pdf, or publisher) be able to link back and reference the current price of the product and add it to product document, plus then I’d like to break that price down with another formula as to what it will cost per day for this item.
does anyone know if this is possible to do?
Thank you
I have a master excel spreadsheet. What I’d like to do is insert word documents in separate tabs on this worksheet. I have done that (although only 1 page is visible until I go into edit them, then the whole document shows up – is it possible to see all pages of the word doc at once?).
What I’d like to do next is add into that word document an excel table(?) where I can use a formula to get certain cell values from the initial excel worksheet and add them into the new word document page. Does that make sense?
If it’s easier to understand with details – I have a master price sheet for all products, in excel. I’d like to have our on-line product sheets (usually done in word and/or pdf, or publisher) be able to link back and reference the current price of the product and add it to product document, plus then I’d like to break that price down with another formula as to what it will cost per day for this item.
does anyone know if this is possible to do?
Thank you