loop and copy paste value

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 Everyone, I have any value in cell A1 and B1, suppose in Cell A1 =10*x and cell B1 = 20*x, where x is value from 0.01 to 0.99 and then Each value of A1 and B1 , I need to paste in G1 and H1. For example:- step 1: when x =0.01, Results on A1 and B1 I will copy and paste special in G1...