+ Reply to Thread
Results 1 to 2 of 2

Can't paste Into AND under Table

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,974

    Can't paste Into AND under Table

    Data Set is too big, so no example attached. But I think I can explain it.

    My old data set, which is a TABLE, is 32 columns wide and 49552 rows deep. Now I want to paste in updated data.

    I copy my new data, minus the headers.

    I select the first row under my headers in my TABLE, and paste as values my new data, which is 32 columns wife and 67582 row deep.

    My new data doesn't paste in the rows under the existing table. Though it has the shadow like I pasted there, the cells are empty. So I still have 49552 rows of data.

    I tried copying just a few pieces of data, and pasting under the table, and it works fine.

    However, if I copy a small set, like five rows, and paste by clicking into the last populated row of my TABLE, nothing gets pasted into the 4 rows below.

    What am I doing wrong?
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,974

    Re: Can't paste Into AND under Table

    Never mind, I found it. Stupid me. I had a filter on.

+ 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. Replies: 1
    Last Post: 05-11-2021, 04:58 PM
  2. Copy cell values, add a new row on table and paste them at the bottom of a table
    By ApexDmac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2019, 11:00 AM
  3. Replies: 22
    Last Post: 01-30-2019, 01:09 PM
  4. Replies: 2
    Last Post: 07-24-2017, 02:40 AM
  5. cut cells and paste to table on separate worksheet/table on button click
    By mustang__1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-23-2014, 11:57 AM
  6. [SOLVED] Copy and paste formula outside pivot table using information from table
    By batjl9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2014, 07:10 AM
  7. Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position
    By webfeet2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 06:34 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