macro - loop

HI, I was hoping someone might be able to help me. I'm looking for a macro that loops through workbooks saved in one folder and combine specific worksheets into one workbook (as separate tabs). The worksheets can either be called the same thing or be the 3rd, 4th and 5th worksheets in the...

I'm trying to create what I believe to be a simple loop to my VBA code, but unfortunately I don't know enough about VBA to create it, so I'm just posting the code I have and am hoping somebody could tell me what I need to do to loop the code. I need the loop to continue from column to column...

Hi - I currently have a working macro but need help to make it loop through every sheet rather than only working on the active sheet. below is my current macro if you could help that would be GREAT! Sub CPV() Set Rng = Cells.Find(What:="round", _ After:=ActiveCell, LookIn:=xlFormulas, _...

Objective: to create a VBA auto-generated script from data elements within a series of cells Data elements (Target Name starting at B1): A B C <colgroup><col><col span="2"></colgroup><tbody> Target Name J RMC Pohnson LMC Alias Names Johnson RMC...

Hello I'm trying to create a macro to compare two sheets (I need to compare five but two for now is enough) and highlight the differences. The problem is that in my sheets the rows are not always in the same order and not all sheets have exactly the same number of rows so I can't use a simple a...

I have around 2000 exel files in a directory. Some have filename = x + background.xls and others Filename = x + processed.xls In each one there are seven Column in the first row: Area Mean Min Max IntDen RawIntDen Bellow the first row are the values. I want to obtain the Mean of all the values...

Hi, I would like a macro: - to open an excel file in a specified location - delete the first 6 rows - save - and close next workbook (same as above) until completed appreciate the guidance anthony

Hi! I'm using Excel 2010 and I have a fairly straightforward issue that I'm trying to solve. Any help would be greatly appreciated! I'm a good programmer but I'm new to VBA, so I don't know enough syntax and it's taking me forever to do what I think should be pretty simple... :) I have a To Do...

Hi All, This is my first time working across sheets. I tried to copy the format of another program that worked across sheets. This is my code: Sub Search_Finder_Sheet() Dim sh_WC As Worksheet Dim sh_FS As Worksheet Set sh_WC = ActiveWorkbook.Sheets("Walls_OR_Columns") Set sh_FS =...

Group, I've written a couple of macros. The first one finds the last row on the spreadsheet. In my current sheet, there are approximately 55,000 rows. It works fine with no problems. The second macro finds the blank cell (there are lots of them) and fills it in with copied data from the row...

I am new to VBA and to the forum, sorry if I am posting this in the wrong location. I am working on a macro and have it nearly complete, I have created a tab that will tell the user if they should print or delete the tab (based on whether or not there is information on the sheet or not) so that...

Hi, I'm trying to repeat an action which I think requires a "Do Until" loop but I'm not entirely sure if it does and I have no idea how to loop! So any help would be greatly appreciated! My current code is: Sub Quarter() ' ' Macro1 Macro ' ' If Range("A1") > 0 Then...

Hello New to EXCEl VBA , but this community is known to help a newbie become pro users :) My requirement is simple. I ve around 200 excel files with names like NAME1,NAME2.NAME3.....ETC... IN A FOLDER. I ve another Sheet1 in Book1 where correspoing to each NAME1,NAME2,NAME3 IN COLUMN A,i ve data...

New to EXCEl VBA , but this community is known to help a newbie become pro users :) My requirement is simple. I ve a list of filename in column A:A200 of Sheet1 of Boook1. I ve an excel Book2 which is a readymade template with 6 sheets. I Need to create or rather replicate this excel Book2, by...

Hi, I'm new to VBA and I'm having trouble trying to write a looping macro. This is what I'm trying to repeat: ActiveCell.Offset(1, 0).Range("A1:B1").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove ActiveCell.Offset(-1, 0).Range("A1:C1").Select...

Hi awesome Mr. Excel community! I am currently trying to create a rather complicated macro, and as you might have guessed by my user name, I am a bit lost right now. This is how my data is currently shaped: I have one column which contains the data of owners (turquoise background...

Hi! I have a formula on a cell (B12) that is based on the value of another cell (B3). What I need to do is to have a table of 2 columns: - the first column is a list of values that are supposed to be inserted in cell B3 (say, 500, 501, 502, ... 3000) - the other column is the results of the...

Thanks in advance for any help you can provide. I am very green when it comes to creating macros and I’m hoping someone with more experience can help me out here. I use a budgeting software package to produce P&L’s each month. Unfortunately, you can’t format the reports in the in the software...

Hello and thank you in advance...I have a large spreadsheet that is exported from an application. I need to have a macro that will find all rows for each state and copy the row into a new worksheet labeled by each state and delete the rows that it copied. I would like to do this automatically...

Hello - I am new to VBA programming and I have written a macro (see below) to export a range of Excel cells values to a .txt file Specifically, what I am trying to do is create a macro that Selects a section of integer data from a spreadsheet Copy it to a text file...