I created a tab to pull out "problems" for a team member to research and enter the correct info columns adjacent -- Cols A:H are 'problematic' and I:O are where the correct information will be added, which I will then use to update the main sheet.
Is there anyway to set this up so when more items are added, or the columns are sorted that keeps each row A:O together?
Is there anyway to set this up so when more items are added, or the columns are sorted that keeps each row A:O together?
SQL:
=QUERY({J.ReviewList!A3:P}, "SELECT Col1,Col2,Col3,Col4,Col11,Col12,Col13,Col15
WHERE Col14 = 'prob.JJ' AND Col15 LIKE '%wrong%' AND Col9 = 'previous' ORDER BY Col2")