1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Dependent list in excel to create validation

Discussion in 'Software Development' started by raghulvarma, May 14, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. raghulvarma

    raghulvarma Thread Starter

    Joined:
    May 13, 2010
    Messages:
    4
    I needs some info on dependent list in excel to create validation. Please find below my example.

    one work sheet has the employee detais in two differnt columns(A and b) master data.
    Eg;
    sat - Manager
    sai - DBA
    sss- Manager
    xx - Team leader
    AA- Seniour programmer.

    i want to implment the validation in another worksheet based on the above master data. Eg: This sheet has 3 columns.
    Designation, Employee name and Salary,

    Once i type the designation in that column then Employee list needs to filter based on the inputted designation. Example if i enter Manger then employee list needs to display sat and sss only. it sould not allow other names.

    Please Note : Macro is not allowed.

    Regards
    Raghul
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,294
    First Name:
    Wayne
    why is macro not allowed - is this a school/college assignment
     
  3. raghulvarma

    raghulvarma Thread Starter

    Joined:
    May 13, 2010
    Messages:
    4
    We are not enabled with macros,
    is there a possibility to load the list with select query which could have the condition changed dynamically?
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    There is a way to run macro's even though they are disabled. Interested?
    Which Office version are you using?
     
  5. raghulvarma

    raghulvarma Thread Starter

    Joined:
    May 13, 2010
    Messages:
    4
    yes sir, I am using office 2007
     
  6. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    I don't have the solution for you yet but I have the following to test
    There are 3 files in the attached zip file
    - testme.bat
    - OpenAnyExcel.vbs
    - raghulvarma-test.xlsm

    Unpack files and place them all three in the same folder

    The batchfile wiil invoke the vbs script with two parameters, the name of the excel file and the macro to open
    The vbs script will open Excel
    The Excel file with a macro that will be automatically started

    The only condition is that you should be allowed to run vbs scripts.

    If this works as planned you can open any excelfile with this vbscript and run all the macro's disregarding the security settings, this a leak in Microsoft which they acknowledge but will do nothing against (their own words)

    If you further explain exactly what you wish to select then we can go on with macro's and help you.

    Okay?
    Let me / us know if this test works.

    Thanks
     

    Attached Files:

  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/922952

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice