Multiple Sheets of Website Data, New Sheet For Every Day, Need to Consolidate it into One!

[humpa16]

Hi,

I have data from a website. Along the left column the pages that were clicked in a given day are shown and then a column for the # of clicks and then one final column for the processing time of each click. I make a new sheet with every days data and need to consolidate it into a months worth. My problem is that It only shows the pages in the site that WERE CLICKED not every page so each days list can be slightly different i.e. not including a page if it wasn't clicked thus the whole list is different.

How can I consolidate it with this issue?

Thanks!

[dflak]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. 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 shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[humpa16]

Hi thanks for your swift reply. I have attached an example version of what I need done, and the Summary sheet is the result I want to automate (I did it manually). In the real version its the same but just with hundreds of page on each day.

[dflak]

I was going to take advantage of this opportunity to learn PowerPivot, but all the examples I can find refer to External Data Sources, not sheets within the same workbook. If anyone happens to know how to do this, I am interested. Anyway, PoewerPivot might not work since we need the sheet name and that's not part of the tables.

So the program simply loops through the sheets (except for Summary and Data) and copies and pastes the data on each sheet into the Data Table on the Data sheet. This table is used as the data source for the pivot table on the summary sheet.