Copy data into a template based on criteria

[chandrsl]

Hi Everyone,

I'm a relative newbie with Excel macros, so please be gentle

Here's what we need to do:

We are compiling sheet 2 from another sheet of data (sheet 1) and I need to figure out how to put the data in the destination in a specific template format. For example:

source data (sheet 1):

Column A is the state
Column B is the name of the country




We have a column for each country in sheet 2

Can we use a formula/macro to automatically copy column A from sheet 1 and and insert the data accordingly in sheet 2 under each country

For example:

sheet 1
Column A Column B
Ohio USA
Virginia USA
Goa India
Karnataka India

would appear in the sheet 2 as

USA India
Ohio Goa
Virginia Karnataka

I have about 208 countries in total and 300000 jurisdictions (column A) (total number of rows in sheet 1) and need a macro to create sheet 2 as per my requirement.

I am totally new to macros and would help a code snippet.
Any help is greatly appreciated.

Input file (sheet 1)
Macor.xlsx

Thanks!

[apo]

Hi..

Try this..
Edit: I noticed the first version i posted was inserting the Country name in second row of each column.. fixed that in this edited code and attachment..

Add this code to a CommandButton on your "Source" sheet..

Please Login or Register  to view this content.

Add this code into a Module..

Please Login or Register  to view this content.