Pulling Specific Rows from a Table onto a New Sheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top