+ Reply to Thread
Results 1 to 3 of 3

Copy table data body range to another table

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Copy table data body range to another table

    Hello

    I have two main tables, and I am looking to copy each table rows to the result table
    and adject the result table (add or delete entire row) based on the main table rows count

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2404-17531.20128
    Posts
    1,361

    Re: Copy table data body range to another table

    Although your tables look empty - they are not.

    I have emptied your tables on the attached, on your original they both contain 1 row. You can delete that row and it will look the same.

    You will see what i mean if you run my code on your original file.

    I also would not have one expanding table under another - they will work better side by side.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by CheeseSandwich; 05-27-2022 at 07:35 AM.
    If things don't change they stay the same

  3. #3
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: Copy table data body range to another table

    thanks but this didn't work fine
    about tables under each other, I need this point because I will use it in this design
    I think this procedure will be fine
    - delete table rows
    - add x rows (same main table rows count)
    - paste value

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy table from excel and send as html email body
    By maamon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2021, 03:54 AM
  2. Replies: 1
    Last Post: 05-11-2021, 04:58 PM
  3. [SOLVED] Send Table/Range of Cells As Part of Body through Outlook(HTML) using VBA
    By richardking in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-30-2016, 08:58 PM
  4. [SOLVED] Copy Pivot into Table - - headers going into Table body
    By michellepace in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2016, 08:39 PM
  5. Replies: 1
    Last Post: 09-16-2014, 05:01 PM
  6. Find the range of a table & copy/past into body of an Outlook email
    By JamesGilchrist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2014, 08:44 PM
  7. [SOLVED] How to copy table from Outlook mail body in to text file
    By Draconi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2013, 02:43 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1