Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Copying Cells with Drop Down Lists

good Evening Fellow Excel Users

I have a spreadsheet below which i created one


Darts - League 2006-2007
Week 1 MATCH No 1

Team A V Team B

Darts

Res Tons Name Name Tons Res
1 1 A Smith v C Jones 1 0
2 B Smith D Jones 0


+ 5 more matches in the same excel format


All red texts are drop down boxes

Team A and Team B are linked to a list called Teams
and the players in red are the people that play for that team which are in a list on another worksheet within the spreadsheet file


the problem that i have is that i need to recreate the above 239 more times and when i copy and paste them the links described above dont copy with them
ie if i change Team A to Team C and i select another player it selects them form Team A and Not Team C

Would i have to manually change all the other 239 sheets once i have copied them it would take hours and hours



Can anybody help me


Cheers


steve
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default Copying Cells with Drop Down Lists

An untested suggestion: copy the sheet by holding CTRL and dragging the tab.
When you have a few, group and copy to make more than one copy at a time, or use a macro to repeat the copy as many times as needed.
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 20/08/2006 by Bernard V Liengme
'
For j = 1 To 10
Sheets("Sheet1").Copy Befo=Sheets(2)
Next j
End Sub


best wishes--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Debby Bunce" wrote in message ...
good Evening Fellow Excel Users

I have a spreadsheet below which i created one


Darts - League 2006-2007
Week 1 MATCH No 1

Team A V Team B

Darts

Res Tons Name Name Tons Res
1 1 A Smith v C Jones 1 0
2 B Smith D Jones 0


+ 5 more matches in the same excel format


All red texts are drop down boxes

Team A and Team B are linked to a list called Teams
and the players in red are the people that play for that team which are in a list on another worksheet within the spreadsheet file


the problem that i have is that i need to recreate the above 239 more times and when i copy and paste them the links described above dont copy with them
ie if i change Team A to Team C and i select another player it selects them form Team A and Not Team C

Would i have to manually change all the other 239 sheets once i have copied them it would take hours and hours



Can anybody help me


Cheers


steve
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Copying Cells with Drop Down Lists


"Bernard Liengthanks for the suggestion but i had sorted it out bout 15 mins after i had posted my original mail


thanks again


steve



" wrote in message ...
An untested suggestion: copy the sheet by holding CTRL and dragging the tab.
When you have a few, group and copy to make more than one copy at a time, or use a macro to repeat the copy as many times as needed.
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 20/08/2006 by Bernard V Liengme
'
For j = 1 To 10
Sheets("Sheet1").Copy Befo=Sheets(2)
Next j
End Sub


best wishes--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Debby Bunce" wrote in message ...
good Evening Fellow Excel Users

I have a spreadsheet below which i created one


Darts - League 2006-2007
Week 1 MATCH No 1

Team A V Team B

Darts

Res Tons Name Name Tons Res
1 1 A Smith v C Jones 1 0
2 B Smith D Jones 0


+ 5 more matches in the same excel format


All red texts are drop down boxes

Team A and Team B are linked to a list called Teams
and the players in red are the people that play for that team which are in a list on another worksheet within the spreadsheet file


the problem that i have is that i need to recreate the above 239 more times and when i copy and paste them the links described above dont copy with them
ie if i change Team A to Team C and i select another player it selects them form Team A and Not Team C

Would i have to manually change all the other 239 sheets once i have copied them it would take hours and hours



Can anybody help me


Cheers


steve
Reply
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
Copying a column of single cells into a column of merged cells [email protected] Excel Discussion (Misc queries) 1 August 16th 06 01:18 PM
automatic copying of cells ? KK New Users to Excel 1 March 16th 06 04:27 PM
Blank Rows from Merged Cells in Drop Down Menu Kati Excel Discussion (Misc queries) 1 February 20th 06 08:59 PM
zero value when copying cells between worksheets joe Excel Discussion (Misc queries) 1 August 9th 05 08:51 PM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM


All times are GMT +1. The time now is 05:46 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"