Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data to a simple paragraph.
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...? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data to a simple paragraph.
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 On Jul 8, 4:22 pm, m4d Ir15h <m4d wrote: 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...? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data to a simple paragraph.
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? "Pete_UK" wrote: 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 On Jul 8, 4:22 pm, m4d Ir15h <m4d wrote: 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...? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data to a simple paragraph.
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" wrote: 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 On Jul 8, 4:22 pm, m4d Ir15h <m4d wrote: 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...? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data to a simple paragraph.
Glad to be of help - thanks for feeding back.
Pete On Jul 8, 10:54 pm, m4d Ir15h wrote: 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" wrote: 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 On Jul 8, 4:22 pm, m4d Ir15h <m4d wrote: 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...?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paragraph numbering 1.1.1 | Excel Discussion (Misc queries) | |||
How to insert from name range into a paragraph? | Excel Worksheet Functions | |||
Wanting to link inputed data to a paragraph on a different sheet | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
How do I add (auto text) to a paragraph? | Excel Worksheet Functions |