I just says subscript out of range. Could someone post the script
modifed for burger king on a page called "rawdata" and so that the
value is found in column i? Thanks

On Feb 4, 5:34 am, "Ron de Bruin" wrote:
Hi

It use this now
If there is a empty row it not filter all data when you use the AutoFilter example

Set rng = WS.Range("A1").CurrentRegion '<<< Change

You can change it to

Set rng = WS.Range("A1:IV5000")

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"tnederlof" wrote in oglegroups.com...
On Feb 3, 11:17 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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.
Hmm I tried those and they would only copy the first row and that is
it.

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!