Pivot table with data in multiple files

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot table with data in multiple files

  1. #1
    Board Regular mayday1's Avatar
    Join Date
    Oct 2007
    Location
    Dallas
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table with data in multiple files

     
    I have 19 files. Each file contains a month's data and can vary from 3,000 to 15,000 rows. the first row in each file is exactly the same - a header row of about 50 column headings. Is it possible to do a pivot table for 19 files at a time? Or, better still, is it possible to do a pivot table for all files in a certain folder?

    I know I can consolidate them all into a single file but I'd like to aviod that. Plus the individual files are edited sometimes so I'd need to repeatedly consolidate the files.

    Perhaps there's a way to consolidate all files in a folder with a macro?
    Thanks for the tips

  2. #2
    New Member
    Join Date
    Jul 2009
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table with data in multiple files

      
    I did a lot of research on this once and no I do not believe it is possible, maybe only with some kind of crazy code but I couldn't find that anywhere either.

    Use MS ACCESS then export to Excel if you must

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com