Transferring data from one sheet to another

[Guest]

Hi there,
I hope someone can help me. I am trying to make a spreadsheet where on the
first page I can have all my data, and if I input "true" in one field the
information that follows can be automatically transferred to another page.
For example: If I am doing a expenses spreadsheet, and if I code a column
(joint expenses) "TRUE" it will carry forward to a section I have specified
for joint expenses. That way one sheet can be designated for all expenses,
and one sheet can be coded as joint expenses. I thought of the formula:
=if(sheet1!c4=true, sheet1!d4:sheet1!g4=sheet4!c:sheet4!g4), but it doesnt
work.

 

[Guest]

have you tried the on change event:

Private Sub Worksheet_Change(ByVal Target As Range)
if target="true" then
bla bla bla bla bla bla bla bla
more blalbalbalba
end sub

 

[Guest]

I am not sure how to do that. Can you explain. Thanks