World sheet to feed through to region sheet

SwimmingNathan

New Member
Joined
Aug 21, 2013
Messages
34
Happy Friday!

I've got a large spreadsheet (4k rows) of contacts who have standard columns with addresses, emails etc. AND all have the country where the contact is located. Every single entry has this value.

I want to make three spreadsheets for global regions (Europe, North America, ROW) that pulls rows of contact information based on the country.

So if the country was USA or Canada, I would want the row to pull through to the North America spreadsheet.

I've tried to achieve this with a INDEX and MATCH formula unsuccessfully, I think I'm barking up the wrong tree.

Maybe some crazy variation of an IF statement?

I really don't know where to start with this.

Any help/ ideas are greatly appreciated, I hope what I'm trying to achieve is clear.

Cheers,

SwimmingNathan
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

SwimmingNathan

New Member
Joined
Aug 21, 2013
Messages
34
Forgot to add. Excel Home and Student 2013, Windows 8, I have searched the forum, but to be honest I'm not sure if I was using the right terms.
 

nuked

Well-known Member
Joined
Mar 20, 2013
Messages
883
You could create a pivot table on your country field and then group certain countries into regions. Double-clicking on the number under your North America group, for example, will give you a sheet with all the rows for that group.
 

SwimmingNathan

New Member
Joined
Aug 21, 2013
Messages
34
Think I'll have to try that, I realised that it wouldn't be possible to skip rows with any drag down formula (doh!)

Cheers dude!
 

Watch MrExcel Video

Forum statistics

Threads
1,102,360
Messages
5,486,387
Members
407,544
Latest member
mguevara

This Week's Hot Topics

Top