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.
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.