There's no function that would trigger on the basis of whether a box was
checked. You would have to write some custom VBA code for that.


--
Brevity is the soul of wit.


"Tilleyswife" wrote:

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????