Select records to new workbook

[Guest]

I have several thousand records in one sheet spread over about 50 branches
(Col. B - the branch codes are in the format aann). For each branch's
records, I need to create a separate workbook named with the branch code.
Thanks in advance
wal50

 

[Ron de Bruin]

Hi Wal50

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

Use the workbook example
http://www.rondebruin.nl/copy5.htm#workbook

 

[Guest]

Thanks Ron. I had found your macro on creating workbooks from worksheets but
couldn't find this one.
FYI:
You probably know this but... The Column I was using was the result of a
prior vlookup and still had a couple of "#N/A" values" (the values not the
lookup formula) They caused the macro to stop at the following line
rng.AutoFilter Field:=FieldNum, Criteria1:="=" & cell.Value
After I took changed those values, it worked just.
Thanks again to you and all on this site for a very helpful resource.
wal50