Forum Discussion
If criteria is met in a certain column on the first sheet/tab of a workbook...
If criteria is met in a certain column on the first sheet/tab of a workbook, how can I have the entire row of info copied over onto a second sheet/tab? I'm trying to create a finance tab on a pro...
The action-led mindset behind this question makes it solution in Excel harder to envisage. Manual processes can be triggered by conditions encountered on the first sheet of the workbook but Excel formulas (as functional programming) are set up to prevent such imperative action.
The alternative way of framing the question is to focus on the finance sheet and post the question 'what is it that I wish to see here?' The FILTER function, placed on the finance sheet, examines data on the first sheet and returns values depending upon what it finds. The formula would be of the form
= FILTER(procurementTbl, procurementTbl[ColumnN] = "Full Receipt")
