• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Project information, Macro, Pivot or VB.

A

arcplus

New Member
This is a continuation of my last post. First off, how do I reply to people that try to help, as I would like to thank them.

My issue is located here.

https://www.dropbox.com/s/aatymk2gvhzahc9/trial.xlsx

I must create a front page that when I choose type of product, it will send me to classification of product then to supplier. The report has to show which employee has what skill level, eith needs training (red), trained (green) or expert (purple). I do not know what to create this in, do I use Macro`s, pivot table or VB.
 
In answer to your first question, simply use the reply box at the bottom of the thread you have created.

http://chandoo.org/forums/topic/visual-basic-issues


For the latter, the solution will depend on your data setup. I'm afraid I can't access uploaded workbooks from my location, but hopefully one of our colleagues will be able to give assistance.
 
Hi, arcplus!


Tried selecting row 2 and setting auto filter on? (Data tab, Sort and Filter group, Filter icon).


Regards!
 
Hi, arcplus!


Give a look at this file:

https://dl.dropbox.com/u/60558749/Project%20information%2C%20Macro%2C%20Pivot%20or%20VB-%20trial%20%28for%20arcplus%20at%20chandoo.org%29.xlsx


It's the same you uploaded but with autofilters set for row 2. Then, even you don't have any user form with dropdown list boxes from where to select the desired values, you can to it from your actual workbook file using the filtering options.


Just advise if any issue or if it's not suitable for you (I know that an user form is much pretty, but it requires a little more work).


Regards!
 
Thanks for helping me SirJB7, it shows what we can do when we work together. Hopefully i will help someone in the future. If possible how can I get the user form on another page. Thanks again
 
Hi, arcplus!

Glad to help you. I'll try to upload something here, let me try to find out a little of time.

BTW, thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards/Salut!
 
You must log in or register to reply here.
Back
Top