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.
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!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1