Disperse Data from Single Excel 2007 Workbook to Multiple Workbooks

[JunkyardDog]

Hi all,

Just looking for some macro/developer help for Excel 2007. Basically, I have one database workbook, and I want to disperse the data to various other workbooks as efficiently as possible.

I’ve searched for an answer but all I can seem to find is "How to merge data from multiple Excel workbooks into a single workbook," when what I want to do is effectively the exact opposite!

For an example/more detail on what I’m doing – I have a workbook with a single sheet containing a list of members belonging to a number of organisations and their numeric data for each member. I want to disperse these out to a single workbook for each organisation, but still detailing each member’s details on each workbook. I have already created the templates for each workbook, they have three tabs, I just need the third tab on each workbook to be populated with the respective data from the database workbook.

I hope this makes sense.

TL;DR - need to disperse data from one workbook to individual workbooks - looking to do so with macros/developer tab.

Thanks,
Junkyard