Hi
I have a workbook with several worksheets. The first 3 columns of each worksheet contain the same information and serve as a unique identifier for each line of information.
I am trying to combine all of the information in each worksheet into a consolidated worksheet based on matching the information contained in the first 3 columns of each work sheet.
Is there a way that i can do this with pivot table or some code. I have attached a copy of the file that i am working with.
Any help would be appreciated.
Regards
Bookmarks