Index/Match Automatically update Data

Question

I am currently using a nesting Index/Match function to find and insert data from one sheet onto another main sheet (in the same document).  The problem I am having right now is trying to figue out how to automatically import data - for example if a new/relevant row appears in the data sheet, how can I configure it so that the new information appears automatically and in the same format as on the main sheet?  I know this is confusing but please help!

Answer 1

You will need to us a macro - why - because you said "in the same format".  Formulas don't pass formats.  To get a macro you are going to have to give us details regarding the sheet layout and what goes to each sheet.

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

Answer 2

If you need the format to go along the answer is a macro.  If you could format the target range before hand than a formula approach would work.

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

Answer 3

also is it possible to do it without a macro - I would love to be able to avoid macros as much as possible

Answer 4

Thanks, I thought that might be the case but I wasn't sure - on the Data Sheet I have a list of student names in the A column, and an assortment of test/assignment scores follows.  In the main sheet, I only want the student name and 2 specific test scores

• but when I add astudent name to the data sheet I want the main sheet to recognize that and update accordingly.  Is that possible with a macro?