Hi and thank you for reading my post. After hours of research on the web I managed to consolidate many XL files into one master file via VBA Macro.

Now, I need to populate several more columns from a 2nd master file and have to resplit the new resulting master file into individual files (one file per "user name" (a column in the resulting master file)).

Populating the columns from a second master file should not be an issue but I'm not quite sure how to create multiple files from the resulting new master file.

The user data from the new master file will easily be organized via a sort or a filter (sort or filter on the "user name" column).

I'm sure this is would be simple for some more experienced users out there. Any help would be greatly appreciated. I'm comfortable with Excel in general and can tackle simple macros but this may call for some VBA commands.

Thanks,

Vince_64