Macro for Breaking out Rows based on a Value

C

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

Cindy M.

Hi [email protected],

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.
Click to expand...

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 :)
 
Top