Finding and filtering on a group of cells
I have a master excel file that has 3 columns with data lets call them A, B, and C. Then I have smaller excel files that have column A only which in both cases "A" is an unique identifier. Is there a way for me to insert the smaller file "A" data into the master excel file column D and be able to find and filter on only those values so that they match the master file column A
Thanks
|