Macro or formula to copy data based on criteria

[MT]

Does anyone know how I might be able to do the following problem. I
have a workbook broken down with multiple sheets by player position
(QB, RB, WR, etc)

Ex - QB Page
ColA ColB ColC ColD-F ColG
FirstNm LastNm Team Various LTeam

ColG is a drop down list of teams to assign the player. When I make
this selection I would like to have ColA, ColB, and ColC copied to the
appropriate section of another sheet which would look like this

LTEAM (static)
ColA ColB ColC ColD ColE ColF
QB1 <firstName Last Name> <Team> RB1 <first,last> Team
QB2 RB2
QB3 RB3
RB4

The above sheet would be broken down by LTeam and the player selected
would be populated in the next available slot.

Can anyone help? Thanks

 

[gearoi]

You need to set up a macro that copies across the right code dependin
on what you choose.

Set up a variable for the choice -

dim choice as string


then maybe use a select....case clause (look it up) to choose whic
thing to do according to the choice. Each case refers to each choic
you make

Under each case record the appropriate copy and paste and then it'll d
it itself.

oh - and make the macro run when you change the choice. or on clic
event or something. Depends on which excel version you are using. Migh
just be right click, assign macro in 97 for example