Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Breaking out Rows
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
Macro For Breaking Data To Different Sheets | Excel Discussion (Misc queries) | |||
Breaking links in a macro | Excel Programming | |||
problem breaking macro into 2 subroutines | Excel Programming | |||
breaking during a macro run | Excel Discussion (Misc queries) |