COMBINING LINKS TO DIFFERENT SHEETS
 

I have sheet 1 with rooms (eg No 18) containing asbestos (4 items)
i have sheet 2 with rooms (eg No 18) containing NO asbestos (0 items)
How do I combine both sheets onto sheet3 to show room 18 has 5 items (4 +ve
and 1 -ve)?
I want room 18 in column A and then 4 blank cells underneath with
column B having the 5 items
--
CHRISK