filter and copy

Hi all, I'm chasing a VBA macro urgently but don't know how to go about it. Thanks in advance, please see below: There are 3 documents, I have links to them below: Doc_1: Loading Google Sheets Doc_2: Doc_2.xlsm Doc_3: Loading Google Sheets What I require is a VBA macro in "Doc_3" which when...

Howdy dear forum members, Odd title I agree. So I have sheet 1, sheet 2, and sheet 3. Sheet 1 is the overall data entry dynamic table. Data is added through a User form (button "Add new entry") Sheet 2 is where filtered data (per department transactions) is exported through a macro (see...

Hi guys, I am relatively new to Excel and this is my first post here so please excuse any errors or stupidity on my part. I currently have two problems. Firstly, I need to merge two columns that contain numbers. The problem is that when I do this it is deleting the zeros in the middle. I have...

Hi everyone, this is my first post and i new in vba. i create 3 macros for a excel template, that get the data from the first sheet ("Dados") and do some filter in this data in the other 3 sheets. I upload this file in a internal system, that will use this template for download the data from...

Hello, I am currently working on a project where filtered lists with more than 73000 rows are copied into another sheet, this way isolating the relevant rows. From the original 73000, about 61000 rows are transported to the new tab. My code works, but it takes way too much time to finish this...

I am trying to build a code to filter column D (date Column) to extract data between two dates which i specify in a userform in two textboxes (start and end date). when I run the code i only get the headers in the newly created shet but rest of the data is not filtered/copied/pasted (?). I...

Hi all, I am struggling to find a smart and efficient way where I can make a list out of a huge table. Thought there would be someone here that could help me find a way to build a macro or some condition formula in order to obtain the result i am after. Its heavy manual work but somehow i want...

Private Sub CommandButton1_Click() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA") lastrow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row For rownum = 2 To lastrow Select Case...

Hi, Can you someone help me with below requirement. I have a worksheet with data until column Z. I have list of names as below in the column "AD"(strating from AD1) of same worksheet. Max Alex Harry Sam Sid I am trying to have a VBA code that loops through the list in "AD" and...

Hi Please I need some expert help I have 2 sheets Sheet1 and Sheet2 I need to copy the value of a cell in Column E and have it paste into a data filter in Sheet 2 cell A5 It then needs to copy whatever the returned value in column B and whatever the row is dependent on where the value was...

Hi Gurus, I have below sample raw data. I need to filter and move the information that contains certain words. Example I need to Copy the whole row that contains "Missed", "Chck", "Note"& "Check" (might add more) in the Subject Column. Account Subject Number x Note 1 Note 2 Note 3 001...

Hi everyone, Can you please suggest how I can copy filtered data from one sheet to another? I have 2 sheets: Opportunity and Report. In sheet Opportunity, I'd like to filter for non-empty cells in Range X:AE where Column K is also "Opps". Then for those filtered rows, I'd like to copy data...

Hey Guys Just after some heap been rcking my brain for days! My Table/Range has been pupulated this way; <tbody> <tbody> Window Support Channel 1/1800, 1/1200, 3/600, Window Support Channel 4/1800, 2/1200, 4/900, Window Support Channel 1/1800, 1/1200, 3/600, </tbody>...

Still struggling a bit. I can run the code below but the target workbooks columns are not sized the same as the primary sheet. There seems to be many ways to copy so i think im trying to mix them is why i keep getting a object error. Any suggestion would be helpful in the code below i've...

Good Morning! I'm very new here. I'm working on a project for work and I'm totally stuck. Here are the details: I have a very large workbook containing quoting information. There are 28 different sheets representing different vendors. Each sheet contains quote numbers and quote...

Hello, I'm attempting to put together a Holiday Staffing Planner the returns certain values and hourly counts based on data input and filtering from other worksheets. My workbook has the following worksheets: * Holiday Staffing Planner - (User Input Worksheet) * DD_VALUES - Data Validation...

I should state that I am trying to copy a formula from column C to column A. I do not want the formula copied, just the values. While in a filter for about 100,000 entries (about 20,000 in the filter itself). I used text to columns to separate names from city/states (they were in the same...

Hello Guys, So I have below data on Sheet1 with a range A4:BC. What if I want to Filter all those that returned as "FALSE" (in T/F Check Column) and copy those related columns namely "Inital Check", "Check', & "T/F Check" on another tab sheet named "Check" in range E1:G1. <tbody> A1 -...

I have tried several times to use the method that all the help websites have given on how to copy and paste a bunch of non-sequential cells in a filtered list and it is not working. I have tried selecting the cells I want to copy, then clicking on the "Find and Select"--"Go To Special"--"Visible...

Hey All, I have the following piece of code that is part of a larger macro. This piece basically cycles through some sheets, filters them, and copy/pastes the filtered data onto a summary sheet. It should NOT copy/paste the headers from each worksheet, just the data. It works OK except when the...