Sorry but im confused on how this link is supposed to help me??

It doesnt specifically say which one i need?? How do i input the new
code? Do i just copy and paste it in place of the old macro??

I only have 6 feilds i need to copy over. I'll copy accross the code i
have in place now

Sub Macro9()
'
' Macro9 Macro
' Macro recorded 28/02/2006 by b2683
'

'
Sheets("Database").Select
Range("A1").Select
Selection.End(xlDown).Select
Sheets("Entry Form").Select
Range("C6,C8,C10,C12,C14,C16,C18").Select
Range("C18").Activate
Sheets("Database").Select
Range("A4").Select
Sheets("Entry Form").Select
Selection.Copy
Sheets("Database").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True
Sheets("Entry Form").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("C6").Select
End Sub


--
girth69
------------------------------------------------------------------------
girth69's Profile: http://www.excelforum.com/member.php...o&userid=23634
View this thread: http://www.excelforum.com/showthread...hreadid=517329