"Ardus Petus" <ardus.petus@laposte.net> wrote in message
news:uAitEUaeGHA.1320@TK2MSFTNGP04.phx.gbl...
> It would help a lot if you could post some sample data of Workbook A, or
> better still, upload it to http://cjoint.com and post back the link.
>
> TIA
> --
> AP
>
> "Rich" <nosp@amnospam.net> a écrit dans le message de news:
> Vc2dnQOs7LJUmfbZnZ2dnUVZ8sidnZ2d@bt.com...
>> Hi,
>>
>> Current Manual Process for Sales Data by Branch is:-
>>
>> Open Workbook A (List of all data by operative with branch code in column
>> a, operative in B, with the remaing columns containing all the data.)
>>
>> Open B
>>
>> Type the branch code in a cell, vlookups then pull all the data for that
>> branch by operator.
>>
>> That bit I'm happy with.
>>
>> That file is then copied and paste specialled in a new workbook, which is
>> saved with the branchcode as a file name.
>>
>> I'd love a Macro which works through a list of branch codes, pulls the
>> data from wookbook A by vlookup, then pastes the values to a vew workbook
>> which it saves with the branchcode as the file name.
>>
>> Can anyone suggest a macro to do this ?

If I've done it OK, the sample data is here:-

http://cjoint.com/?frqFibMWfC

In that small sample, the second workbook would lookup the data from ytg567,
then I'd save it under filename ytg567.xls.

I want to automate working through the branch list, looking up the data and
saving as branch name.