If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to pull in rows based on Column A data?
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! |
#2
|
|||
|
|||
How to pull in rows based on Column A data?
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! |
#3
|
|||
|
|||
How to pull in rows based on Column A data?
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! |
Thread Tools | |
Display Modes | |
|
|