Select records to new workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top