Attached simple example of what I am trying to achieve.
Also attached the original method which got too complicated for my next step, hence trying to do in VBA.
Basically, looking to have the master sheet be populated with all variations of project and sub number found on any subsequence worksheet in columns a+b.
Then to sum the total values of all instances of that specific project/sub number.
thought about modifying the above code to search all worksheets???Please Login or Register to view this content.
but that only does the first bit populating the list...
how then do I return and sum the time values?
Any help would be very much appreciated.
Thank you.
Bookmarks