Selected Data Pulled Into a New Sheet in Consecutive Rows

[1FJef]

Working in two sheets A & B.

SheetA contains ten columns. The important ones for now are "UniqueID" and "Year." "UniqueID" is obviously the column with entirely unique data; "Year" column contains multiple duplicate years.

SheetB needs to contain all the data as SheetA but only for the specific year I choose (ex 1970). It also needs to display the data in consecutive rows.

I could do a simple "if/then", requesting each row that did not contain the year 1970 to say "no", but that would defeat the attempt to have all the 1970 data displayed in consecutive rows. I could do this and then sort SheetB, but SheetA is constantly updated and I’d really like a formula that puts the data into consecutive rows for me, so I don’t have to keep sorting.

Ideas? Thanks tons!

 

[Gino_Vernisci]

Jef

Have you considered using a filter? Instead of creating and maintaining two sheets, one of which is just a copy of specific contents from the other try going to the "Data" ribbon, highlighting the row containing your column headers and click "Filter".

Once you apply the filter you will see all of your column headers become drop down boxes. By opening the drop down box in your "Year" column you can choose which years you want to show and which ones you want to hide. You can even sort the filtered list by any criterion you like.

At any time you can also change the filter to show all dates again.

Will this work?
Gino