+ Reply to Thread
Results 1 to 5 of 5

Input variables into contents of cells

  1. #1
    Registered User
    Join Date
    03-26-2019
    Location
    NYC
    MS-Off Ver
    2
    Posts
    3

    Input variables into contents of cells

    I have a list of queries that I use rather frequently and the only thing that needs edited in those queries is essentially a list that the query is searching for. An example query is:

    Capture1.JPG

    I then have a list of Account_numbers on another tab, in column A, in the excel document and I want to know if there is an easy way to have the query list work so it would automatically input the account_account number into the query. I understand I could do a concatenate of the text and do & 'Cells' & sort of thing but I want it to be more functional and also be able to input multiple account numbers, in single quotes, comma separated.

    In the end I want the functionality to show the following when there are multiple account_numbers:

    Capture2.JPG

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,266

    Re: Input variables into contents of cells

    Hi mcfurlong and welcome back to this forum,

    If you have the newer version of Excel and a tool called Power Query or Get & Transform then it will connect to your SQL data. I believe you are asking to have Excel as the filter for your SQL query. I don't have the whole answer but this should start your learning...
    https://support.microsoft.com/en-us/...rs=en-us&ad=us
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,994

    Re: Input variables into contents of cells

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As this is only your second post, I will provide the link for you this time.)

    https://www.mrexcel.com/board/thread...cells.1129816/
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    03-26-2019
    Location
    NYC
    MS-Off Ver
    2
    Posts
    3

    Re: Input variables into contents of cells

    Apologies, did not know that was a rule. Just trying to get some help!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,994

    Re: Input variables into contents of cells

    Of course! This is a help forum and you are not being denied help. However, all forums have rules, in fact the other forum where you posted this has the same cross-posting rule that we do.

    There's a link to our rules at the top of the page in the menu bar - you did agree to them when you joined. We've made them super simple and short, so please take a moment to read them through. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Input Variables
    By dannyboi901 in forum Excel General
    Replies: 1
    Last Post: 03-03-2020, 10:48 PM
  2. If cell 1 contains a number, then auto input contents in other cells
    By MGRIFF12 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2014, 06:57 PM
  3. Replies: 4
    Last Post: 03-07-2014, 09:06 AM
  4. Replies: 2
    Last Post: 09-20-2013, 08:02 AM
  5. [SOLVED] finding an output from 5 variables in an array using exterior input user variables
    By Allsort in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2013, 11:16 AM
  6. [SOLVED] Validating contents of a cell on input based on the contents of another cell
    By Saigonet in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2012, 03:07 AM
  7. Using input variables in the same cell
    By mniel3 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-19-2011, 11:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1