Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
automatic copying of cells ? | New Users to Excel | |||
Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
zero value when copying cells between worksheets | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |