+ Reply to Thread
Results 1 to 4 of 4

Copy and paste not working in dynamic table range!

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    Perth
    MS-Off Ver
    2010
    Posts
    8

    Copy and paste not working in dynamic table range!

    hi everyone, this is frustrating me to no end!

    I like working with dynamic Excel tables but suddenly, i am unable to copy and paste from one part of the table to another. I copy a line of formulae, and then when i click paste, NOTHING HAPPENS. Excel refuses to allow me to copy and paste. I'm sure it thinks it is being clever as it doesn't want me to copy and paste different formulae for different rows, but this is NOT USEFUL. Please note, i have been able to do this before.

    Does anyone know how to turn this stupid feature off?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Copy and paste not working in dynamic table range!

    Hi,

    See if this web page explains what you need.

    https://support.office.com/en-US/Art...rs=en-US&ad=US

    I do know that tables stop working when there is a blank row or column in it.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Copy and paste not working in dynamic table range!

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    06-23-2014
    Location
    Perth
    MS-Off Ver
    2010
    Posts
    8

    Re: Copy and paste not working in dynamic table range!

    Hi guys,

    i can't replicate this annoying trait with a new table. And i can't upload this broken table because of all the sensitive information contained therein. I'm very irritated.

+ 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. [SOLVED] Copy/Paste Dynamic Range
    By RedStick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2014, 03:38 PM
  2. [SOLVED] Copy and Paste Dynamic Range
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2013, 11:14 AM
  3. Copy dynamic range from previous sheet and paste after last used row in a range
    By Mistweaver in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-04-2010, 06:24 PM
  4. Copy and paste dynamic range
    By wpryan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-16-2010, 09:42 AM
  5. copy formula and paste it to dynamic table
    By Sharky Amit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2009, 02:05 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