Filter external data

  • Thread starter Thread starter El Jefe
  • Start date Start date
E

El Jefe

Hi

I am creating a cash flow report in excel.
My data is SQL data. I've created an external datasource and I can access it
without any problem.

But... I would like to ask my user for which week he wants to see the data
and only that data should be shown.
How can I create something like that ?

Thanx in advance
 
I would create a macro to run MSQuery to retrieve the data, and use the
"filter" therein to get the dates I want......or, if you prefer to retrieve
all the data first, then just write a macro to ask the user for the desired
date-range and use Autofilter to display it.

Vaya con Dios,
Chuck, CABGx3
 

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

Criteria for external data in a pivottable 1
Pivot Table with MS Access as DataSource 1
Import External Data 3
Import External Data not picking up letters 2
How to manage new data with external data in Excel? 1
How to Create a Macro to Import External Data 0
External Data Refresh Issues 0
Error when Formula references a pivot table in an external workboo 2

Back
Top