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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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…

861 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