Macro for Breaking out Rows
 

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 similar to the
table I am pulling from. 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!

Macro for Breaking out Rows
 

Have you tried using
datafilterautofilter
or advanced filter

--
Don Guillett
SalesAid Software

"cardan" wrote in message
oups.com...
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 similar to the
table I am pulling from. 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!

Macro for Breaking out Rows
 

I have not. That may be what I need. I will look into it and see if it
works. Thanks for the response!

Dan


Don Guillett wrote:
Have you tried using
datafilterautofilter
or advanced filter

--
Don Guillett
SalesAid Software

"cardan" wrote in message
oups.com...
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 similar to the
table I am pulling from. 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!