auto filter

In Sheet1, I type in the following info: cell A1=EmployeeNumber, A2=Date, A3=Reason, A4=Tag. The info typed here are then saved to a database in Sheet2, i.e., column A=EmployeeNumber, column B=Date, column C=Reason, column D=Tag; this is done via macro when a SAVE button is clicked. What I...

Hello... does anyone know how to make a list data validation pick the information you want from your list by typing the first letter. For example.... autofilters allow only 1000 entries to be displayed. You can choose or "fast forward" to what you are looking for from the autofilter drop down...

I've been looking for a macro to copy my results from an autofilter from column A and paste them into a specific worksheet. Basically I have a main sheet that contains kit numbers across the top and part numbers in column A. If the part number is in that kit it gets an X. I usually use the...

I'm trying to use an autofilter to extract records that are more than a year old: Range("A1").AutoFilter Field:=1, Criteria1:="<11/24/2007" but when I run the macro I don't get any results. I would like to write a code that will do this everyweek when I run the macro so that I don't have to...

I have a spreadsheet that I download from a database that has thousands of combinations. I know that on a small scale I could create named ranges and create a conditional autofilter, but that will not work in this case because there are so many combinations and the spreadsheet updates all the...

I have a data in Column A with a Title BUYER and all the buyers names listed below. Listed adjacent to this in Column B I have the EMAIL addressess of each buyer Currently I have a macro that upon running it filters the records by the BUYERS names one by one and automatically prints each of...

I have read many of the threads that talk about setting up named ranges. That will not be an efficient way to do it for me. I have a table with many combinations and I can see what I want when I auto-filter through the table column by column. I would rather not look at all the data as it...

Hello All, Attached is an example. Is there a way we can achieve this without using auto filter and macros? i.e when i enter the date in cell A1, it should lookup from the range B2:D20 and show all the rows for that date in the range F2:H20. Download XLS here...