How to pull in rows based on Column A data?

C

Chris Lukowski

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!
 
J

JP

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
 
C

Chris Lukowski

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count rows based on multiple criteria 3
Formulas to reference range based on data in column 8
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Arranging dates in a single column 5
Intersection of row and column based on input 5
Excel Excel Vlookup formula based on cell data 7
return multiple rows of data based on criteria 7
How to import data based on a variable 8

Top