Hi,

I have a spreadsheet that has heaps of data on one tab.

I would love to create another tab where i can take data from the first tab into this new one with out cutting and pasting it.

For example:
TAB 1 has heaps of information about different destintation to travel to. It also says if i've been to that location or not.

TAB 2 I would like it to populate its self with all the destinations i haven't travelled to in TAB 1 with out having to copy and paste them over.

Is there a way to do this?

TIA