|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Required MS-WORD table copy paste solution from one column to another column
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. |
#2
|
|||
|
|||
Quote:
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 |
#3
|
|||
|
|||
thank u for reply.
the reason i dont make this sheet on excel coz there are 5 pages also include in this document in which the topic,names,percentage,dates, amount are came from excel through mail merge.also the sheet i share the topic, name, percentages, amount are also came from there. so its easier for me to just copy paste boq items from the same topic style doc and change the quantity and amount manually. |
#4
|
||||
|
||||
Ann had some good cleanup suggestions for cell alignment and standardised fonts
In general, if the multiple contractors always use the same rates then it is overly complicated to add the same rate lots of time and costs you and every reader considerable effort to compare numbers throughout the table. It would be a great useability improvement to list the rates only once and only show numbers that vary in columns for each contractor. However to answer your original question you can use a range of methods to reproduce the same content in multiple places. My recommendation is to use mapped content controls but your options are described quite well here Repeating Data (Populating Multiple Like Fields)
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#5
|
|||
|
|||
One more, just on Mapped CCs: Repeating Data Using Document Property Content Controls and Other Mapped Content Controls - with the Document Property CCs you are limited, with ones you create yourself, you can have as many as you want.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is it possible to put a formula in a table column header to define the name of the column? | JacquesW | Excel | 3 | 05-08-2017 08:00 AM |
If column B cell is a certain value then copy and paste the value to column A | Snaybot | Excel Programming | 1 | 12-01-2015 07:10 PM |
Copy column 1 data into Column 3 | ShailShin | Word VBA | 1 | 06-18-2015 10:49 AM |
Excel copy two numbers between specific column and paste in next sheet | visha_1984 | Excel | 1 | 12-26-2014 07:59 PM |
how can i split a column of rows in half without copy and paste.. | Lindseyfparker | Excel | 2 | 04-25-2014 12:52 AM |