Forum Discussion
Automatically copy rows with certain keywords in a particular column to another worksheet
Hi All, Scenario: From attached sheet, I want all rows that contain 'No' in the 'Available' column (E) to be automatically copied to Sheet 2. This action should be automatically executed as the p...
Hi Dazumi30
There is no solution without a macro or script best to my knowledge, but you can use Power Automate to get this action done on schedule time/automated flow.
The best solution what I would suggest you is to make master data and generate Pivot Table & refresh your data keeping the filter as No. Just to look but dynamic add slicers to your report
Attached is the sample file for your reference.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more