Quote:
Originally Posted by macropod
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.
|
Hi macropd, appreciate yours and others' input so far.
I've figured out a way to resolve my issues. For anyone else that has looking for a solution to a similar problem, I simply output the text in 'hidden' cells (by that I mean i've just made the text output to cell AC2, AC3 etc). I then inserted an ActiveX button with the following macro:
Sub fillstrategy()
'
' fillstrategy Macro
Sheets("PP").TextBoxes("TextBox 12").Text = Sheets("PP").Range("AC2").Value
Sheets("PP").TextBoxes("TextBox 13").Text = Sheets("PP").Range("AC3").Value
Sheets("PP").TextBoxes("TextBox 14").Text = Sheets("PP").Range("AC4").Value
End Sub
This way the relevant text from the items selected in the drop down menu are auto-filled into the text boxes.
The users then read through the templated text, and update the areas that i've marked with ##XXXXXXXX##.
Just one last question: Is there any way to highlight the ##XXXXX## sections of the templated text? I've highlighted the sections in red in the 'raw data', but when the text pulls through from the INDEX formula, it comes through all black, without the ##XXXX## sections highlighted in red.
And we require the use of excel as our client's data is automatically fed into excel which then auto-populates relevant sections. Appropriate financial calculations are then performed using that data. The outcome of this background research/calculations are then outputted to a templated word document.