Hello gang, new member here seeking for your wisdom! 
I have been given an exam task in my university and I will try to explain it to you so don't flame for my non-fluent English
.
What I need to do is to think of an real activity that would be automated using Excel.
I.e. we have a shop which is specified into selling office stuff like pencils, pens etc. and what we need to do is to make a drop-down list with all those items. Then it is made in an example with quantity. A spin-button was used to select quantity. After that an item is listed in shopping cart as well as its quantity and overall price by the formula (quantity * price). After you have all items you need in your shopping cart, you can move forward and receive your bill. That's the basic idea given in an example which is not very informative so I'll try to explain what I did and what I am struggling with since my excel document is not in English there will be no benefit if I would upload it.
My idea is very simple - a laptop shop. I've made a drop-box list with manufacturers (1), processors (2), video cards (3), screen size in inches (4), RAM (5), HDD size (6), and price (7). Under the company name I've made a filter criteria (8). Kinda simple but it took me like 6 hours in total
. Now what I need to do next is to filter my laptop table and paste it from sheet2 to sheet1 using those filters. I.e. I have chosen manufacturer ASUS with a processor CELERON, so from original table with all ASUS laptops a specific command (or macro) should do the filter according to filter criteria (8) and to paste it to my sheet1.
I hope you got the basic idea, if not, I'll try to explain it in more details. Also, attaching a picture with stuff that might help understanding my task.
http://i.imgur.com/Ls2vtFR.jpg
Cheers!
I have been given an exam task in my university and I will try to explain it to you so don't flame for my non-fluent English
What I need to do is to think of an real activity that would be automated using Excel.
I.e. we have a shop which is specified into selling office stuff like pencils, pens etc. and what we need to do is to make a drop-down list with all those items. Then it is made in an example with quantity. A spin-button was used to select quantity. After that an item is listed in shopping cart as well as its quantity and overall price by the formula (quantity * price). After you have all items you need in your shopping cart, you can move forward and receive your bill. That's the basic idea given in an example which is not very informative so I'll try to explain what I did and what I am struggling with since my excel document is not in English there will be no benefit if I would upload it.
My idea is very simple - a laptop shop. I've made a drop-box list with manufacturers (1), processors (2), video cards (3), screen size in inches (4), RAM (5), HDD size (6), and price (7). Under the company name I've made a filter criteria (8). Kinda simple but it took me like 6 hours in total
I hope you got the basic idea, if not, I'll try to explain it in more details. Also, attaching a picture with stuff that might help understanding my task.
http://i.imgur.com/Ls2vtFR.jpg
Cheers!