+ Reply to Thread
Results 1 to 2 of 2

checklist dropdown function

  1. #1
    Registered User
    Join Date
    peoria, ill
    MS-Off Ver
    Excel 2007

    Exclamation checklist dropdown function

    I need help with creating a function in a workbook I created. Here's the deal. One tab has a worksheet that has 2 columns. ColumnA has text (inspection criteria) the other tab has a dropdown list with "YES/NO". When "YES" is selected in columnB, I need the checklist description copied onto the next tab which is the report tab. There are musltiple rows of descrptions on the first tab that may be copied onto the report tab.

    How do I write this function? All I need is for columnA on the inspection tab to transfer to the report tab.

    Please help as soon as anyone can.


  2. #2
    Forum Expert royUK's Avatar
    Join Date
    MS-Off Ver
    Xp; 2007; 2010

    Re: checklist dropdown function

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!
    Hope that helps.

    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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