Macro for Breaking out Rows based on a Value

[carlsondaniel]

Hello, I have a table consisting of multiple rows and columns on a
sheet and I
need to break out certain rows depending on a specific value in the
column into a new sheet. For example, I have a list with multiple
"companies", "contract numbers", "contract dates",
"contract amounts", "payment dates", etc... I need to break out
all the rows of a specific company into another sheet. On that new
sheet I
need to break it out even further by "contract number" and even further
to show what
has been paid and what has not (which is in the original table). I
would try to do a row count with indexing and matching but since I need

further breakdowns on the new sheet, I don't think this is possible.
I have tried some pivot tables but I don't think they can produce the
format I need, which is just a basic view of the numbers. I am
thinking of a module button that can populate the list and will update
everytime it is pressed but I am not sure if that is the right
thinking. Any suggestions? Thank you in advance!

 

[Cindy M.]

Hi (e-mail address removed),

The better place to get a good discussion on this question would be an
Excel newsgroup. There used to be a way in Excel to create an advanced
criteria query... Looks like this is now the Filter/Advanced filter
command. Take a look at using that?

Hello, I have a table consisting of multiple rows and columns on a
sheet and I
need to break out certain rows depending on a specific value in the
column into a new sheet. For example, I have a list with multiple
"companies", "contract numbers", "contract dates",
"contract amounts", "payment dates", etc... I need to break out
all the rows of a specific company into another sheet. On that new
sheet I
need to break it out even further by "contract number" and even further
to show what
has been paid and what has not (which is in the original table). I
would try to do a row count with indexing and matching but since I need

further breakdowns on the new sheet, I don't think this is possible.
I have tried some pivot tables but I don't think they can produce the
format I need, which is just a basic view of the numbers. I am
thinking of a module button that can populate the list and will update
everytime it is pressed but I am not sure if that is the right
thinking.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[carlsondaniel]

Oops, my bad! I thought I was posting this to an Excel Group!

 

[Cindy M.]

Hi (e-mail address removed),

Oops, my bad! I thought I was posting this to an Excel Group!

Not bad Simply there aren't a lot of Excel specialists who
visit this "general" (office.developer.vba) group.

Cindy Meister