Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2021, 12:17 PM
USAMA USAMA is offline Required MS-WORD table copy paste solution from one column to another column Windows 10 Required MS-WORD table copy paste solution from one column to another column Office 2019
Novice
Required MS-WORD table copy paste solution from one column to another column
 
Join Date: Nov 2021
Posts: 5
USAMA is on a distinguished road
Default 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.
Attached Files
File Type: docx test.docx (31.0 KB, 7 views)
Reply With Quote
  #2  
Old 11-30-2021, 01:35 PM
kilroyscarnival kilroyscarnival is offline Required MS-WORD table copy paste solution from one column to another column Windows 10 Required MS-WORD table copy paste solution from one column to another column Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by USAMA View Post
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
Reply With Quote
  #3  
Old 12-04-2021, 03:43 AM
USAMA USAMA is offline Required MS-WORD table copy paste solution from one column to another column Windows 10 Required MS-WORD table copy paste solution from one column to another column Office 2019
Novice
Required MS-WORD table copy paste solution from one column to another column
 
Join Date: Nov 2021
Posts: 5
USAMA is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 12-05-2021, 04:12 PM
Guessed's Avatar
Guessed Guessed is offline Required MS-WORD table copy paste solution from one column to another column Windows 10 Required MS-WORD table copy paste solution from one column to another column Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #5  
Old 12-05-2021, 05:31 PM
Charles Kenyon Charles Kenyon is offline Required MS-WORD table copy paste solution from one column to another column Windows 10 Required MS-WORD table copy paste solution from one column to another column Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft