loop a macro

Hi. I have an excel sheet with about 4,500 rows of data. For some reason the paste I received from the web splits each row on the web into 2 rows in excel. I am trying to take the data in row 3 (Cells A3 through E3) and move into row 2 (Cells G2 through K2). Then I would like the macro to...

Hi All, I have the below macro that I've been using to select data from a sheet, copy the data, open a new workbook, paste special values and format columns C & D to date format. This works perfectly as is, however, instead of the filename for the new workbook being based off of cell H1 in...

I am trying to write a macro with VBA that will copy the data from my table in a sheet tiled "Front End" to a table on another sheet called "Raw Data". here is my code so far for the copying and pasting into the other sheet in the next empty row. I keep getting error that says "application...

Hello! I can't figure out how to make a code loop until user input and continue if there is no input. I don't want to use Ctrl + Break, because I am interested in how many times the code ran and how long it took. Is there a way to have the code pause and basically ask the user to stop...

Hello, I have a question about a macro I'm using to loop through a combo-box to save a pdf of each result that appears when the combo-box changes value. This macro works flawlessly for another tab that simply has a different name, everything else is the same. I've checked the spelling/spacing...

Hi all Now I have 2 File -VBA_CONTROL_FCO_NEW -FCO_NEW [VBA_CONTROL_FCO_NEW] Run Macro open loop Open [FCO_NEW] file [FCO_NEW] run macro and save as (Change File name) and Close end loop Sub Macro2()Dim i As Integer For i = 1 To 6 Workbooks.Open...

Hi, I need assistance with my code as I am struggling to find a solution. I eventually split the array in two as I was getting an error. I am searching for words in sheet "ServiceType_SubType_Item_byComp" and copying the offset value to sheet "Charts", but often there are two cells with the same...

Hi, I'm trying to copy cell's A1 - A?? (depends on data on a different tab) to a .txt file and save it. I would like to take cell's A1 - A?? on tab "Upload -copy to notepad"....and save this information into a .txt file. All of my information is concatenated in column "A"....my problem is...

favorite I am trying to use solver to find the root for 182 cells, each cell is depend only on one another variable, the output cell is from O2 to O183, the variable cell is from P2 to P183. I am trying to change the variable cells to have the output cell equal to 1. The code works but the...

Not sure why this is breaking but I have a spreadsheet with dozens of tabs that require updating through this macro loop. It indexes the first and last pages, 30 to 80 but once it reaches the 39th tab, it breaks. I've tried moving the potential bad tab(running it separately at times) but it...

Hi all, I've got a working code, it is the following: Sub change_title() Dim i As Integer i = 2 Dim title_counter As Integer title_counter = 0 Do i = i + 1 If Cells(i, 7).Interior.ColorIndex = 6 Then title_counter = title_counter + 1 Loop Until Cells(i...

Hello, My macro was built to loop through data of an original workbook and break out the data into individual workbooks based on the value of one field. The code works perfectly for creating the workbooks but I can not figure out how to get each workbook to save and continue on to the next. It...

Hi, Vlookups were taking forever so I wrote the below code to use the scripting dictionary. It works fine on smaller amounts of data but I am getting the Run time error on my "live run". I assume it is due to the size of my data. how can I fix this. My work sheets are between 250k and 350k+...

Hi there, From watching YouTube videos and reading advice on this website I've managed to build myself a pretty snazzy database with a multi-page Userform. It's all working perfectly well however, I have one command button left to code and I can't find anything on the net that does what I want...

I've been piece-mailing together my knowledge of macros based mainly on forums like this and now I finally have a macro that does what I want..mostly. I also understand that explaining my needs is sometimes the hardest part of this, so if my post is lacking clarity, please let me know and I'll...

Hi all, I worked my way around this macro. What is does is that is will open an xlsx, copy all the data and drops it in a specific sheet inside the workbook. The path of the file to copy is in column H. The Sheet name of the to be pasted data is in column I. Now i am looking for a way to loop...

Hello, I am struggling with trying to create a macro and hope I can get some help. I have one sheet (called Sheet1) with 58 columns and about 30,000 rows of data. I am trying to check if values from another sheet appear in the first one and assign a value to against each row if it matches the...

I'm using Excel 2013 on Windows 7 and while I'm not getting errors, it's also not doing what I want it to, its doing nothing. What I'm trying to do is go through a list in Column Y and have each row with the same value in Column J copied to a new sheet by the same name. I can manually copy...

Hi Everyone, I need some help in displaying some information. I've got data which runs from 1am till 10pm one day and then 4am till 7pm with corresponding processes which occur at each time e.g. 1 am process 5, 1am process 2, 2am process 3, 3am process 4 and so on till 10pm. I want to find a...

Hi All, I'm very new to VBA's. But with the examples on this forum and other sources, I've created a working VBA. There are still two features that i need but i don't understand. Repeating the macro and working down a list. The whole VBA is based on the value in worksheet(SEND)Range("E3")...