input data in my master list, and automatically have each site appear in it's own wor

Good Evening All!

What is this VBE? I have a situation that I'm trying to work out too!

I have a master list, of work sites in a workbook (1 page), and then, I have separate workbooks for each site...example, NJ, DE, PA.

Is there a way for me to input data in my master list, and automatically have each site appear in it's own workbook --- based off the state entered from a designated column on my master list?

Here's what the master spreadsheet looks like:

A1:L1 - holds client name, address, phone number, and state
A2:L2 - holds the same information, just different client

There are close to 200 clients that I need to automatically filter, sort, or link to their own respective workbooks - based on their state.

Originally Posted by Radical1

Good Evening All!

What is this VBE? I have a situation that I'm trying to work out too!

I have a master list, of work sites in a workbook (1 page), and then, I have separate workbooks for each site...example, NJ, DE, PA.

Is there a way for me to input data in my master list, and automatically have each site appear in it's own workbook --- based off the state entered from a designated column on my master list?

Here's what the master spreadsheet looks like:

A1:L1 - holds client name, address, phone number, and state
A2:L2 - holds the same information, just different client

There are close to 200 clients that I need to automatically filter, sort, or link to their own respective workbooks - based on their state.

Create pivot tables from your master list and have one in each customer sheet