COMBINING LINKS TO DIFFERENT SHEETS

C

CHRIS K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Lookup in multiple & separate cells 6
IF ARRAY with multiple conditions. 1
Want only rows with populated data 1
I need ONLY subtotals copied to a second sheet 4
using different sheets match string to specific work and enter that work in active 0
Is it possible to pick up formatting from range using index match? 4
update vlookup formula sheet reference for multiple sheets 5

Top