Find and duplicate info onto separate sheets

New Contributor

Hello.  I was wondering if anyone could assist me?  I have a sheet of data (multiple rows and columns) and need to know if there is a function or formula that will look at this master table of data, pick out all the rows that have one particular field in common and then automatically duplicate those rows of data onto a separate sheet?  The closest I could find was to use vlookup to pick out the relevant field but I want to return the whole row of data not just one cell?  Is this possible?  Many Thanks!

4 Replies


It could be done as well with Power Query and most probably with dynamic arrays functions, depends on which edition of Excel you are. If more concrete suggestion it's better to have sample file.

@Hans Vogelaar 


thank you for your help

thank you for your help