View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tilleyswife Tilleyswife is offline
external usenet poster
 
Posts: 1
Default Can't figure this out!!!

Hi! I am a novice Exel user. I am trying to create a list of items. I want
each line to have three boxes. If box a is checked then the information
entered on this line would be copyed from MAIN SHEET to SHEET A. If box B is
checked, then the information on that line would be copyed from MAIN SHEET to
SHEET B.
Example of what MAIN SHEET would look like:

Item Sheets
A B C
____________________________________________
Closet doors -flat panel X
Ext.Light - onsite X

So "closet Doors-Flat Panel" would automatically be copied to a line in
Sheet B because B is checked. If C were checked, then "closet Doors-Flat
Panel" would be copied to sheet C.

What function do I put in those boxes to allow this to happen????