ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   User input for import data function (https://www.excelbanter.com/excel-discussion-misc-queries/225591-user-input-import-data-function.html)

PsyberFox

User input for import data function
 
Hi there,

I have an SQL view generating some data that I then pull into Excel (Import
Data; can then be refreshed). Is there perhaps a way for the user to enter a
certain value for a certain field of the view in Excel and then filter the
data by this selection? I have some sales information that has a salesperson
code and I want to only import a user selected sales person every time...

Thank you for any help...


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com