1

I'm building a dashboard in an Excel 2015 worksheet that summarizes sales activity from two tabs. Each tab has a dynamic PivotTable exported from an Advanced Find query in Microsoft Dynamics 2015, which includes an SQL database connection.

I'd like to be able to type in dates on this dashboard sheet (in corresponding "On or After" and "On or Before" cells) that can update the queries in both tabs' connections accordingly. The purpose of this is to avoid opening a connection's properties and update the SQL date string manually for each tab.

pnuts
  • 58,317
  • 11
  • 87
  • 139
doubledell
  • 11
  • 2
  • so what have you done. This is a programming site – Drew Nov 03 '15 at 03:19
  • 1
    How can this have been upvoted? There isn't even a question in this question post! @doubledell, please give worksheet and SQL details, show what you have tried that isn't working for you ... and pose a specific question. – Ambie Nov 03 '15 at 06:29
  • Please refer to this site here for future Questions: https://stackoverflow.com/help/how-to-ask @Topic: This Thread helped me alot with a similar issue https://stackoverflow.com/questions/1285686/excel-use-a-cell-value-as-a-parameter-for-a-sql-query – G.M Oct 25 '19 at 07:42

0 Answers0