LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Using a cell's value to copy another cells info to another workshe

I am not sure that this is possible, but I will ask.

I am running a bowling tournament that has many teams (2 people/team) over
several shifts. These teams will be placed in two divisions. I want to list
each shift's teams on a seperate worksheet while combining these into a
"Tourney Standings" sheet for each division.

Is there a way to use the value of one cell to copy the data in other cells
to another sheet? For example, if the team is in division one then copy
their names and total to the "Division 1 Standings sheet". If not, then copy
their names and total to the "Division 2 Standings sheet".
 
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
How to copy info into blank cells within a column (going up the co Marty Excel Discussion (Misc queries) 1 January 19th 09 12:18 AM
Copy info into empty cells below info, until finds cell with new d Fat Jack Utah Excel Discussion (Misc queries) 3 November 16th 08 08:34 PM
Updating linked cells within a workbook, from worksheet to workshe notloiseweiss Excel Discussion (Misc queries) 7 February 18th 08 01:15 AM
comparing a column of cell and then copy info to other cells Kelly******** Excel Discussion (Misc queries) 0 March 21st 06 09:51 AM
Copy worksheet with Pivot Table and break link to original workshe setter-lover Excel Worksheet Functions 0 November 18th 04 09:29 PM


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

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

About Us

"It's about Microsoft Excel"