loop a macro

Hi all, I'm trying to change the font color in a range when the cell in column G changes. The macro below is only working for the first row (row 8). I imagine this would be easier as a loop but I couldn't figure it out. There are many different font colors and each cell already has...

Hello everyone i have simple vba code to find a word in the worksheet but i have a small issue, when i find the word the cursor moves to the word but the small window where i type the text disappears , i want to run the program continuously until i press the cancel button and below is my code...

Hi, I am having a number of individual excel files in a folder. I want to add a Summary sheet in each of the individual file and save it. I've prepared the Summary sheet, it contains calculations and formulas based on Data sheet. I have one macro which loops through all the files in the folder...

I'm trying to create a tracker based on the quotes that my employees are sending out to our customers. I'll need to have the information coming from their individual versions of the same quotation tool to a singular tracking workbook on a Box.com folder. I need the information inputs to be added...

Looking for assistance with my current VBA Macro in excel 2010 that is to perform the following function. Based on what is located in column I on tab "Covers" it will got to the correct macro, once it runs the needed macro I am wanting it to loop thru to the next row/cell in column "I" until it...

Hi All, Im not sure if I can attach the whole file as an example but I have described my VBA setup below. Any VBA help to identify and correct my memory usage issues would be greatly appreciated! I have a SharePoint site that has hundreds of Excel files stored on it and I interact with them...

I'm trying to use VBA and solver to fill a 10x10 table of values. (I am a complete beginner to both VBA and these forums, so I apologize in advance for my inevitable blunder in this post.) My solutions table has years in Column A (A3:A12) and percentages in Row 2 (B2:L2). There is a vlookup...

Hi! I'm a novice user to VBA; I really appreciate any help. I'm working with a userform; I've got a 'complete' button that transfer the textbox entries to specific cells on the worksheet. However, I also need to allow the user to hit the 'add another region' button and then be able to go back...

I am not familiar with VBA if then loops so I don't really know where I would begin to write what I need. here's the scenario: In sheet (1) If cell values in column (F) = 1 then, in that same row, copy cell value in column (A) and find the next empty cell and paste in sheet (2) column(B) the...

Good Morning. Anyone point out to me how to loop through a drop down list and then call another macro? Ex. Drop down list: Apple Orange Peach Mango Plum I want it to go to apple first, run a macro I already use have then move to Orange and run the macro again until i get to plum and stop...

Hello, I am currently using the following code to pull in data from various websites. Sub Macro3() ' ' Macro3 Macro ' ' Dim Erw, Frw, Lrw Frw = 1 Lrw = Range("A" & Rows.Count).End(xlUp).Row For Erw = Frw To Lrw With ActiveSheet.QueryTables.Add(Connection:= _ "URL;" & Range("A" &...

I am using Excel 2010, and when I download data into Excel, the Totals Row doesn't line up with the rest of the data. The totals row ends up in Column A, while the data starts in Column B. I am therefore trying to create a macro that will search Column A for the word "Range", then select that...

Hi, I'm hoping I can get some helping with adding VBA code to my workbook that will merge data from multiple "detail" workbooks to one consolidation workbook. I have a list of file paths, names and sheet names in my consolidation workbook. I would like the macro to follow the first "detail"...

I continue to have a Runtime error 91 on this part of my code. I think it is because the loop includes a with. Can anyone help me? Am I putting the right things in the right place? Dim g As LongDim k As Long For e = 8 To y Set x = cs.Range("F:F").Find(fs.Cells(e, 1).Value) If Not...

Hello! I am working in Excel 2010 on a Windows 7. I have a set of data that I am trying to filter by each value in a column within the data set, save it as a new spreadsheet, and then email to a specific individual. I pulled out all of the values that I need to filter on and created a new tab...

Hey guys, so I'm trying to fix a set of data column by column. So for example I have <tbody> Pass Score Age Gender No 40 21 Male Yes 92 19 Female Yes 87 45 Male No 69 60 Female Yes 72 37 Female </tbody> and I want <tbody> Pass Score Age Gender N 40-49 20-25 M Y 90-100 15-19...

Hello, So i will have data updating in mutlple rows everyday. What i want to do is when the value "5" pops up in a column (k), a message will pop up saying something like "tote #49 (the tote number is in the same row, column H) will expire in 5 days". I want to do this also for 4, 3, and 2...

If IsNumeric(ThisWorkbook.Sheets("sheet1").Cells(RowCounter, "A")) = True Then Call Method End If InitialRow = InitialRow + 1 Next MsgBox ("The End") End Sub Hi All, Above is the Code if the Column A has a Character go to Next line Works Perfect. BUT it Exits...

Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...

Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...