Populating Data in New TABs?

Sueade · #1 06-02-2015, 01:13 AM

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

gebobs · #2 06-02-2015, 08:32 AM

Why two tabs? How about just filtering the data?

Sueade · #3 06-02-2015, 09:12 PM

Yeah i thought of that but the boss wants 2 tabs

So yeah would like to pick up data if it is triggered by a word and dump it into tab 2? Possible?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge Field Not Populating	JennEx	Mail Merge	3	05-10-2015 09:30 PM
How to share cell data between tabs of workbook?	littlekeith	Excel	1	03-23-2015 06:21 AM
Tables not populating properly from code	DepricatedZero	Word VBA	1	06-04-2013 06:22 AM
Need help populating dropdown box	antztaylor	Word	3	11-06-2012 05:46 PM
"Auto-populating" data-worksheet to worksheet.	meggenm	Excel	4	02-04-2012 02:04 AM