I have the following formula in cells G4 & H4

=IF((F4-E4)=15,"Issue PP yes or no.","") In Cell G4

=IF(G4="yes",F4-E4,IF(G4="no",F4-E4, IF(F4-E4<=15, F4-E4,IF(F4-E4=15,"Issue
Prompt Payment Letter.","")))) In Cell H4

I would like to transfer part or all of the information in row 4 to another
sheet if I type in yes to cell G4.

If I type no then do nothing.

Can anyone help.

YOu need to pace a formual in the other sheet that looks at the value in the
Master sheet cell G4 and based on that grab what is needed. Something like
this

if('Sheet1'!G4 = "Yes" , "Do This", "Do Nothing")

HTH...

"Monty" wrote:

I have the following formula in cells G4 & H4

=IF((F4-E4)=15,"Issue PP yes or no.","") In Cell G4

=IF(G4="yes",F4-E4,IF(G4="no",F4-E4, IF(F4-E4<=15, F4-E4,IF(F4-E4=15,"Issue
Prompt Payment Letter.","")))) In Cell H4

I would like to transfer part or all of the information in row 4 to another
sheet if I type in yes to cell G4.

If I type no then do nothing.

Can anyone help.

thanks can you give me another hint to start me of please.

thanks again

"Jim Thomlinson" wrote:

YOu need to pace a formual in the other sheet that looks at the value in the
Master sheet cell G4 and based on that grab what is needed. Something like
this

if('Sheet1'!G4 = "Yes" , "Do This", "Do Nothing")

HTH...

"Monty" wrote:

I have the following formula in cells G4 & H4

=IF((F4-E4)=15,"Issue PP yes or no.","") In Cell G4

=IF(G4="yes",F4-E4,IF(G4="no",F4-E4, IF(F4-E4<=15, F4-E4,IF(F4-E4=15,"Issue
Prompt Payment Letter.","")))) In Cell H4

I would like to transfer part or all of the information in row 4 to another
sheet if I type in yes to cell G4.

If I type no then do nothing.

Can anyone help.