If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lists
I have a worksheet that records a name and 18 scores for many golfers. I want
to create a list with names, that when you select a name it will copy and paste the name and all 18 scores in a line. Can this be done? Any help greatly appreciated. Thanks John |
#2
|
|||
|
|||
Lists
What is the layout of your data? Show us or send your workbook to my address below. You can have a drop down keyed to a macro to do this -- Don Guillett Microsoft MVP Excel SalesAid Software "JOHN" wrote in message ... I have a worksheet that records a name and 18 scores for many golfers. I want to create a list with names, that when you select a name it will copy and paste the name and all 18 scores in a line. Can this be done? Any help greatly appreciated. Thanks John |
#3
|
|||
|
|||
Lists
"Don Guillett" wrote: What is the layout of your data? Show us or send your workbook to my address below. You can have a drop down keyed to a macro to do this -- Don Guillett Microsoft MVP Excel SalesAid Software "JOHN" wrote in message ... I have a worksheet that records a name and 18 scores for many golfers. I want to create a list with names, that when you select a name it will copy and paste the name and all 18 scores in a line. Can this be done? Any help greatly appreciated. Thanks John The names and scores are in columns A:V, I want to paste them into CJE, I am picking two names out and matching the names and scores in two man teams in the CJE column, does this help? John |
#5
|
|||
|
|||
Lists
"Don Guillett" wrote: Easier to send your workbook to my address below along with a snippet of this message on an inserted sheet and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "JOHN" wrote in message ... "Don Guillett" wrote: What is the layout of your data? Show us or send your workbook to my address below. You can have a drop down keyed to a macro to do this -- Don Guillett Microsoft MVP Excel SalesAid Software "JOHN" wrote in message ... I have a worksheet that records a name and 18 scores for many golfers. I want to create a list with names, that when you select a name it will copy and paste the name and all 18 scores in a line. Can this be done? Any help greatly appreciated. Thanks John The names and scores are in columns A:V, I want to paste them into CJE, I am picking two names out and matching the names and scores in two man teams in the CJE column, does this help? John If I create a macro for each name to copy the name and scores, can I make a drop down list of the macros showing the names and then select the name and paste it? If so how do I make a drop-down list of the marcos? |
#6
|
|||
|
|||
Lists
I sent this to OP
Private Sub Worksheet_Change(ByVal Target As Range)'sheet module Application.EnableEvents = False Call FINDNAMES Application.EnableEvents = True End Sub Sub FINDNAMES()'in regular module Dim MR On Error Resume Next With Sheets("SHEET1") MR = .Columns("A").Find(What:=ActiveCell, After:=.Range("A1"), _ LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Row 'MsgBox MR ..Range(.Cells(MR, "b"), .Cells(MR, "v")).Copy Cells(ActiveCell.Row, "ck") End With End Sub Sub FIXIT() Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "JOHN" wrote in message ... "Don Guillett" wrote: Easier to send your workbook to my address below along with a snippet of this message on an inserted sheet and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "JOHN" wrote in message ... "Don Guillett" wrote: What is the layout of your data? Show us or send your workbook to my address below. You can have a drop down keyed to a macro to do this -- Don Guillett Microsoft MVP Excel SalesAid Software "JOHN" wrote in message ... I have a worksheet that records a name and 18 scores for many golfers. I want to create a list with names, that when you select a name it will copy and paste the name and all 18 scores in a line. Can this be done? Any help greatly appreciated. Thanks John The names and scores are in columns A:V, I want to paste them into CJE, I am picking two names out and matching the names and scores in two man teams in the CJE column, does this help? John If I create a macro for each name to copy the name and scores, can I make a drop down list of the macros showing the names and then select the name and paste it? If so how do I make a drop-down list of the marcos? |
Thread Tools | |
Display Modes | |
|
|