Hello all. new here and this is my first post. I used to use Excel extensively, but jobs changed and such and now i am all rusted up. Now i am stumped while sorting through a list of serial numbers.

Below, I have the [IMG ] image [ /IMG] (without the spaces) but still the image does not show? O well.


I am working with the 2010 version. I used to do something similar in older versions but that was a while ago and i forget. i tried searching and cannot get my bearings.

here is what i am trying to accomplish. I want the "Main" sheet cells automatically populated from the "T1" and the "T2" sheets in the same file.

\1

I am looking for the Batch code to automatically populate from the below sheets to the Main one WITHOUT DUPLICATE values for the year range appearing.
As an example, I want to know what "Batch Codes" were present for t1 in the year 1950.

I also want new entries on the tab T1 and t2 to automatically reflect on the Main page in case there is a new/unique entry.

\1

\1

my sincere thanks for your help - FD