This is DRIVING ME MAD.....
I have two workbooks. Workbook 1 is the final document which holds all the
information about our IT equipement from different areas. Workbook 2 shows
the PC number and the printers that it is assigned to.
What i am needed to do is show the printers that are shown in Workbook 2 in
Workbook 1 - but its not a simple concatenate.
In Workbook 2. Column A shows PC numbers, Column B shows the printers. If
more than one printer is assigned to a PC than the PC number will show
multiple times in Column A with the different printers in Column B. I am
needing to do a formula in Workbook 1 that says if the PC number in Workbook
1 matches any of the PC numbers in Workbook 2 then collect the printer data
in column B and concatenate to show in one cell.
Any ideas??????????