Need a program that will let me do this...

[211]

double click on a value from a long list of frequently used values (call this column 1). When I double click from this list in column 1 it automatically adds it to a second column (column 2) and puts the selection first in a list. When I select another value from column 1 it adds it to column 2 below the first selection made previously, and so on...

Here's what I'm having to do now using Excel.
I have a list of frequently used values, or "events" as we call them. This is a common list who's naming convention never changes. Part of what I do at work is collect Data specific to each one of these events. Problem is, we NEVER collect the data in the same order twice, and may or may not run all the events that are in the list. So when I get back to my desk I have to recreate this list in the order in which I ran the events.

At this point it's a matter of copying from "Column 1" the corresponding event from the list and pasting it to "Column 2" as #1. Then go back to the column 1 list, copy the next run we made and paste it to column 2 as #2. This repeats untill I have a list of events in the order in which they were ran in (some lists grow to the 60's, that's a lot of copying and pasting).

So again, it'd be really nice if I could find a program that would let me build a table or list of these commonly used events, double click an entry in the list, and have it build a second list in the order in which I make the selections. Excel is the closest I've been able to come, but there always seems to be some amount of copying and pasting going on.
Or perhaps I'm not using Excel properly?

I've tried playing with InfoPath this week but it's not quite what I'm looking for. Access is a little deep and seems like overkill for what I'm trying to do. But then again I'm not seasoned with Access at all so maybe it IS the right program but I'm just intimidated by it's complexity.

As far as I've gotten it seems Macros are the only way to go. Problem is, at work I'm unable to toy with macros on an effective level because IT has permissions locked down like a mutha.

Plus I've never really done more than just a two or three keystroke macro anyway so I'm a little scared...

With a little advice, I'd love to create something here at home to bring to work, Id be a HERO!!!

Thanks in advance.

 

[XLGibbs]

Most of what you describe can be coded into excel, but you should post sample data (lets call it "sample data") so that someone can see exactly what it is you are up against. Use the HTML maker available on this site to post a smaller version of your event list to get started.

 

[211]

Okay, so here's a sample of what I'm looking at. Again, this is a very dummbed-down sample for simplicity's sake.

What I'd like to do Is be able to double click an "event name" and have it put it on the left, right next to it's appropriate "Run #", taking with it the "file name".

What I'm havning to do now is copy both the file name and event name from two columns and paste it over to the list on the left. I.E. highlight G13:H13, Copy, Select B3, Paste.

Hope this is making sense to everyone. Thanks for the help.

Book1
	A	B	C	D	E	F	G	H
1							Standard filename naming convention
2	Run #	FileName	Event Name				FileName	Event Name
3	1						abc85a	BrokenConcrete @ 8.5
4	2						abc85b	BrokenConcrete @ 8.5
5	3						abc10a	Broken Concrete @ 10
6	4						abc10b	Broken Concrete @ 10
7	5						alb12a	Lateral Bumps @12
8	6						alb12b	Lateral Bumps @12
9	7						asb12a	Speed Bumps @ 12
10	8						asb12b	Speed Bumps @ 12
11	9						asb15a	Speed Bumps @ 15
12	10						asb15b	Speed Bumps @ 15
13	11						ahm05a	High Mogules @ 5
14	12						ahm05b	High Mogules @ 5
15	13						ach05a	Chuckholes @ 5
16	14						ach05b	Chuckholes @ 5
17	15						ahc05a	HardCurves @ 5
18	16						ahc05b	HardCurves @ 5
19	17						adb20a	Diagonal Bumps @ 20
20	18						adb20b	Diagonal Bumps @ 20
21	19						a2f8a	Two FigureEights
22	20						a2f8b	Two FigureEights
23	21						acsta	Curb Strikes
24	22						acstb	Curb Strikes
25	23						atr9a	9" Trenches
26	24						atr9b	9" Trenches
27	25						atr12a	12" Trenches
28	26						atr12b	12" Trenches
Sheet1

 

[XLGibbs]

How is the appropriate run # determined?

This can be done, but the specifics are kind of necessary....it may be able to be done with formulas or VB

 

[211]

Where I work we do vehicle testing on a proving-grounds (so-to-speak). So the Events we run are part of a circuit that does not necissarily follow how it's listed in our spreadsheet. We may or may not run ALL the events in the list (and never in the same order). But it's crucial, when we look at the data we've collected from the track, that we know "run #1" is lateral bumps, run #2 is BodyTwist and so forth.

Not sure if I answered you question or not...

 

[jindon]

Hi
paste the code onto sheet module

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Target
    If Intersect(Target, Range("g3", Cells(Rows.Count, "h"))) Is Nothing Then Exit Sub
    If .Column = 8 Then x = -1
    Range("b" & Rows.Count).End(xlUp).Offset(1).Resize(, 2).Value = _
    .Offset(, x).Resize(, 2).Value
End With
End Sub

 

[211]

paste the code onto sheet module

Whoa Tiger!!! Sorry for being such a noob but I have no idea what you just said. I know I can figure it out, I just need baby steps right now.

"Sheet Module" is that part of a macro script or something?
Excel's Help Search results came up with a blank stare when I entered Sheet Module in the "search for" box.

Sorry, I guess I forgot to tell everyone, I'm not nearly at the level most of you are at.

 

[XLGibbs]

Right click the tab on the worksheet and choose view code.

The window that pops up is the Visual Basic Editor.

You would just past the code provided into the window on the right.

you can then go back to your sheet and double click in column G for what you want moved over. The will move over in order of how you double click ....

try Jindons code and shout back.

 

[211]

HA HA THAT FREAKIN' RULES!!!

Whoa, my mind is blown!

That seems to do it. Now do I save the VB editor and close it or will it automatically apply itself when I exit the editor.

So, will this code only work for this specific worksheet? The one at work is quite a bit longer. I'd like to just use this code and apply it to the worksheets we are currently using.

Nonetheless this is EXACTLY what I'm looking for!!!

jindon you rule!

 

[XLGibbs]

right now it will only work in that worksheet, but you can paste into any sheet the same way.

When you save the excel file the macro will save with it.