Greetings to all!
I am trying to put multiple codes in one cell under a column named notes. For example: Codes BR, GR, NPU, NB, LC, HC, LCU and a few more. Not all these codes will be used every time.
I need to filter each individual code from the cells at the end of the column and put it on a separate summary sheet.
For example: BR is in 10 different cells on 10 different rows in the column notes.
GR is in the same cells as BR in the column notes.
NB is in the same cells as BR and GR in the column notes.
So, we have three codes in the same cells on 10 different rows in the column notes.
Filtering:
BR summary: For each instance BR is filtered it should equal 1 and inserted onto a different sheet. Thus, in the BR summary box on a separate sheet BR equals 10.
For each instance GR is filtered it should equal 1 and inserted onto a different sheet. Thus, in the GR summary box on a separate sheet GR equals 10.
The same for the other codes. Each code will have a separate total box on a separate sheet.
I have included a scaled down visual example.xls file.
Any help would be much appreciated.
Thanks in Advance
Paul
Bookmarks