Results 1 to 2 of 2

Pivot table with data in multiple files

This is a discussion on Pivot table with data in multiple files within the Excel Questions forums, part of the Question Forums category; I have 19 files. Each file contains a month's data and can vary from 3,000 to 15,000 rows. the first ...

  1. #1
    Board Regular mayday1's Avatar
    Join Date
    Oct 2007
    Location
    Dallas
    Posts
    164

    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

    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

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