I'm in a problem as per the question, i want to display the data on the basis of heading. Heading's position may subject to change from column A to C per week, so =InputA1 formula is not what i need.It have to match both tab headings and display under output tab ( under the matching heading ).
One more thing i need is input may contain huge data where i want to
avoid the row if stock less than 10
avoid the row if code is empty
avoid the row if UNC is 0 or blank
A sample sheet is dropped below where there is estimated output also. Please help me.