Copying Cells with Drop Down Lists

[Debby Bunce]

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

[Bernard Liengme]

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 Before:=Sheets(2)
Next j
End Sub


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

"Debby Bunce" <[email protected]> wrote in message news:[email protected]...
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

[Debby Bunce]

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


thanks again


steve



" <[email protected]> wrote in message news:[email protected]...
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 Before:=Sheets(2)
Next j
End Sub


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

"Debby Bunce" <[email protected]> wrote in message news:[email protected]...
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