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
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
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…

707 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