LinkBack URL
About LinkBacks
How to filter the data according to multiple items selected.
You may refer to sheet[result] for expected output.
Thank you
How to filter the data according to multiple items selected.
You may refer to sheet[result] for expected output.
Thank you
Not able to understand your requirement, please mention properly.
Regards,
Suhas
I have a yearly activities schedule contain with multiple country and company.
The data have fill into column D to Q by follow month, country and company.
Example:
1. If I select Thailand and Company A, the schedule will show Yearly activates for Company A in Thailand.
2. If I select Month Feb, Thailand and Company A, the schedule will show February activities for Company A in Thailand.
3. If I select January only, the schedule will show all country and company information for January only.
The data show in schedule table is depend on which type of requirement selected.
Thanks
I believe this will do what you require. Please let us know.
Last edited by FlameRetired; 11-27-2014 at 02:00 AM.
Sorry, that is not what I required. Perhaps, my explanation is too weak.Originally Posted by FlameRetired
You may refer to sheet [result] at file attached. That is my requirement. The data show in schedule table is depend on which type of requirement selected.
I might be more confused than I thought.
If you select/highlight B5:B6 in my uploaded file (Post #4) and delete the contents of those drop-down cells and choose say MarchExample:
1. If I select Thailand and Company A, the schedule will show Yearly activates for Company A in Thailand.
2. If I select Month Feb, Thailand and Company A, the schedule will show February activities for Company A in Thailand.
3. If I select January only, the schedule will show all country and company information for January only.
from the month drop-down you will see output for March only for both Thailand and Singapore. As I interpreted your 3.) requirement
that unique output is the result. As you select items B4, B5 and/or B6 and choose/delete according to your list in the above
quote the output does what I interpret your list to require. Is that much correct?
Now what the specific outputs are that you reveal in Post #5 are a very great mystery to me. I cannot perceive relationships as per
your listed requirements and I cannot perceive patterns/relationships of the specific outcomes to other items on your sheet.
Perhaps the grid below of your desired output (Post #5) will help clarify my question(s):
Row\Col Year 2014 Month January Country Singapore Personnel Area Company1 Activities 1 Activities 2 Activities 3 Activities 4 Activities 5 Activities 6 Activities 7
I can see the relationships of months and year in the output however I do not see how you arrived at the day designations
or Singapore / Thailand designations. Singapore is chosen in B5, but output is for both.
Can you clarify further?
Last edited by FlameRetired; 11-28-2014 at 02:05 PM.
Amend the file to make my question more clear. Please refer to file attached,I might be more confused than I thought.
Can you clarify further?
Now, macros (name: [Data]) was created to advancefilter and copy data from sheet Database to sheet Summary.
Problem still face is: If Month (B4) is blank, the data couldn't copy over however advancefilter (macros name:[Filter]) is not issue.
Thanks
I don't upload macro files.Sorry.
Thanks for your replied. I will post at VBA forum there.I don't upload macro files.
No, please do not post a duplicate thread to this, I will move it to the VBA forum if you want?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks