Command Button used to copy columns from one sheet to another while transposing

[newtomacros1]

Hi All,

Starting to learn how to write macros and would love some help with this problem I am attempting to figure out.

My data looks like:

EmployeeName EmployeeID Department Location TaxYear QualifiedPercent
Donald Duck 10001 Accounting Denver 2008 .5
Jim Thome 10002 Finance Atlanta 2009 .2
Donald Duck 10001 Accounting Denver 2010 .7
JJ Watt 10003 HR Houston 2008 .2

I would like the user to be able to click a command button and have this data copied over to a new sheet but in this new format (Tax Year becomes column with new value the qualifying percent field):

EmployeeName EmployeeID Department Location 2008 2009 2010
Donald Duck 10001 Accounting Denver .5 0 .7
Jim Thome 10002 Finance Atlanta 0 .2 0
JJ Watt 10003 HR Houston .2 0 0

Thanks in advance!

[than_gold]

Could you please provide this data in excel file not like messages.