Paste special issue From Excel to Word

0 votes
I have an Excel 2013 document with numerous tables of data in it. I also have a Word 2013 document with blank table cells in it. I want to link the Word document to the Excel document so that when the Excel document is updated with new data, the Word document also updates.

My issue is that when I choose numerous cells in Excel, select the same number of cells in Word, and then paste in the data using the paste special command, ALL of the Excel cells are placed into the upper-left cell in Word. Strangely, regular pasting hasn't had a problem with this. Just the unique pasting. I can special paste one cell at a time, but in my case, that's thousands of cells, and not worth my time if there's a better way. So, is there a way to paste special multiple cells from Excel into a multiple cells in a Word table?
Nov 20, 2022 in Others by Kithuzzz
• 38,000 points
611 views

1 answer to this question.

0 votes
Since the table in the word document is empty, you might try copying the full table in excel and then replacing the word document table with it (or delete the word table first, and then do a special paste)

I hope this helps you.
answered Nov 20, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
0 answers

VBA SQL Connection to Excel from Word returns no records

Trying to figure out how to read ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 38,000 points
570 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,653 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 23,260 points
7,984 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
14,049 views
0 votes
1 answer

How do I set the default paste special in excel to paste only values

I paste the values with a keyboard ...READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,600 points
3,528 views
0 votes
1 answer

Copy data with filter applied using Excel VBA

Try this: Private Sub CommandButton1_Click() Dim ...READ MORE

answered Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
541 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,260 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,698 views
0 votes
1 answer
0 votes
1 answer

Trying to create an enclosing bookmark after pasting a picture from Excel into Word using VBA

Try this: Sub IMPORT_TO_WORD() Dim ws1 As Worksheet, ws2 ...READ MORE

answered Oct 30, 2022 in Others by narikkadan
• 63,600 points
889 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP