Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() hi there i need help badly!! i am writing a macro in my macro there are times in which i need to use a consolidation but i cant seem to get it to work relitivly . what i have is two rows a row of dates and a row of amounts of values(hours ) i need code that will check through my dates and if it finds any repeating dates it will add the the hours leaving me with one of each date and the hours totalled i hope that made sense any help would be great -- nance666 ------------------------------------------------------------------------ nance666's Profile: http://www.excelforum.com/member.php...o&userid=26654 View this thread: http://www.excelforum.com/showthread...hreadid=399387 |
#2
![]() |
|||
|
|||
![]()
If your data is sorted, you could select your range and do Data|Subtotals.
Then you could use the outlining symbols to the left to show/hide the details. (or you may want to look at data|pivottable. They're made for this kind of thing.) nance666 wrote: hi there i need help badly!! i am writing a macro in my macro there are times in which i need to use a consolidation but i cant seem to get it to work relitivly . what i have is two rows a row of dates and a row of amounts of values(hours ) i need code that will check through my dates and if it finds any repeating dates it will add the the hours leaving me with one of each date and the hours totalled i hope that made sense any help would be great -- nance666 ------------------------------------------------------------------------ nance666's Profile: http://www.excelforum.com/member.php...o&userid=26654 View this thread: http://www.excelforum.com/showthread...hreadid=399387 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
New Data Consolidation Question | Excel Worksheet Functions | |||
Pivot Table: Mult Consolidation Ranges | Excel Discussion (Misc queries) | |||
Consolidation | Excel Discussion (Misc queries) | |||
Multiple Consolidation Ranges | Excel Discussion (Misc queries) | |||
How to integrate cells from different .xls into one consolidation | Excel Discussion (Misc queries) |