 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Data 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...? 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 I...@discussions.microsoft.com> 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, [quoted text clipped - 7 lines] > and if there is, what exactly am I looking for...? Is it a script...? > Macro...? 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? > What kind of paragraph are you talking about, and how will Excel know > what words to use? [quoted text clipped - 22 lines] > > and if there is, what exactly am I looking for...? Is it a script...? > > Macro...? 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... > What kind of paragraph are you talking about, and how will Excel know > what words to use? [quoted text clipped - 22 lines] > > and if there is, what exactly am I looking for...? Is it a script...? > > Macro...? Glad to be of help - thanks for feeding back. Pete On Jul 8, 10:54 pm, m4d Ir15h <m4dIr...@discussions.microsoft.com> wrote: > thank you pete... with the code you gave me, I was able to figure it out. > [quoted text clipped - 28 lines] > > - Show quoted text -
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.