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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ms office troubleshooting for users 8 36
COPY from excel to notepad 3 37
Filling Blank Cells 14 19
Avoid Multiple Instances of Named Ranges in Excel 3 16
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now