Data to a simple paragraph.

[Guest]

Hello, I work in an office where I do a lot of data entry. I recently
received a mess load of work to do where the data has to be calculated,
processed and recorded into Excel and then has to be put into a paragraph
form and recorded in a separate database.
Unfortunately, for the amount of work it requires, it takes a lot of time.
Is there a way that I can enter in the figures so that excel does the math
for me and then places it in the text paragraph that I would use via 'Cut and
Paste' for the alternate database?

and if there is, what exactly am I looking for...? Is it a script...?
Macro...?

 

[Pete_UK]

What kind of paragraph are you talking about, and how will Excel know
what words to use?

If it is something like "This week's total is xxx.x" and you want
Excel to calculate the "xxx.x", then you can do this in a cell, with
the calculated value in A1:

="This week's total is "&TEXT(A1,"000.0")

Hope this helps.

Pete

 

[Guest]

thats pretty much what I need... but with multiple values... the Word format
I am using is....

Received settlement offer from WAMU# XXXX Balance of $XXXX offering
settlement of 30% $XXXX payable in one lump sum by EOM. Or 40% for $XXX
payable in 3 payments of $XXXX

Each 'XXX' would be a value from a different cell....

Would it be the same basic macro set up?

 

[Guest]

thank you pete... with the code you gave me, I was able to figure it out.

This is going to save me A LOT of time...

 

[Pete_UK]

Glad to be of help - thanks for feeding back.

Pete