Unless you have a real requirement for doing it that way, it's probably more
trouble than it's worth...........you're better off with all the data in one
database........if you want to see only one department at a time, use the
Data > Filter > AutoFilter feature and select one department from the drop
down arrow on that column.........

Vaya con Dios,
Chuck, CABGx3



"LLoraine" wrote:

> I have a master spreadsheet that has 3 columns of data. The first column is
> the Dept - lets say Dept A, B, C and D. There are 2 other columns of data.
> I would like to have separate spreadsheets for each department.
> Every time I enter information on the master spreadsheet, I would like
> (according to what Dept is entered) the data to automatically populate that
> department's spreadsheet. Is this possible?