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.
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?
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?
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+.
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...
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.
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.
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 =
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?
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!
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.
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.
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.
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?
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.
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......
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.
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
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?
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.
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.
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.
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?
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.
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?
