Quote:
Originally Posted by Jiing Chiang
Hi macropd, the reason it has to be done in excel first is because I require another team to fill in the variables for me.
|
of itself, that doesn't mean you need to involve Excel - it could still all be done in Word.
That said, your users could type their supplemental info into column D on sheet1. The Data sheet could then use formulae like:
="You should wake up tomorrow morning at "&Sheet1!D2&"am."
="You should eat "&Sheet1!D2&" for breakfast tomorrow."
etc.