+ Reply to Thread
Results 1 to 2 of 2

Dynamic copy of table

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    Brisbane, Queensland
    MS-Off Ver
    Excel 2010
    Posts
    9

    Dynamic copy of table

    Hi Excel Forum,

    My first query was solved successfully a while ago. So here is my latest question.

    I have a table that contains all the the variations on my contract. The table also contains the information of how the variation will impact the costs of the project. (The table thus contains all internal reporting data)

    I have a second table that contains the same basic data as table on, but this one I use to claim the revenue from the client. (I use a second table as table 1 contains confidential information I don't want the client to see)

    My question is How to create the second table so that it is dynamic, so that when I enter the basic data in table 1 if is automatically reflected in table 2. (I can do this if I default the able to a specific size, but I would prefer the table to be only as big as required. i.e. if there is only one variation i only want the table to be one line long)

    I only want to enter into the "salmon" coloured cell. On the claim tab I would only like to have to enter the claim qty.

    Thanks

    Quintin
    Attached Files Attached Files
    Last edited by qdavq; 08-30-2014 at 05:16 AM. Reason: prematurely posted

  2. #2
    Registered User
    Join Date
    03-01-2013
    Location
    Brisbane, Queensland
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Dynamic copy of table

    what????? no takers for this little problem????

+ 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 dynamic data from one table to another one with 2 conditions
    By sa4a in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2014, 04:41 PM
  2. Copy and paste dynamic ranges + transforming into a table
    By tigerallied in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2013, 01:26 PM
  3. Excel 2007: Copy dynamic table from one sheet to another
    By lilbird1981 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2012, 10:43 AM
  4. using a dynamic reference cell to copy a range of cells within a data table
    By mcash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2010, 10:22 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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1