How to make excel perform data recognition, transfer and update?

**Beginner Level** · 04-17-2012, 02:43 AM

Hello everyone,

As told by the title, I hope to make excel function in this way.
The question will be too complicated to explain. So I attached a document file with picture.
I hope my question can be solved. Thank you very much.

**Mallycat** · 04-17-2012, 05:27 AM

Ok, thanks for going to the effort to explain what you want. I have some questions though.

1. Do you want this to happen once, and only once, or do you want the sheets to update automatically when additional data is added to the main sheet?

2. What are you going to do with the data on the other sheets (ie the sheets that are auto updated)? This is important because depending on what you want to do, may have a different result

3. Do you really need all those other sheets? Would it work if you could just filter the data on your main sheet depending on the codes (ie B1, C2 etc)