Lookup Value in Column return entire row

[Soybean]

Hi Everyone,

I have a master worksheet that contains data in columns A through AP, and in many, many rows. (this is a monster). I need to have some sort of function (or macro) to be able to identify all of the rows in column H that have a value of x (to be replaced by actual value), and return all of those rows to a new worksheet. I need for the rows to retain the formatting and formulas that are in there. I thought the auto filter would work, but it does not. Anyone have any other ideas?????

[Richard Buttrey]

Hi,

If this is a one off task then it would be as quick to use auto filter on column H. Then just copy all the filtered rows and Paste them to a new sheet

Alternatively you could use the Data Filter Advanced Filter, copy to an other location functionality.

HTH