LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can i copy any data which is based on formula Nitesh 9818662515 Excel Discussion (Misc queries) 2 January 4th 08 05:34 PM
Copy data to another wb based on specific criteria ksh Excel Discussion (Misc queries) 1 October 29th 07 01:30 PM
Macro Syntax to copy and paste dynamic data based on one column jbsand1001 Excel Programming 0 May 17th 05 02:49 PM
Macro to copy cell data to word document based on an active row? Brian Excel Programming 2 September 16th 04 01:55 PM
copy data from sheet1 based on criteria in sheet2 to sheet3 Fred Excel Programming 3 May 25th 04 01:46 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"