loop and copy paste value

Hi, This sounds simple, but I am stuck. I am looking for a simple loop that will count the number of rows down then start the process of moving B2:E2 to C1:F1 then B4:E4 to C3:F3 and so on until there are not anymore rows. In the end, it will use the following to delete all rows that do not...

I use Excel 2013. I have values listed in Column A of Sheet 1. I want to copy each value from Column A and paste the value into Column B of Sheet 2 as long as the cell from Column A of Sheet 1 is not blank or null. (Once the cell is blank or null, then it has reached the end of the populated...

Hello All, I am new to VBA and could really use your help on this. - I have a folder that has 3 types of files (APL, PL, BPL) and a master file. I would like to pull specific data from specific sheets in each of these files and pull it back into the master file. - The issue I am having is...

Hi, i want to do the following, from the table below i want to: 1-Filter per column C for unique values 2-Once filtered if its only "1" row, then put each cell on that row into a variable. 3-Once filtered if the results is more than 1 records, meaning the same email address has 2 or more...

I am trying to loop through 20-30 sheets within a workbook and copy and paste values into a new sheet if it contains a certain text. Column B contains the text and I would like to copy the cell in column B and the value in column C. For example, column B has 46 rows and with various names...

Hi Everyone, I am looking for VBA code which will loop through columns J:W. If the given column contains the text "YES", then I would like to filter that column and copy the data into another sheet called "Numbers" Otherwise I would like to loop onto the next column and do the same action...

Hello I am fairly new to VBA and have been playing around with a few different things for the last few days while tryng to accomplish the following: I would like to: 1) copy from cell b3:b6 2) paste it in sheet2 in cell a5 3) (back on sheet1) copy cell D3 4) paste on sheet2 in cell A3 5) (back...

A B C <tbody> Column Exclude Label 3 *9/1/2016* DONE 2 *342* NEXT 2 *423* NEXT 5 *MAE* RE 5 *RTX* VEN 5 *FES* VEN 7 *1232* MR 7 *3212* MR 7 *4236* MR </tbody> Right now, I have that table on the front page. I would like to filter values based on the...

Hi everyone, I couldn't find anything in the forum that could answer my question so here goes nothing... I am recreating a table from an older board game that uses a slide rule to report numbers. During the game, the slide moves up and down according to what space you land on. However, if you...

Sub dataloop() Lastrow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row For i = 4 To Lastrow If Cells(i, 3) = "Pass" Then ActiveCell.Offset(-4).Copy ActiveCell.Offset(2, -2).PasteSpecial End If Next i End Sub I am trying to use looping to copy and paste the value where C= Pass, then go...

Hi i was wondering if someone can edit this code so I can search by 3 criteria instead of one. Also if 1 or criteria are chosen it will give me those results aswell. This macro works perfectly just missing 2 more criteria. The video below gives me a way to add a second filter but only if both...

Hi all, I'm working on a loop that will look-up and place values (text or numbers) into a collection of combo and text boxes in a Userform. I have 75 comboboxes and 150 textboxes in the userform (2 textboxes under each combobox). Lets say the name of the comboboxes are as follows: Cbox_1...

Hi everyone! I'm hoping someone can help me with VBA as I'm about useless, especially when it comes to loops. I have a workbook that can have data entered into cells C4 and E4, and it generates a snapshot view, we then print the view. I need to automate this task if possible so that you...

Hi there, I would like to write the following loop, could you give me some idea how to write it? I need the macro to copy columns with the same region in the mater workbook to another workbook. For example, the macro will copy the column A to C to a new workbook named EAST. then the macro...

Hi all, I’m new to VBA and need some help with copying dynamic ranges from Sheet2 to Sheet1. In Sheet2, I have 5 dynamic ranges. Named in col."A" as: Dep-1, Dep-2, Dep-3, Dep-4, Dep-5 Each range have data in column A,B,C,D,E and I. Below range name (e.g Dep-1) are some rows with info. Then...

Hello, I am very very beginner :) I want help ASAP, please. I have recorded macro that copy and pastes several cells from sheet 1 to excel calculator form, then it copy and pastes the result back in the sheet 1. I have recorded this process for two row. I want it to work in whole range (from...

I have an excel spread sheet that has account information for users. There are multiple occurrences of a value in column B that say "Account Name:" and I need to copy the value that is next to it in Row D and paste it in Column A of a different worksheet in that workbook called Data. I need to...

Hi guys, I have code to replace some columns in a specific worksheet. I want to apply this to all workbooks in a folder: So open > paste values > save > close ...next... workbook open > paste values > save > close ... and so on. All Workbooks have the same Worksheet name that it goes into and...

Hi Guys, I am returning here, as you could help the first time I posted an issue I had here. Hoping you can help me again. So I have several excel files. I want to loop through them and copy a single cell from each of them (cell F19 from the 1st sheet). The problem that I have is that I want...

I have a table that looks like this: Need Col D values that have ";" present to be parsed out to create and new worksheet with the results looking like the output below. I've looked & tried but is beyond my level at this time. Any & all help is greatly appreciated! :banghead: Excel...