Select records to new workbook
 

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

Select records to new workbook
 

Hi Wal50

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"wal50" wrote in message ...
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

Select records to new workbook
 

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

"Ron de Bruin" wrote:

Hi Wal50

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"wal50" wrote in message ...
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