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.

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

"atina" wrote:

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.

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

"filo666" wrote:

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

"atina" wrote:

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.