alainfranco
New Member
- Joined
- Mar 7, 2012
- Messages
- 38
Hello,
Could a kind soul please help me figure this one out?
I have a list of unique values, (which I can refer to with either a direct reference like C5:C50, or by Named Range).
In this list, I have all the inputs that I need to use as criteria in a form of another worksheet.
Currently, I have to manually copy and paste the values from this list into the cell of another tab, in order for the other tab to do its thing, display the results, and I copy and paste said result in yet another tab. Unfortunately, I have over 300 entries in the list, and I must do thing every second day.
My question is the following: Could anyone please suggest a way for me to automate this? I dream of the day where I can simply click a single button and that the described actions are executed
Any pointers or help would be TREMENDEOUS help for me. Any advice will be appreciated.
Many thanks for your input!
Alan
Could a kind soul please help me figure this one out?
I have a list of unique values, (which I can refer to with either a direct reference like C5:C50, or by Named Range).
In this list, I have all the inputs that I need to use as criteria in a form of another worksheet.
Currently, I have to manually copy and paste the values from this list into the cell of another tab, in order for the other tab to do its thing, display the results, and I copy and paste said result in yet another tab. Unfortunately, I have over 300 entries in the list, and I must do thing every second day.
My question is the following: Could anyone please suggest a way for me to automate this? I dream of the day where I can simply click a single button and that the described actions are executed
Any pointers or help would be TREMENDEOUS help for me. Any advice will be appreciated.
Many thanks for your input!
Alan