auto transfering info between work sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
How about,
=IF('Another sheet'!A1="word",'Another sheet'!B1,"")

HTH
Kostis Vezerides
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Auto Reference Worksheet Tab ID's in Formulas? 9
Calculate percent on numbers in different sheets 3
lookup and worksheet name and then do formula 2
Excel Count If Formula Question 1
Formula Based on Multiple Sheets 5
auto fill certain data from sheet1 to sheet 2 2
Spreadsheet summary automatically referrences totals of worksheets 2
Collating entries from multiple sheets 3

Back
Top