loop and copy paste value

  1. P

    VBA loop with wildcard in Sheet name

    Hi All, I'm pretty new to VBA, this is my also my first time posting on here. Hoping somebody can help me tweak my code; The code loops through all the files in a folder to copy data from a sheet called ("P&L 2019 - UK GAAP") into one workbook. The issue that I'm having is that, a couple of...
  2. T

    Loop through a range of cells and skip blank cells.

    I have a spreadsheet that survey's equipment condition for equipment condition for multiple places, which is designated by ID (see Data Input example). For each row I need the equipment under the columns header "E1" and "E1C" copy/pasted into another worksheet ("Data Output") with the ID number...
  3. K

    VBA for copy/paste to different sheet with loop

    Hi guys, I'm new to VBA macros and cannot figure out a way to add a loop to my macro. I have data output from an experiment and want to do the following: Copy/paste data from sheet "Data" to sheet "Summary" (see below code). Loop with an offset of 130 rows. The paste function should select...
  4. R

    Loop-through Macro

    Hi, I'm wondering if anyone can help me with the below? I have 2 files (Client X & Client B). They are saved in the following folder: I:\Content & Creative\Design Admin\_Revenue Additionally, I have my summary file (which does not yet have a macro - but this is where I'm wanting the macro to...
  5. D

    Looping of a copy/paste/PDF generator macro

    Dear MrExcel community. Over the last year I have needed to collect and process more and more data which is coming my way from an online survey distributed to colleagues. The output of this survey is generating an array of data which is 40 column x 300 row (thereabouts). I am currently...
  6. D

    Excel Ninjas: Loop Copy/Paste Category Types at Row Level

    Hello, I am trying to create a macro that does the following: Loop down sheet and copy the Description (Column E) Ex: Copy "Cash in Bank" [Note: the empty cells at the category description level (Beg and End)] Paste the description in (Column L) next to each transaction Ex: Paste "Cash in...
  7. C

    VBA Loop to Create and Save Multiple Workbooks and also import client names and totals into document

    Hello, I am in need of a code to create and save 93 excel client reports and also insert client names and totals into the report (specific cells). I currently have an excel document that is the template report and another document that lists client names and total amounts. I'm hoping there is...
  8. F

    Excel VBA. Copy and paste from one cell to another based on value.

    Hi All. Fairly new to the world of VBA. i'll give a brief description first and then add more detail. I'm basically wanting to search down a column for specific words, each time I hit one of these words I want to jump into the previous column and cut the value from there and paste it as a...
  9. B

    VBA Run-Time Error in loop for pasting range values from one workbook to another

    WHAT I'M WORKING WITH: I have two workbooks, MacroTestingSheet2.xlsm is the source, and Target.xlsx is the destination. MacroTestingSheet2.xlsm has several worksheets in it that serve as the data source for the rest of the worksheets. Target.xlsx is a copy of all the remaining worksheets...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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 -...

Some videos you may like

This Week's Hot Topics

Top