News0 min ago
Excel or Word
Im looking to set up a template where by I would enter numerical values and text - calculations done on these values and then output into a pre-defined letter. Is this possible?
Answers
Best Answer
No best answer has yet been selected by MarkyP05. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.everything is possible in time ...
in word it's difficult - in excel it's relatively simple
if the text is
Oranges bought 5
Oranges sold 3
Oranges in stock B3 = b1-b2
it's perfect for invoices where sticking to the boxes is acceptable
sorting words from numbers and calculating is a pig in word - and because you're asking if ... I guess that writing a macro isn't an option
in word it's difficult - in excel it's relatively simple
if the text is
Oranges bought 5
Oranges sold 3
Oranges in stock B3 = b1-b2
it's perfect for invoices where sticking to the boxes is acceptable
sorting words from numbers and calculating is a pig in word - and because you're asking if ... I guess that writing a macro isn't an option
Ive managed to do what i've wanted on excel which is fairly basic - its just transfering that information into a template letter i.e.
excel (simple example)
A B
1. Purchased Price(wholesale) �0.35
2. Oranges at Open 50
3. Oranges at Close 35
4. Oranges Sold 15 (b2-b3)
5. Selling Price �0.50
6. Profit Margin �0.15 (b5-b1)
7. Days Profit �2.25 (b4 x b6)
8. Close Stock �5.25 (b5 x b3)
output (word/ letter?)
Dear Boss
We have managed to sell (b4) oranges today, this gives us a daily profit of (b7).
At close we have (b3) oranges left. At (b5) per orange this values the stock at (b8).
Regards
The above is kinda what im looking for.
Macro not really an option no.
excel (simple example)
A B
1. Purchased Price(wholesale) �0.35
2. Oranges at Open 50
3. Oranges at Close 35
4. Oranges Sold 15 (b2-b3)
5. Selling Price �0.50
6. Profit Margin �0.15 (b5-b1)
7. Days Profit �2.25 (b4 x b6)
8. Close Stock �5.25 (b5 x b3)
output (word/ letter?)
Dear Boss
We have managed to sell (b4) oranges today, this gives us a daily profit of (b7).
At close we have (b3) oranges left. At (b5) per orange this values the stock at (b8).
Regards
The above is kinda what im looking for.
Macro not really an option no.
What you need to investigate is setting up a mailmerge from Ms Word linking to your excel spreadsheet. I did this when I was working, but since retiring, I am using OpenOffice.Org at home so any explanation i could give now would be slightly different from how it would be done with Microsoft software.
I hope I have pointed you in the right direction.
I hope I have pointed you in the right direction.
Could you not just do it as a simple table showing the numbers selt, the profit etc? Does the boss need to have in the form of a letter? If he does can you not just write out the words leaving a cell free for the appropriate figure and then adjust the cell width so that it looks okay? You can then highlight the area to be printed and then Robert is yir father's brother!
right ... easy
the best way to explain is if you look at word's help
open help - type "embed object"
basically highlight the result in excel - copy
switch to word - paste special | MS office excel worksheet
the results will (should) update automatically
if not right click and update
if you save the word document as a template and use the same excel sheet it will be stress free
if you need a permanent record close word - use "Save As" in excel
the best way to explain is if you look at word's help
open help - type "embed object"
basically highlight the result in excel - copy
switch to word - paste special | MS office excel worksheet
the results will (should) update automatically
if not right click and update
if you save the word document as a template and use the same excel sheet it will be stress free
if you need a permanent record close word - use "Save As" in excel