I have a need to dump data into a main worksheet and have multiple
supplementary worksheets populate their data based on the value in column A.
Example: Master sheet has data in columns A-F and is sorted by Customer Class
in column A. There are 19 rows of data that have class '06' in column A, and
I create a separate worksheet titled '06' that I wish to have populated with
all the data for class '06' customers via a formula of some kind. A formula
of some sort is preferred over VB script. The purpose of this is to
periodically update the data in the master sheet so it flows down to the
split sheets and populate the charts which I have already set up. Thanks!

I highly doubt you can do this with a formula, since you want to copy
or move the data to other worksheets. I believe Ron de Bruin has some
macro code that you can use to select a column and split out the
information into different worksheets. But I don't know if it works
the way you need it to.

http://www.rondebruin.nl/copy5.htm

Then you could use dynamic named ranges that would auto-update
whatever charts you wanted.


HTH,
JP

On Aug 4, 3:31*pm, Chris Lukowski
wrote:
I have a need to dump data into a main worksheet and have multiple
supplementary worksheets populate their data based on the value in column A.
Example: Master sheet has data in columns A-F and is sorted by Customer Class
in column A. There are 19 rows of data that have class '06' in column A, and
I create a separate worksheet titled '06' that I wish to have populated with
all the data for class '06' customers via a formula of some kind. A formula
of some sort is preferred over VB script. The purpose of this is to
periodically update the data in the master sheet so it flows down to the
split sheets and populate the charts which I have already set up. Thanks!

Thanks, I'll let everybody know if I can get it to work, unless somebody has
a better idea.

"JP" wrote:

I highly doubt you can do this with a formula, since you want to copy
or move the data to other worksheets. I believe Ron de Bruin has some
macro code that you can use to select a column and split out the
information into different worksheets. But I don't know if it works
the way you need it to.

http://www.rondebruin.nl/copy5.htm

Then you could use dynamic named ranges that would auto-update
whatever charts you wanted.


HTH,
JP

On Aug 4, 3:31 pm, Chris Lukowski
wrote:
I have a need to dump data into a main worksheet and have multiple
supplementary worksheets populate their data based on the value in column A.
Example: Master sheet has data in columns A-F and is sorted by Customer Class
in column A. There are 19 rows of data that have class '06' in column A, and
I create a separate worksheet titled '06' that I wish to have populated with
all the data for class '06' customers via a formula of some kind. A formula
of some sort is preferred over VB script. The purpose of this is to
periodically update the data in the master sheet so it flows down to the
split sheets and populate the charts which I have already set up. Thanks!