loop and copy paste value

  1. B

    Better Way to Loop and Copy and Paste Items

    Hi, I currently have the following code running no problem (just a little slow for my liking). FYI crng is in ws2. For Each Cell In crng If Cell.Value = concatenate Then r = Cell.row Exit For...
  2. 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...
  3. C

    VBA to copy values between sheets skipping blanks

    Hello everyone! So just so everyone knows, I am a VBA newb, self-taught through extremely helpful forums like these. This is my first post and haven't even set up my profile fully. Lol This request will help me and my accounting team here at my job out tremendously! So, thank you for taking...
  4. M

    Loop with an if Statement

    Hi, At the min I have created the below sub which creates the data in the format which I require overall. However I would now like to split this data up in the loop based on criteria below into 4 different tabs based on the outcome of the statement. At the min the entire data is pasted on the...
  5. M

    Need a way to repeat a step x amount of times in VBA - Loop

    Hi, I have a spreadsheet which has a sheet which contains formulas (called 'Formulas') which are based from an input sheet. There will be a variable number of lines within this sheet based on the data in the input sheet. At the min I have a macro which takes the information on my formulas...
  6. M

    Google Script App - Copy & Paste Loop

    I have a bunch of data in a Google Sheet and I’m trying to create a simple script that’ll loop and copy it over into the correct place in a second Google Sheet. DM SAMPLE SHEET (SOURCE) SM SAMPLE SHEET (DESTINATION) Rules for copy and paste: Loop through each row in the source sheet. If...
  7. S

    Need to make Loop in Worksheet & Workbook

    I am new in VBA & start to learn it. I have Workbook name Primary Flash (MTD & YTD) and this Workbook have 6 Sheets and in all sheets, there are North, West, East & South Zone Data in Field (Region) I need to filter data from every sheets from Zone wise & paste in Anther Workbooks where same 6...
  8. N

    Help coding Excel Macro

    Hi. I'm not a programmer and need help for a local company I'm working with. I have a spreadsheet that has a fixed number of columns (number of rows changes), BUT the dates on those columns can vary. I need to transpose the data and copy the company for as many dates it has listed. There's a...
  9. B

    VBA: Nested for loop for a find, copy and paste across two worksheets

    Hi, I need to create a nested loop involving a find, copy and paste but don't know how to. There are two sheets, ws and ws2. In ws, where acad_year is a certain value, the first loop goes through the list looking for pop_fin (the unique id of the record) and matching it up in ws2. However...
  10. W

    Creating a Nested loop (copy between worksheet) within loop of auto-filtered criteria

    Hello, I am newly registered but not new to search in this forum for new approaches of better structuring my vba code. Still, now I am facing a wall with which I think the solution would be a nested loop (but I might be mistaken:confused:). Document: 1 workbook, 13 sheets (the first is called...
  11. M

    Loop through a range of cells which display the filenames to be opened

    I have a master spreadsheet on sheet 1 in cells D4:D22 are the filenames for the csv files to be opened (the filenames change each month, however the folder where the files are held stays the same). How do I write a macro to loop through each of the cells in range D4:D22 - to open the file -...
  12. 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...
  13. R

    Duplicate declaration in current scope

    I created a userform with 10 comboboxes 1 - 10 which populate with part numbers, with corresponding txt_qty boxes 1 - 10 which populate with ordeer quantities. I want to search on the part number in "ComboBox1" and then store the quantity from txt_Qty1 into a cell in the column named "Order...
  14. Z

    Macro to Copy Entitre column of Matching Column Header & Paste to Matching Column Header

    Hi There, I need help building a macro that copies entire columns from one workbook over to another based on matching column names in row 1. These copied columns would then need pasted in another workbook based on the matching column names. Another way of saying this is to use macros to do a...
  15. Z

    Loop to copy each row and paste to a new tab 4 times

    I am trying to write a macro to copy each line from columns A to E and paste each row 3 times on another tab. I need this macro to loop through until it hits a blank row. Here is code that I recorded, but I do not know how to make this into a loop. I also have a piece of code that grabs F to I...
  16. C

    VBA to loop code for multiple excel docs

    Hello, I need help with some VBA coding, my requirement is: I need to copy and paste ranges from 21 excel docs in a folder to a Master workbook withinrelevant named sheets. I have some code, but want to loop it so it runs through each of the docs and copys+pastes the relevant parts into the...
  17. J

    Make Looping Macro to copy same range but Paste Special at end of existing data

    Hello All! So here's my frustration... I am in no way an expert to excel but have gained much from this forum. I have a spreadsheet that I'm trying to get data from a sheet "V All", it gets its data based on a formula using vlookup from sheet "jhere01". I want to Paste Special from "V All" to...
  18. K

    Loop only copies and pastes from first sheet, not all sheets

    I am trying to grab the value from all sheets in a workbook and paste them as values down the M column starting with M1 on a sheet called "Summary". I would the like to total the values pasted. The value is found with this code: Range("F2").End(xlDown).Offset(2).Copy Here is the whole code...
  19. Nayasoch

    Loop the Code untill cetain value exceeds

    Hello Everyone , I have this code Worksheets("Graph5").Range("G1").FormulaR1C1 = "0.01" Worksheets("Graph5").Range("I1:J1").Select Selection.Copy Worksheets("Graph5").Range("L1:M1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...
  20. 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.

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
Back
Top