loop and copy paste value

Hi, I have a really basic but important task that involves copying and pasting data from a daily worksheet into another worksheet each day. I was wondering if its possible using vba could a macro loop through all the folders and subfolders in a directory to then find and copy and paste the...

Hello and thanks. I have four cells on a Sheet1 ("T39", "T47", "T57", "N61:N62") that i would like to copy and paste to the next available row on Sheet2 in range ("N:Q"). ElseIf Cells(i, 3).Value = "" Then Sheets("Sheet 1").Range("T39", "T47", "T57", "N61:N62").Copy Sheets("Sheet...

Hello and much thanks in advance. I'm trying to write a loop that searches a range of rows (19-31) and if there is data in column C for that row then i want t paste columns C:U from that row into another sheet. It's been a long time since i've done this and VBA is not part of my regular work -...

Need help building a code. I want to search all worksheets in a workbook that contain a specific string in its sheet name to copy cell data of a range and paste as values into a different ws. What I ultimately need to do is take data from A2 of all BL ws and paste into Column A of Summary ws...

Hello, and thanks in advance for any help. I have a giant list of social security numbers, about 30,000 rows. I use a function to get the first five digits of the social security number in Column D. I can't have more then 4 rows with the first five digits on the same sheet. Currently I run the...

Hello friends! I am trying to create a macro and hitting some walls. The goal is to: Loop through worksheets (# of sheets may vary) Filter Column D for "Equipment" and "Grid" Take resulting data from Column A on each worksheet (excluding header) and paste to a new worksheet or workbook End...

Hello there. I am a bit rusty with Excel and VBA following differing jobs not needing it so much, however I am now currently in a role where using advanced Excel and VBA would be extremely beneficial. I am currently stuck on something which I am guessing is reasonably simple, and google is not...

Dears! I have managed to modify a VBA code with the following result. I can have multiple criteria for which my code search to different workbooks and if criteria meets then brings the required values to a new worksheet for each criteria value. What I want to achieve is to bring all the values...

Hi All, I am trying to loop thru each account in my account master, find the range of cells 7 rows over in the next tab, copy those cells into a calculation sheet with a multiple the values, then I want to paste the end result back into my account master sheet. I am able to get the 1st account...

Hello all, I'm trying to create an array loop that goes through columns A1,D1,G1, J1 (Keeping the headers) from one workbook and paste all the data to one column (keeping cell formatting) on another workbook. The data in the copied columns (A,D,G,J) will vary every time the macro runs so I'm...

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

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

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

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

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

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

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

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

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

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