loop and copy

I have an excel file that has 3 main sheets. The first sheet is a Table of Contents for different line items (Line Item List). The second sheet is a Summary (0000_Summary). Each Line Item will have its own summary sheet. The third sheet is a Form (0000-01). Each Line Item can have several forms...

Hello again. I have searched this forum and cant find help on my topic. I have a file on a users desktop that will contain a number of pdf files. These files will save to specific folders on Teams ( i have those pathways and have done it with .xlsx and .xlsm files before.) The files have a...

Hi. Good day. I would like to repeated loop through a set counter of worksheets and paste the results from each group in a different sheet For example, in this sheet Sample sheet i have 12 sheets with data and 4 other sheets. I would like to skip those first four sheets, copy and combine the...

Hi, I'm trying to write a code that goes through sheet with raw data ("Dane") and copies case numbers (col "B") based on date (col "J") and ID (col "A"). I have worksheets named with all ID's from raw data and in these worksheets in col "A" I have the dates. The subroutine should look through...

Hi there, I have 67 fields in column A and B beginning in A2 and B2 - I would like to take the first value in A2 and place it in D1 and then the value in B2 and place it in E1. I would like to then add a column with "Diff" in F1. This column should be formatted to display a percentage value and...

Hi there, I have data in multiple columns on Sheet "Fields" - from A-AS. Each column varies in data and has 1-100 rows populated. I wish to take all this data from these columns and paste them into one column on the "Sheet3" tab. On the fields tab there is a header row which I do not require...

I have been working through VBA code that copies the first sheet in a workbook from a folder to another workbook("Master"). The code copies the data correctly but upon saving I get certain cells with errors (#Ref) this is due some of the copied cells having formula. I would like the copied to...

Sheet1 contains a source table (its size changes every Qtr) and sheet2 contains an index table, containing 'ProfitCenter Name' and 'Analyst email' headers. (1) I am trying to filter the source table in sheet 1 each time according to a specific 'ProfitCenter Name', then (2) copy the results and...

Hello everyone, I need to take a list of 5,500 rows which have an identifier in Column A and put all the rows associated with that identifier onto a new tab labeled with the identifier. My identifier is a "Plan Code" and each row contains asset data associated with that Plan. Some plans may...

Hi I have a problem with a routine that:- 1) loops through a customer table (CustCode(col1),FirstName(col3),EMail(col5) 2) make a copy (based on CustCode) of a master workbook and sends it to a designated directory 3) uses outlook to send the new workbook to the sender (using firstName, Emial)...

Hi everyone, I'm new to vba so will really appreciate any help ;). After a long unfruitful search I can't find why my code won't work. To explain the problem, I have an Excel File with a bunch of data sorted by an index called Prod.Type in column A <tbody> Prod.Type Name Price Nb.Stock 2...

I have a couple spread sheets that have data as follows Sheet 1 – Column A through U (row 5 first entry with data w/ no defined amount of rows, could be thousands) Sheet 2 – Column A through T (row 5 first entry with data w/ no defined amount of rows, could be thousands) I need help...

Hi All, I've an array in one excel file from which i'm trying to copy rows to other excel files, basically from my source file i'm copying each row to within a table to different destinations Excel files, the destination rows is fix but I need to loop through my roughs on the source file which...

I can loop through all 10 ComboBoxes with the following code. [Code] Dim cmb As combobox, i As Integer For i = 1 To 10 Set cmb = Me.Controls.Item("ComboBox" & i) MyPNum = cmb.Value Cells.Find(What:=MyPNum, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart...

Hello Everyone: I have certain value in A1 and will obtain result in another cell. I have to insert no from 1-100 serially in A1 to get results and paste in separate column , any VBA code I'd highly appreciate.

Hello! I've been lurking these forums for quite some time, and found so many helpful. Now I'd like to ask for some help too. I have a nasty array formula in cell c6, with matching time and different criteria, at first I autofilled it on my sheet which is around 5000 rows at max, but it took...

Hello everyone, I have been trying to write some VBA code to check if a cell contains a positive, or negative percentage. Based on whether it is positive, or negative I would then like to copy and paste the value into a new table on a separate sheet which has two tables. One containing all the...

Hey friends, I am having trouble with my excel vba code to perform this macro. I get an error on the line that I put in red text. Please help! [code] Sub Button1_Click() Dim file As String Dim myPath As String Dim wb As Workbook Dim rng As Range Dim wbMaster As Workbook Set...

Hi, I don't have a lot of experience with macros but I managed to build the start of something that works using the macro recorder (See below). The issue that I'm running into now is that I want to code a loop into the macro. I have a list of websites in column G and I want to open them in...

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...