filter and copy

Hello, As the title suggests I'm trying to copy a range of filtered cells. The source has a lot more than 5 rows but of these filtered cells I'm only trying to copy the first 5. This is the code I've been using so far: Sub Top5() Dim CopyRange As Range Sheets(5).Range("B3").AutoFilter...

Hello I have a spreadsheet with multiple columns that after filtering column G I want to copy those lines onto another spreadsheet. My hurdle is that those lines vary, it could be one, ten, etc. Without getting into too much detail here is part of the code. Essentially I want to copy any lines...

Hi all! I am trying to filter a data file till there is only one row of data (excluding headers) and then I copy the relevant cells in that row. However, there will be some instances where my filter criteria is not enough to filter till one row of data. If that is the case, I want the user to...

Hi friends, I am new to VBA but I find it immediately interesting! What I’m trying to do involves two worksheets. When I run the macro, I would like it to search through the worksheet “Screening Log” in column j to find all the records denoted “Y”. Making note of that row, I’d then like the...

Hi All I’m a newbie to the forum as will be shown by my amateurish code below….please bear with me. I’ve spent about a day on trying to sort this myself already to no avail. What I’m trying to do is a write some VBA code to open a range of different excel files, go to the same point in each...

I have a large dataset that I want to filter by values in column A. I then wish to copy all values within that filter to a new worksheet in the same workbook. I wish to name the worksheet after the filtered value. I then wish to repeat this for all unique values within the dataset, each time...

Hi, I need some help trying to figure out why the following is not working, I have a data table on one sheet that is exported from an external database. I then have a summary table that contains the results of search and other data which is then published onto an internal site. Below is sample...

Hi there! I have a problem with copy and pasting values into another sheet with a button(Macro). I will explain what i mean. For example, i have 2 columns, A and B in sheet1. Column A is ID number. (Every ID is unique) Column B is Orders. (Between 1-50) Lets say that i have 10 rows with...

Hello there, I'm hopeful someone could lend a hand, I've been having trouble returning "similar" or "partial" matches with VBA code... Specifically, I am trying to search for a single word within cells that contain many, find the all the cells that contain that word, and then paste all of those...

Appreciate anyone's help creating the VBA code to execute a copy and paste function base upon certain criteria being selected. I think it needs to be a VBA script because I have a macro to clear the data in the New PO's tab once an "order" is written and the information is copied to the PO's...

Hi. My situation is this: Every week, I get a worksheet full of data. Some rows are relevant to me, and some are not. My goal is to quickly create a list of only the relevant rows. (I send this list on to others who are not interested in the process, so for the final product, I don't want it to...

I have been trying to get a fix for this issue for the past 2 days. I have an excel file that runs to around 54,645 rows showing individual expenses for FY 2015 month-wise. I need to replace duplicate expenses with zero only in one month (June). The list is filtered and it is best that it...

Hi, I am using a piece of code (copied below) that I found on another forum site. This macro uses check boxes and and that are checked on sheet 1 at the click of a button will copy the row data and paste it onto sheet 2 However the issue that I am having is that I want to specify what cell in...

Hi My information have 13 columns and my Date column is F I want to filter my information from Date 1 to Date 2 for example: from 4/3/2015 to 4/15/2015. how to do it? Is it Possible after that on filtered data, I Filter them with Card No.(Column B) and I have filtered Data in New Sheet...

Hi Guys Thanks for all the help - But now I sit with my most DIFFICULT problem yet and I don't even know where to start: I have 2 workbooks (Active Projects, VMC Display) WB - Active Projects <tbody> Date Project Number Audit JTO PTO 15/01/16 P-6200123 1 15/01/16 P-6200555...

Is there any way to automatically filter, copy, and paste from a large data set into tabs within the same file? I work in a school system with over 50 schools. I frequently gather data in a large spreadsheet containing all schools. Each school has a unique identifier in Column A. Once I...

Hi all I have a large data table in varying size 300 - 6000 rows, 20 columns. I am trying to sort the data for display purposes, mainly graphs, so I am using.. Sheets("Data Display").Range("B33:B6033").SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets("Calc").Range("A10000") and...

Hi all, I have been looking for a nice way to extract the top 20 rows based on the value in one column. The data table is approx 20 columns by 6000 rows, I use VBA to sort and apply filters in various ways, but I would like a way of keeping a small table at the top that keeps the top ten of...

Hi all. So I have a table I've filtered by a value in Column I. I have then filtered those results by finding Blanks in Column F. I now want to take all the filtered values in Column G and copy them to the same cells in Column F. I can't get it to work to save my life, not even when copying the...

hi there, I have one workbook with 50+ tabs and want to parse them out to a new workbook based on the specific cell "u2". Let's say out of 50+ tabs only 2 tabs have same number in cell "u2". I need the macro to pick these two tabs and copy to a new workbook. Here is the code I have so far...