C
carlsondaniel
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 sheet I
need to break it out even further by "contract number" 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 am thinking of possibly putting in a module button but was wondering
if there is a way to do it with regular formulas. Any feedback would
be most welcome! Thanks for your time.
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 sheet I
need to break it out even further by "contract number" 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 am thinking of possibly putting in a module button but was wondering
if there is a way to do it with regular formulas. Any feedback would
be most welcome! Thanks for your time.