Hi!
I asked for something similar to this a little while ago, but a more complicated version than what I'm looking for now. I tried to simplify the one I was given by a very helpful member of this forum but I'm no way near their level and couldn't work out how to do it. Is someone could help me write a code for this function that would be great - but as simply as possible so that I can understand how it has been constructed and how to edit it in the future...?
In one sheet of my spreadsheet I have reference numbers on column A. These are linked to orders which are all recorded on an entirely different system. They are manually inputted into the spreadsheet. In column K There is a drop down for the status of this order at completion - whether it has gone ahead, if it is currently pending etc. One of these statuses is "Converted".
I have set up some lovely conditioning which means that when an order changes to Converted in the K column, the reference number in the A column highlights yellow, which is nice for glancing down a list. I now, however, need to somehow lookup all of those reference numbers in A that are set to Converted in K and produce a list of them on a separate sheet. I don't want them highlighted or anything - just plain text (I don't want them to have any aesthetic conditioning if that's possible - just automatic). It needs to pick up ALL of the reference quotes with Converted in the K column and ONLY those, and it cannot just miss lines - they need to all be one under the other on the new sheet.
If possible, this needs to be a case of a single code that I whack into the top cell of the list on the new sheet and the rest files in underneath - no copy and pasting and no dragging down as we don't know how many Converted's there will be in one month and if we have to drag I will have to keep going into the spreadsheet to keep dragging it. That being said, a dragging down is a possible second if that's the only way it can be done - I'll just have to drag it as long a way down as I can to limit how much maintenance needs to be done all the time. But yeah, so, single entry would be best and the dragging is a less enthusiastic option two.
Please can someone let me know how I can do this?
Many thanks!!
Bookmarks