Hello,
I have two Pivot Data Filters: one for Part Number and one for Description. (Item: 111, Description: Part B | Item: 222, Description: Part A)
Each of them is sorted alphabetically so, for each line, the description doesn't match the item. Here is an example (imagine these are sets of Pivot Data Filters).
Item Description
111 Part A
222 Part B
Do you have any suggestion on how to relate the two fields in order that Description follows the right Part Number?
Item Description
111 Part B
222 Part A
I know I could solve the problem with a concatenated field but the file is very complex with a lot of macro running on. Moving columns at the moment it is not that easy.
Thanks for the help!
Bookmarks