Thread: Help with Excel Formulas

Hi,
Im creating a spreadsheet with many worksheets but all links back to one. My Question is, is there a formula that i can use to look at one cell on my main worksheet and if it has the word "Yes" in the cell it copys data from another worksheet and put it in the next cell.

Hi,

It's feasible with an event macro ...
Can you provide us with more details for a more precise answer ...

Carim

Originally Posted by Nightwatcher

Hi,
Im creating a spreadsheet with many worksheets but all links back to one. My Question is, is there a formula that i can use to look at one cell on my main worksheet and if it has the word "Yes" in the cell it copys data from another worksheet and put it in the next cell.

suppose cell A1 in main worksheet contain "Yes" and you want to return data from other worksheet in cell B1 then put in B1

=IF(A1="Yes",Sheet2!A1,"")
it will return data from sheet2 cell A1 if cell A1 of main has "Yes" otherwise it will remain blank.

hope this would help you.

Regards.

thanks for that it worked well.