| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select matching records from list | Excel Worksheet Functions | |||
| Randomly Select Records | Excel Worksheet Functions | |||
| How to select certains records meeting a certain condition !!!! | Excel Worksheet Functions | |||
| How to select certains records meeting a certain condition !!!! | Excel Worksheet Functions | |||
| select records with a specific value | Excel Worksheet Functions | |||
Linear Mode
