Extract row based on cell text with header

[sahana108]

Hi All,

I have a sheet with header A1:T1.

I would like to extract all the rows with a header with cell text in column B in new sheets.

I have to extract 4-5 different names IN DIFFERENT SHEETS.

Thank you..!!

 

[rpaulson]

Create a worksheet for each uiniuqe item in my Data range?

I see a lot of request for some VBA code to create individual sheets out of my data. (Like: "I want a sheet for every part number in my list") I put together some code to automate the process for you. Enjoy! Sub Create_Worksheets() 'This macro will seperate the data in your range into...

www.mrexcel.com