Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or formula to copy data based on criteria
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or formula to copy data based on criteria
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 -- gearo ----------------------------------------------------------------------- gearoi's Profile: http://www.excelforum.com/member.php...fo&userid=2657 View this thread: http://www.excelforum.com/showthread.php?threadid=40151 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i copy any data which is based on formula | Excel Discussion (Misc queries) | |||
Copy data to another wb based on specific criteria | Excel Discussion (Misc queries) | |||
Macro Syntax to copy and paste dynamic data based on one column | Excel Programming | |||
Macro to copy cell data to word document based on an active row? | Excel Programming | |||
copy data from sheet1 based on criteria in sheet2 to sheet3 | Excel Programming |