Results 1 to 2 of 2

Thread: appending data to Excel table?

  1. #1
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    275 times in 146 posts

    Question appending data to Excel table?



    any ideas how to append data using the logic shown in the picture?

    done on a weekly basis with massive tables, I need to append new columns onto main table. Problems since new data only has a subset of the horizontal labels, as can be seen, PLUS the labels are multilayered (vertically & horizontally).

    pivot tables tend to use only top set of labels, AFAIK, consolidating (eg) 2005 + 2005

    regular consolidation doesn't like the multi layers either



    am open to using macros too

    Thanks to ImageShack for Free Image Hosting

  2. #2
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    275 times in 146 posts
    bump? no-one?


Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Privacy concern - Scan orders being reported to 3rd parties.
    By Paranoid2000 in forum SCAN.care@HEXUS
    Replies: 35
    Last Post: 09-06-2006, 07:35 PM
  2. Replies: 2
    Last Post: 26-04-2006, 01:16 PM
  3. Access 2002 Copy Data from Form into Table
    By hegaroo in forum Software
    Replies: 1
    Last Post: 09-03-2006, 03:06 PM
  4. 'Simple' excel help please, merging data..
    By Snow-Munki in forum Software
    Replies: 3
    Last Post: 10-10-2004, 12:14 PM
  5. Replies: 8
    Last Post: 21-05-2004, 09:58 PM

Posting Permissions

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