+ Reply to Thread
Results 1 to 2 of 2

Pasting Tables of Varying Sizes in Excel 2016?

  1. 08-13-2021, 01:35 PM #1
    Lakotian
    Lakotian is offline
    Registered User
    Join Date
    08-13-2021
    Location
    Pittsburgh, PA
    MS-Off Ver
    2016
    Posts
    1

    Question Pasting Tables of Varying Sizes in Excel 2016?

    Hello!
    I'm trying to use macros to paste two different data sets that vary in size (depending on the day) onto the same sheet. Is there a way to paste one data set and subsequently paste another data set right below it without any add ons? My goal is to have the sets not overlap and not replace each others data. Thanks!

    Thank you for your help!
    Reply With QuoteRegister To Reply
  2. 08-13-2021, 03:30 PM #2
    Bernie Deitrick
    Bernie Deitrick is online now
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,937

    Re: Pasting Tables of Varying Sizes in Excel 2016?

    Paste the first one into Cell A1, and finf the first cell below the pasted table for the second, like:


    Please Login or Register  to view this content.
    If you describe your actual layouts, the code can be modified to suit.
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking One Slicer To Multiple Tables (Not Pivot Tables) in Excel 2016
    By hkfenmil in forum Excel General
    Replies: 5
    Last Post: 12-04-2017, 10:33 AM
  2. [SOLVED] Copying ranges of varying sizes
    By vectistim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2014, 07:34 AM
  3. comparing 2 different columns of varying sizes in different worksheets.
    By vindieselgal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2011, 06:28 AM
  4. Evenly forecast a group wtih varying sizes
    By brendano in forum Excel General
    Replies: 0
    Last Post: 06-10-2011, 01:54 PM
  5. copying areas of varying sizes
    By phill125 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2009, 10:21 AM
  6. [SOLVED] Creating Macros to work with ranges of varying sizes
    By Excel Grasshopper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2005, 01:05 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1