Microsoft Word And Excel Puzzle

Discussion in 'Software' started by MEL40, Sep 4, 2007.

  1. MEL40

    MEL40 Private E-2

    Hi

    I type loads of quotes at work using a template designed in Word. I type the description of works in a table with the details on the left and then an amount on the right.

    At the end I add a sub-total figure, the VAT and a grand total figure.

    Is there any way I can get word to calculate these figures for me and update them if they are ever changed so that I can save them on the template?

    I have tried inserting an excel worksheet but it doesn't line up and you keep having to move in and out of it. Other people will use these as well and some of them are not very pc literate.

    Also the formula function doesn't seem to do percentages (for the VAT) and doesn't update if you change the figures.

    This would save me a major amount of time.

    Hope you can help.

    Thanks

    Mel
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds