Copy and pasting data automatically between worksheets

[confusedjo]

Hi
Im wondering what is the best and easiest way to copy data automatically from one worksheet to another, example:-
Event sheet
<TABLE style="WIDTH: 572pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=763><COLGROUP><COL style="WIDTH: 156pt; mso-width-source: userset; mso-width-alt: 6656" width=208><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1856" span=2 width=58><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1856" width=58><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1632" width=51><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760" width=55><TBODY><TR style="HEIGHT: 42pt; mso-height-source: userset" height=56><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 156pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; HEIGHT: 42pt; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl96 height=56 width=208>NAME</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl96 width=58>GRADE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl97 width=58>GRADE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 44pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl98 width=58>PAID</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 38pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 8pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl99 width=51>PAYMENT METHOD</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl96 width=55>SCORE 50</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: windowtext; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl100 width=55>SCORE 50</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl101 width=55>SCORE 50</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl102 width=55>SCORE 50</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: #f0f0f0; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl101 width=55>SCORE 50</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 41pt; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: #ccecff; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl102 width=55>SCORE 50</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl75 height=22>fred</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl76></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl76>l</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl80></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl92></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl89>25</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: windowtext; FONT-SIZE: 11pt; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl84>25</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl72></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl84></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl72></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl84></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=22>joshua</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl70>b</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl71></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 0.5pt solid" class=xl93></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl90></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=22>ben</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl70>a</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl71></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 0.5pt solid" class=xl93></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl90></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 16.5pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=22>henry</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #f0f0f0; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl70>c</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl71></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 0.5pt solid" class=xl93></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl90></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD></TR><TR style="HEIGHT: 17.25pt; mso-height-source: userset" height=23><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 17.25pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 height=23>ben</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl66>a</TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl67></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl71></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 0.5pt solid" class=xl93></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl90></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl73></TD><TD style="BORDER-BOTTOM: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl85></TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; HEIGHT: 18.75pt; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl77 height=25>sarah</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; FONT-FAMILY: 'Arial Narrow'; BACKGROUND: white; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #bfbfbf 0.5pt solid; FONT-WEIGHT: 400; BORDER-RIGHT: #bfbfbf 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl78>a</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl79></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #f0f0f0" class=xl81></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 0.5pt solid" class=xl94></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl91></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl86></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl74></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl86></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: #bfbfbf 0.5pt solid" class=xl74></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #bfbfbf; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: #bfbfbf; BORDER-RIGHT: windowtext 1pt solid" class=xl86></TD></TR></TBODY></TABLE>

I wish to have the name, grades and scores copied to another worksheet automactically so they can be sorted and ranked. Name col is col C and scores go to col O and then there is a Day Total.
Any Help would be greatly appriecated.

 

[Jaye7]

The easiet way is to record yourself doing the process, select all the data that you want to copy from one sheet to the other, copy it to the sheet and then delete the columns that you don't want and then you can place the macro code in the worksheet double click code event, so evey time you want to run the process then you just double click in the sheet and it will process the data.


Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

' paste your data here

End Sub

 

[confusedjo]

Ty Jaye
Is there a way to get the data to automatically transfer to the other sheet when entered on the first sheet? I am currently using =event! (sheet 1 is called event) to get the data required, but this has its limitations.

 

[Jaye7]

You could put the code in the worksheet selection change event but I wouldn't recommend it as it will paste every time you change cells which would be very annoying, best to be in double click event as you only have to double click and it will run the code.

You could put =Sheet1!A1 etc... in the function for each cell of Sheet2 so that they always equal what ever data is placed in sheet1.

i.e. Sheet2 cell A1 has the formula =Sheet1!A1
Sheet2 cell A2 has the formula =Sheet1!A2 and you just copy and paste down sheet2 and across sheet2 so that each cell has the formulas that you want.

 

[confusedjo]

Wonderful!!!

Thank you so much.