Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

VB Help...I want to filter and copy exactly the spreadsheet to other based upon selected field or fields

Posted on 2014-09-03
5
Medium Priority
?
202 Views
Last Modified: 2014-09-28
I want to filter a spreadsheet based on selected field or fileds i.e. Last Name or Last Name and Order Type.  The select fileds would be Last Name, Order Status, PAS, or Order Type.

Once tab is created based upon criteria.  Then I would like be press a button to create subtotal of Number of Work Days for each individual (Unique Name)
0
Comment
Question by:cfhasan1
  • 4
5 Comments
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40302134
Restating in order to understand question better:
1) You want a macro that will create a copy of a filtered sheet, showing only the values that are filtered.
2) You want a second macro (with button to activate) that will show the number of work days (presumably from column L) for each person (defined by a unique combination of First and Last Names).

The second request is more difficult to understand:
A) If the data is filtered on a specific last name, then all data on the derivative sheet may very well be for a specific person if there is a unique last name.
B) If you do indeed want subtotals showing work days, you also would need the data sorted by unique name(s).  
C) Where do the subtotals go?

Regards,
-Glenn
0
 

Author Comment

by:cfhasan1
ID: 40302194
A. Yes, on occasion we multiple individuals with same last name. So, the first name would make it unique.
B. Correct. An individual may have multiple entries. Each row represents a new or unique request for workdays. Column L contains the number of workdays executed on that specific request. Thus, the need to get subtotal of the number of workdays used.
C.Subtotal can go under last entry on column L as Total Work Days Executed.
0
 

Author Comment

by:cfhasan1
ID: 40302229
The other factor is that with the filtering functionality that I'm seeking. I could filter based upon PAS. So, still the need to break down individual filtered sheets by Unique Identifier...
0
 

Accepted Solution

by:
cfhasan1 earned 0 total points
ID: 40306184
I've found a plausible solution from this site:  http://chandoo.org/wp/2012/11/27/extract-subset-of-data/ Nevertheless, Still need a solution as to why the copy and paste from filter does not work.  I also need the following:
A.  Populate the Last Name field from the Source tab (Last) with only unique names no duplicates
B. Copy and Paste source data to RawData tab
C. Why the copy and paste from filter does not work.  I still want to get data based upon one or all filters.
Master-125-OPS-CSS-Orders-Log.xlsm
0
 

Author Closing Comment

by:cfhasan1
ID: 40348392
No response and collaborate with so friends to finish project.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question