DataFilterAutofilter.

Filter for Burger King on column I.

Copy and paste the results to a Burger King sheet.

If you need code for copying, adding a sheet and pasting try Ron de Bruin's site
for methods.

http://www.rondebruin.nl/copy5.htm

More on Copying, Pasting and Merging at Ron's Excel Tips page.

See link when on the above page.


Gord Dibben MS Excel MVP

On 3 Feb 2007 20:05:13 -0800, "tnederlof" wrote:

Hey right now I have a huge excel sheet with like 250 columns and
there are about 250 rows but I need the macro to go up to 1500 because
I will be getting more data. In the column "i" I have different
strings such as "Burger King". I need a macro that will copy every row
in the sheet that is the value of Burger King in "i" for example to
its own sheet entitled that value. Can someone help me out please? I
tried a few things I found by searching but they didn't work.

Thank you very much!