LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CHRIS K
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining sheets on one em8195 Excel Worksheet Functions 5 November 3rd 05 11:40 PM
Links between sheets Jack Excel Discussion (Misc queries) 2 June 21st 05 11:17 PM
Combining different sheets with automatic add in? TonyKA Excel Discussion (Misc queries) 0 May 13th 05 01:17 PM
how do i find which sheets contain links? dov Excel Worksheet Functions 2 April 12th 05 12:55 AM
combining data from multiple sheets Allen Way via OfficeKB.com Excel Worksheet Functions 1 April 5th 05 06:02 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"