| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MSQuery on a tab in the current workbook
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a worksheet to a current workbook | Excel Discussion (Misc queries) | |||
| Adding a worksheet to a current workbook | Excel Discussion (Misc queries) | |||
| MSQuery does not see the tables in an excel workbook, help. | Excel Discussion (Misc queries) | |||
| Cannot be MERGED into the current workbook | Excel Discussion (Misc queries) | |||
| how to I refer to current workbook without using its name? | Excel Worksheet Functions | |||
Linear Mode
