Quote:
Originally Posted by USAMA
Hello everyone .
I extract data from ms excel master file through mail merge technique. In my comparative statement all the things like names,topic,percentages,total and individual contractor amount came from excel through mail merge and then i insert the Bill of quantities item manually and insert rates , quantities and total manually in the estimate columns as u can in the attached file. In the comparative it have 3 contractors rates rates and total which are same as the estimate.i just to know is there any easy technique other then copy paste. so i just click 1 button and all the rate and total amount easily paste on the other 3 contractor columns.
|
Hi,
I'm looking at your table, and my first thought would be to do the whole thing in Excel, rather than bringing it over into Word. Excel will be much easier, I think.
You can do all the calculations much more easily in Excel. In the end, if it has to end up within a larger Word document, you can paste the Excel range into your document, either retaining its Excel properties or converting it to a table.
Looking at your work, you use a lot of paragraph marks, apparently to align your numbers on the bottom row of the cell. Looks like you didn't do this for item 9. Why not use your cell alignment in the table layout?
Also, I'm seeing at least three different fonts and varied font sizes on the pate. This will look better if you use either Arial throughout, or Times New Roman throughout. Also make your headers in the top row the same size and font.
If I understand your project correctly, in your example the rates are all the same for all three contractors, but in practice they will be the same quantities but different rates? Otherwise, why would you compare three side by side if they are always identical? In theory, you could use fields, or bookmark and cross reference, to copy the text from the estimate quantity column to the Contractor A quantity column, but in reality Excel is going to be way easier. Within Excel, you could just type "=C3" into cell G3 and I3 and that simple formula would copy the values over from the C column.
- Ann