loop and copy

  1. M

    vba to select all pdf files from a folder and save to Onedrive

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

    Loop through subset of worksheets

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

    VBA loop to transfer data to another worksheets

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

    Macro to transpose two columns and add an extra column to a number of fields

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

    Copy and paste data in multiple columns in to one column

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

    Loop through folder and Copy values and Formats of first sheet into summary sheet

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

    Filter a table using a different name each time and paste the results as values in a new file to be emailed

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

    Loop variable unique values onto corresponding tab

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

    Excel VBA Loop Routine Outlook email not printing first message

    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)...
  10. B

    Loop and Copy/Paste all Rows equaling a variable into a new Excel File

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

    Match data from 2 sheets, copy from one to the other.....

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

    copy data from one excel file to another

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

    Looping userform ComboBox 1-10 with associated TextBox 1-10

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

    Loop a single cell value untill a certain value

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

    Speeding up a loop

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

    Check if a value is positive or negative VBA

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

    Copy Data from one file, then loop through a folder and paste the data in each file

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

    Coding 2 loops in VBA

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

    copy & paste using looping

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

    Multiple Condition If statement with loop

    Hello, Im new to VBA and have hit a wall trying to figure out how to write a if statement with multiple conditions to loop through a set of data. I'm teaching myself and the best way has been to look at code others have wrote and then modify it. However, I cant find anything that is similiar to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back