Using MSQuery on a tab in the current workbook

H

Humphrey

I have a dataset that I import from a SharePoint site that contains many
years of data. This is being returned into a tab of my workbook. How can I
use MSquery to copy on the last 365 days of data into another worksheet?
I need to pivot and chart the last 12 months of data each time I update the
spreadsheet and from what I can see the filters available do not have a "Last
12 months" option. This I thought would be a good work around.

H
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Power Pivot. Yikes. 0
A couple questions BEFORE using Office 365 0
creating a query using MSQuery 0
Creating a Chart on form from selected data in query. 0
pivot table rolling 12 month filter? 1
MSQuery does not see the tables in an excel workbook, help. 3
Getting external data from Access 2007 using msquery 0

Top