I want to CopyPaste the filtered rows data from google sheets based on the following conditions;

I will choose the value from the dropdown list in A2 of “sheet2”>The dropdown cell value matches the value within the header row of “Master sheet”> Filter the non-blank cell values based on matched column value> get the data of Column A2:A, G2:P of filtered rows And display the gathered data in “Sheet2” from A5 cell.

Sohail Sardar Answered question August 21, 2023