Consulting

Results 1 to 2 of 2

Thread: Revise tables in a word document based on a reference table in excel

  1. #1

    Revise tables in a word document based on a reference table in excel

    Hello,

    I have a Word file which includes some paragraphs and a few tables (3-columns, unknown rows). I need to revise those tables based on a table in excel. for example all tables have 3 columns of car's name, car's year, and car's price. but I have a reference table in excel that says some cars have different price with the same car's year. In other words, for example the reference table in excel says, Benz is $100000 and Hyundai is $15000, but their price in the Word file is different. I want to revise the Word tables to see $100000 and $15000 for Benz and Hyundai.

    Important: Note that in the Word tables we don't see a pure car name, for example we see Benz L9000C or Hyundai Accent 2014. but in the reference table in excel we see pure car names (with no suffix and prefix).

    Thank you.

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Cross-posted at:
    http://www.msofficeforums.com/word-v...nce-table.html
    https://www.mrexcel.com/forum/excel-...ble-excel.html
    http://www.tek-tips.com/viewthread.cfm?qid=1780266
    http://www.vbforums.com/showthread.p...table-in-Excel

    ​Kindly read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq...._new_faq_item3

    This is the third time in three consecutive threads you've been pinged for this. Since you can't be bothered with the board rules, I'm closing this thread. Do it again and I'll terminate your account here.
    Last edited by macropod; 08-29-2017 at 09:14 PM. Reason: More cross-posts found
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •