auto transfering info between work sheets

D

dcjetx

I am creating a summary page for multi worksheets. Is ther a way to have a
cell mirror a row of info on the summary if a specific word appears in a
specific cell on the orginal worksheet?
 
V

vezerid

How about,
=IF('Another sheet'!A1="word",'Another sheet'!B1,"")

HTH
Kostis Vezerides
 
D

dcjetx

Thanks for the effort but I can not get it to work.

I am looking to have one word in lets say sheet2 trigger a copy of that
entire row of info and paste it on sheet 1. When updates are posted to the
sheet 2 detail then it will automatically update the info in sheet 1.
Suggestions?
 
Top