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
197 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

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

770 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