I maybe have done this harder than I have to but Iv been struggling a few days with getting it to work.
I want to make a list with information in everything that has status "patched" in my lists. This goes:
If a cell in column D on sheet "fixture list" shows "PATCHED" I want to take the information in Column A (with is Unit number) on the same row and lookup information from the row with the same Unitnumber on sheet "Art48-1".
And this information I want to auto sort by Unitnumber. With will be column A.
Did I make it clear? I can send the excel file if that helps better.
I want to make a list with information in everything that has status "patched" in my lists. This goes:
If a cell in column D on sheet "fixture list" shows "PATCHED" I want to take the information in Column A (with is Unit number) on the same row and lookup information from the row with the same Unitnumber on sheet "Art48-1".
And this information I want to auto sort by Unitnumber. With will be column A.
Did I make it clear? I can send the excel file if that helps better.