loop

I have the code below and seems pretty standard but it only runs for 1 worksheet and doesnt loop through them all. Cant figure out whats worng Sub formatdata2() Dim keepcolumn As Variant Dim fnd As Variant Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets 'Cells(1, 1).Select...

Hello All, I am working on a project and was hoping for some help on the final piece of this puzzle. I have a sheet Source that has two columns W or X that could contain a possible string of text that if its found I would like to place a value in column AL. I have a small lookup table on a...

I am using this snippet from recorder. Columns("O:O").Select Dim SortO As Long SortO = Range("O" & Rows.Count).End(xlUp).Row ActiveWorkbook.Worksheets("data").Sort.SortFields.Clear ActiveWorkbook.Worksheets("data").Sort.SortFields.Add2 Key:=Range("O2:O" & SortO) _ ...

Hi all, I have raw data that I want to convert to be read easier. There are lines open between each statement. 1. I would need the payment date(M67) to be pasted in every row in column K(In photo - K75 and K76) for the transactions 2. I would need the Internal code(C68) and code(C69) to be...

Hello, It has been a very long time since I have posted on here, so I apologize in advance if I am rusty on any preferred protocol and information/data to include on a post. I need to be able to able to obtain the average daily balance of each case, for each quarter. Since I have not found a...

Hello, I want to loop over all indices in a filtered column & do something for each indice each time, how can i do that please ? Thank you in advance :)

Hi all, I have the below data, in column L: COLUMN L 1 2 3 AADDYE 4 FJGLLT 5 FJJDUE 6 FJGOTR 7 ADREWS 8 FSERTT 9 MBJGFR 10 FKOORR I want the output as per below when I run the marco to be: "AADDYE","FLGLLT","FJJDUE", - looping until the final data...

Hi All, I am still fairly new to Macros and VBA however I am learning from Mr. Excel's 2013 VBA and Macros book. I am attempting to write a macro (see below) that will Loop through the current workbook sheet by sheet and find the specific text to derive Top of Range and Bottom of Range, deliver...

Would anyone be able to help me with the following VBA? I've no idea of how to do it. If D15 < K15, then increment Y15 value+1 (This would need to loop until the condition is met) Then go to next row and check the same. This would have to apply to rows 15 to 44 Thanks

Dear Mr Excel I would be so grateful for some help with this. I have 4 Sheets that contain data that i am trying to write a code for. MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...

Hi to all. Got 1 problem(for now :eek:) cant figure it out. got row data on the left side (filled rows) if row (column A4) is not empty > copy row (formulas and conditions) F1 (from column BJ to GK) behind (after BI column) loop till last row. Would be grateful.

Here is the scenario : I have "n" Workbooks which get filtered and their data is copied to a "Master Excel" I have created the whole process for a single workbook named "1". But in order to replicate that process for the other workbooks (named 2,3,4....so on), I have to copy-paste the whole...

Hello everyone! I'm looking for some help on how to go about making a code to Loop a file with 3 tabs and then copy, paste, and save another spreadsheet with the data. To be more specific I'm trying to do the 4 things below. I would like to have the code in an excel (called "Data") that will...

Hi folks, I am unable to figure out how to solve the following problem. I have a working loop that runs down a list of names in column B (Account) and retrieves data from individual account workbooks on our network (quite a few) and puts them on the main sheet like below. My problem is that...

Hi folks, I am not very versant with chart objects and keep getting stuck with the following problem. Thanks for your help! I have put a simple version of a minisheet below with data. I could not figure out how to capture the charts in the minisheet so an image of the "desired result" is...

Hi folks, Is there a way to auto-fill laterally across columns like there is down rows perhaps using a macro? I was thinking this might be handy in some instances I've run into, but I'm not sure how to make the ActiveCell part work. Sub FormulaFill() ' Dim rng As Range Dim y As...

Hello, I have recently started to code a macro to help me repetitive data analysis with very few knowledge in coding languages. I have came up with this code, the idea is that I import my data on the sheet "raw" then I select the different series of values and name them in a new sheet. Since I...

Hi! I need to loop through a dynamic data set, only the range in which the data are entered is given. I need to loop through every cell and copy the value to the end of another column. I totally managed that for the first column but now I am stuck with telling excel to increment the row and...

Hello! I'm stuck with this for several weeks and that's why I'm asking for your help. This code interacts with a third party application, sending values and printing documents from it. It works fantastic, only for the small detail that with the passing of the iterations the cpu fan starts to...

I have two workbooks; one with data to be replaced (main workbook) and another where to find data to replace with (secondary workbook (converter) / two different sheets; product and subproduct). In main workbook there is columns: A: row_id = not to be touched B: product_id = product code to be...