Linking Filters And Copying Results
May 27, 2008
what i have is a workbook with 4 worksheets. each is a list of tapes that i use for back ups.
each worksheet has a auto filter so that i can filter by the day i need to use the tape. i.e. when i select monday it displays mondays tapes only.
what i want to do is take the result from this and copy it into another sheet so when i select tuesday it copys onto a 5th sheet in a specific area.
i would also like it to change the day on all sheets filters from a single drop down. i cant put everything on one sheet as there are duplicate tapes and days.
View 10 Replies
ADVERTISEMENT
May 24, 2007
I am trying to find a way in which a used can enter text into a cell (effectively the search cell) and then that text is compared to text in 3 or so columns, if the text matchs any part of the cells in the those columns then the spreadsheet should filter out the rows that dont have a match and only leave rows that have a match.
Its like having a spreadsheet with a list of part an user can put in 55 or bolt in the cell at the top and the list would only then show all the rows that have 55 or bolt or whatever text in the table below?
View 9 Replies
View Related
Feb 19, 2009
I have a worksheet with an auto filter to display only non-blank rows. Each row is a ledger account, with a cost. The formula in each cell sums the total of its corresponding gl in another worksheet, but also takes into account the region I am asking it to search based upon another cell. So the cost in a specific can fluctuate based upon which region I am telling the rows to lookup. So it can be blank with one region and populated with another. When I change the cell that tells the row data to look up a new region, the auto-filter does not automatically update the list of non-blank cells based upon the new region being searched, but rather the old one. So what is happening is I am left with an incorrectly auto-filtered result.
Is there a way to get the auto filter list to automatically update for the refreshed list of rows?
View 9 Replies
View Related
Feb 18, 2014
Use filter for 2 columns of a CSV file, column A and Column B for certain words. Say I apply a text filter: contains "word1" or contains "word2" to Column A. Then I get the results. After that, I remove the filter to Column A then apply the same filter to Column B. The thing is, I don't get the results in Column B, instead, I get the cells in Column A wherein Column B is filtered PHOTOS BELOW:
The data that I get for this filter are:
And Word1 you
Word2 is blank
Apply filter to Column B, get the cells filtered in Column A:
The data that get for this filter are from Column A (which are cells filtered from Column B filter)
And Word1 you
Is the blah
Word is all
The results should in a single Column for both filter:
I have more than 100 files that needs to filtered this way, is there any way I can do this automatically?
Here is what the file looks like:
The results I hope would be possible:
Automatically without having to open all the files and have the results of all of it in 1 single Excel file?
----or----
If the above is not possible, open each file and automatically apply the filter into a column in just 1 click and without having to type the same filter for each column.
I found a code to combine all CSV files into 1 Excel file, but half of my files has more than 500k rows and the Excel's limit for rows is around 1million+.
View 9 Replies
View Related
Jul 2, 2008
I work in IT support for a company and mainly work on operating systems issues etc but not office suite issues...anyway, I have been asked if it is possible to link 2 speadsheets and compare the data to display a result...
....from what I have just briefly read, it is certainly possible to do this, but now I need to know how it can be done with our relevant information... as you can see in the following images.
We have a spreadsheet that pulls data out of a database to display all the people that have been issued with a certificate, and we also have a spreadsheet that is manualy entered on a daily basis for the received date of the application for the certificate.
So, in short, we have a received date and an entered date and we need to know the difference to ascertain our turnaround time. Obviously it will need to compare names for name and enter the received date and result next to each name, and if it cannot get a name match, then report an error advising which ones it could not find a match for etc...
Whew, what a long post (sorry), I hope that is clear enough....below are the different images of part of the sheets...
View 14 Replies
View Related
Apr 16, 2013
For example, I have an excel worksheet which has a main "master" list that has all of the cars that are sold along with the name of the salesperson who sold it all the way to the right (Column 6)
What i am trying to accomplish:
I would like excel to automatically take all of the rows which have the same salesperson name in column six and sort them into separate sheets, but i would also like these rows to automatically update if information is changed in them or if they are deleted on either the salespersons sheet or the master sheet.
View 2 Replies
View Related
Jun 7, 2006
I have a problem with the attached spreadsheet. I have certain letters (A,B,C etc.) that are shipped to various regions. I would like to have a count on top to count the total number of orders, but one that also counts the total number of unique orders. However, this unique count has to be dynamic and must be able to adjust accordingly to the filters (by default, if no other filters are applied, should be 15). For example, if I apply the "Ship To" filter to Canada, the total number should be 19, but the unique count should be 12. If I change the "Ship To" filter to US, the total number should be 9, and the unique count should be 7. I've tried to use the advanced filters but if I apply the unique entries filter, it is only a one time calculation. Also, the advanced filter gets rid of my other filters.
View 5 Replies
View Related
Apr 25, 2014
I have a file where I have few sheets (link to file below). Sheet zrzut is dropdown from other system - updated daily. Sheet Productivity is filled with data supporting to group data and add conditions (for example column "I" in "zrzut" sheet). Sheet "Vena" has data from "zrzut" based on condition in column "I". Sheet "VENA_PLAN" has the same data as "Vena" but only values - I need only values for other actions. The thing is my current code replaces old data with new, but what I would like to achieve is to have new data stored below old. For now code looks like
Code:
Sub PlanVENA()
Application.ScreenUpdating = False
Worksheets("VENA_PLAN").Range("A3:H300").Value =
[Code]....
View 4 Replies
View Related
Aug 27, 2009
I'm working on a quote template that has 600+ products with descriptions and prices that gets autofiltered down to one product. After it has been filtered down to that one product how do I link that to a new worksheet?
View 9 Replies
View Related
Feb 27, 2007
In my attached example you can see I have Sheet "Computer" & Sheet "RHN" both have a number of columns, but all I want is to compare Column A of "Computer" with Column A of "RHN" and copy all entires found in A "Computer" and not found in A "RHN" to a new sheet!
View 4 Replies
View Related
Jun 3, 2009
I have a work sheet with about 35,000 lines of data. Every day I have to sort the list by product category (I use auto filter to separate) and then copy the results into a new worksheet, there are about 300 product catagories. I'm new to macros but I'm wondering if there is a macro that can automate this process.
View 6 Replies
View Related
Jul 5, 2014
I want the following script to:
1) Find and define a range ("DateRng") based on cell values. This is controlled by the first block and the script does this job correctly.
2) Find cells
View 1 Replies
View Related
Dec 27, 2012
I have a simple reporting sheet where the data for orders place is in one sheet and on the other sheet is an imput box for 'date' and it filters through and presents a table of data and two graphs for the date chosen.
I give a daily report (contents of this sheet) but I also need to leave this sheet available for anyone to open and change to another date.
I want to copy the repor sheet into a new one and email but I want the graphs to remain, not go blank when anyone changes the original sheet.
Excel 2007 / Windows 7.
View 3 Replies
View Related
May 4, 2014
I began to ponder a way to copy down cells so that the copying of the formulas results in references as shifting horizontally instead of vertically. One particular reason that this occurred to me had to do with my attempting to use Excel to make more orderly text copied from Adobe.
So, for example, if I copied text from Adobe, I would paste it in Excel. Thirty lines of text would past vertically into a column, from Row A1 to Row A30, with each line of text in its own row. I wanted to figure out a way so that in adjacent columns, I could put it so that I would have a set of formulas reading in =A1 in Column C cell/row 1, =A2 in Column D cell 1, =A3 in Column E cell/row 1, =A4 in Column F cell/row 1, =A5 in Column G cell/row 1, and so forth. I realized that if I copied this down, in the second row, the result would entail references to A2, A3, A4, A5, A6. I would prefer that the references update to A6, A7, A8, A9, and A10.
View 5 Replies
View Related
Jul 1, 2014
I have 3 pivot tables and with 3 filters each (they are all the same filters). I just want to change 1 of the filters for each of the pivot table (meaning the other 2 stay the same for all of the pivots). Is it possible to have a filter change automatically to match a filter in another pivot?
View 9 Replies
View Related
Jul 27, 2006
I am trying to create formula that will show overtime worked in a given day. The code I am using is a simple one ([ cell - 8], for hours worked). The problem is when the time cells are blank/not used it shows a -8 in the cell. what I need to do to create a code that will eliminate the -8 from showing. The cell its self is taking the result from another cell with a formula and then subtracting 8 from the result of the formula in the other cell.
View 2 Replies
View Related
Jul 18, 2014
is it possible to use two filters within a the same field.
ie. right now i can filter using the top 10 based on a value field.
what if i want to see the top 10 customers profit and along any drop in revenue from previous years..
something like this.
the information below was copied out of a pivot table that included the % difference.
Code and Name
YearCheck
Profit
Difference
[Code].....
View 1 Replies
View Related
Jul 10, 2007
I have a worksheet that is unprotected but I am unable to apply filters to it. The option is greyed out if I try and select autofilters.
Another strange thing is that on one of the worksheets when I select Data, Filters there is a tick to the left of Autofilter but it is also greyed out, so in effect I cannot turn it off even tho I can't see the filters!
I have tried to popst a screen shot but unsure how to do it. I think maybe a screen shot would help to explain my issue better so if anyone knows how to do this......
View 9 Replies
View Related
Jan 2, 2008
Let's say that A1:C5 looks like this:
Square Red $5
A2 is empty Blue $6
A3 is empty Orange $2
Circle Puple $10
A5 is empty Black $18
A2 and A3 could say "Square" and A5 could say "Circle" ... this is just how I have it set up right now.
In C1 I have a drop down list ... a list of "Square" and "Cirlce".
***QUESTION***
Is there a way for a user to select "square" from the drop down list and in D1 have excel populate a list of all the Squares colors and prices?
Example of what excel would populate in D1:E3:
Red $5
Blue $6
Orange $2
The thing is that I don't think filters is the answer. The reason being is that I want the user to be able to select the item from the list and have excel automatically populate the information. The user should not have to filter the list manually.
View 9 Replies
View Related
Aug 11, 2008
In my Sheet I have AutoFilter on multiple columns.
I want to view all rows where in different colomns there are values.
For example
Colomn D, Row 6 has a value
Colomn E, Row 6 has no value, But Colomn E, Row 7 has a value.
I want to view then Row 6 and 7, by setting an OR filter 9 or something like that .
by setting filter on Colomn D with ( not empty Cell ) and Filter on Colomn E with (not empty Cell ) it is only a AND function.
How can I get an OR function. ( Colomn D OR Colomn E )?
View 9 Replies
View Related
Feb 20, 2009
I'm trying to modify this code in order to do the following.
I want to choose first column and then the criteria for filter, then i want to choose a second column and criteria to filter the remain values from the first filter.
Here is my
Sub Filter()
Dim Myrange As Range
Dim CriteriaVal As Variant
Dim CriteriaVal2 As Variant
Dim KillColumn As Integer
Dim KillColumn2 As Integer
Dim ActiveColumn As String
Dim AC
Dim LastRow As Long
Dim rng As Range
View 9 Replies
View Related
Jul 26, 2006
I have several pagefields. Once something particular has been selected in one of them, I would like the remaining options in the other pagefields to be updated or refreshed showing only those where there is a correlation with the selected pagefield. In other words, exactly how your typical Excel filter works.
I assume there is no option to change the way pagefields interact to be like filters. How could this be done in VBA?
View 7 Replies
View Related
Dec 16, 2008
First post so please excuse me if this has been covered before but I am trying to get the results of a dropdown menu in one worksheet to become the criteria for a filter in another worksheet (both in teh same workbook).
I thought I could just add a reference to the dropdown cell into the autofilter (in VBA editor) but it doe't seem to be that simple.
Any ideas?
View 10 Replies
View Related
Jan 20, 2010
I am using Excel 2007. I have a list of 100 names all ranked from 1-100. Is there a way to create a macro that can filter out the top 20, a specific name and also any names with the cell colours blue and yellow?
At the moment using an advanced filter based on criteria I can filter out the top 20 and the specific name I want but can't work out how to leave the coloured rows in as well.
View 3 Replies
View Related
Dec 12, 2008
Subtotal doesn't add cells hidden under a filter column but it does when grouping. How can I get groups to change a subtotal based on whether they are hidden or not. What I'm really trying to do is use conditional formatting to change the format when a group is expanded vs collapsed.
View 3 Replies
View Related
Feb 11, 2010
I'm creating a spreadsheet with data I've exported from a survey.
My data begins column headings on row 10 and spans across several columns. I've applied filters to the headings.
Above column 10 I have some summary data using the countif and counta functions. Is there away to have my summary fields change as I apply my filters to the main body of data in different ways?
View 11 Replies
View Related
May 8, 2012
I need to apply filters based on 2 criteria
Filter1Dropdown SelectionFilter2Dropdown SelectionHeader1Header2Header3Header4Header5Header6
Depending on what is selected in Filter 1, lets say it applies to column F and i get a data set
Now with the filtered dataset of Filter 1, I should be able to apply Filter 2 or vice versa.
Also at the end, I need to release all filters so that i can see the entire data set.
View 2 Replies
View Related
Aug 1, 2012
Is it possible to create independent filters. I have data for five departments and sales for different quarters of the years. These sales for the different quarters are independent. But If I select Q1 for first department and Q2 for second department it do not give me the result that I seek i.e. sales for first department for Q1 and Sales for second department for Q2.
View 9 Replies
View Related
Jan 19, 2007
Are there any events associated with filters?
If I have two sheets of data, where column A is NAME and column B is GRADE. Sheet1 is MATH and Sheet2 is ENGLISH. The same students are taking both classes.
Is there a way to make it so that when I filter by GRADE in tab 1, tab 2 is ALSO filtered by the same selection?
View 9 Replies
View Related
Sep 25, 2009
I am trying to get a simple auto filter on 3 tables in the same spreadsheet.
I have seen this in other documents but have never been able to figure out how to do it.
Cells that need the auto filter are
C8 (Range C9 to C24)
C29 (Range C30 to C45)
C50 (Range C51 to C66)
View 9 Replies
View Related
