Hey guys,
Any idea how I can solve this issue? Attached is an example file of what I'm trying to accomplish..
The tab labeled "TestEx." has all the raw information. The "DesiredNeed" tab is what I would like it to look like after running a macro.
Example: I want to consolidate all line items that have the same "ID" into one line item that also has the sum of the "Cost" column.
Your help is greatly appreciated!
Bookmarks