looping

Hi Everyone, Below is a segment of code that I have recorded for an instance in a macro that I hope to fully automate. I have a column (J) of account managers in my '2014-2015' tab, the idea is to cut all the data except for the account manager who I have selected, refresh the entire workbook...

I have a range of data with many columns, and each day it will be updated-- it will always have the same columns but a variable number of rows. The goal is that my macro will look at a specific set of 39 columns in the middle of the range beginning with the right most one, and examine the cells...

here is sheet <tbody> ORDER QTY PROCESS Load for Process 1 Load for Process 2 Load for Process 3 45000 1+2+3 45000 45000 45000 50000 1+3 50000 50000 6000 1+2 6000 6000 65000 1+2+3 65000 65000 65000 70000 1+2 70000 70000 </tbody> This is the sheet in process column if i choose...

i have condition in one column and i want to use if statement for all row's which we have condition in column. See here <colgroup><col width="102"><col width="64"></colgroup><tbody> Routing ITEM 1 A 256,000 B 300,000 A 256000 B 300000 </tbody> if routing =A then item 1 cost is...

I have written a VBA in which I want the user to input the number of bills And then the user will be asked to input the amount of each bill. and the sum of all the bill will be displayed in in C8 For example, if the user inputs that the number of bills is 4. Then, the user will be asked to...

Hey, I've got a code written to transfer the exact data I want from each row. How do I apply this to multiple rows as there is about 300 rows I need to go threw. Range ("B5").Select Selection.Copy Sheets ("TemplateTrans").Select Range("B16").Select ActiveSheet. Paste Sheets ("Master").Select...

Row 1, Column E thru Z contain my headers. Sometimes the headers are merged across multiple columns and sometimes not. The data will be in rows 2 thru whatever. For Example: The column header in E1:G1 has Site 1. E2:G2 contains the data for Site 1. Thus E2=5, F2=13, G2=5. So the total for...

Hello I have several workbooks that are used to track sales scores and payouts. Each book relates to a "group" and each group a region. The Workbooks all vary in the number of reps being totaled and calculated. I have a "Control" worksheet that has various components of the saving process...

Good afternoon gentleman's. I have created the following script to run different messages based on the result of a formula on the worksheet. My problem is that I have implemented the vbYes/Vbno message box on one selection to change the value of a cell if the user clicks "Yes. This is performed...

Hi Guys, I have a massive template that has a large number of formulas in the spreadsheet so I wanted to reduce the size by building the formulas in a macro and have the macro enter the result in a hard coded value. I'm not great with macros but I did a few searches and have the following -...

I have a very cumbersome Macro set up that I know is unnecessarily long. It takes about 25 minutes to run and I finally have some time to look at making it more concise. Basically all I need the macro to do is enter two values into cells A1 and A2 (these are inputs to a formula) and then have...

I have an excel workbook with a list of contracts to be submitted. The information in the workbook is used to create a email (form) where the information is filled in and files are attached. Originally the code: For Each rCol In tbl.DataBodyRange...

Hello, I'm having an issue with converting different UPC string lengths to one common length. Basically the data teams in our company do not have a firm standard on UPC or UPC equivalent (for internal product identification) nor do our different software have the same database structure. What I...

Hi, I'm using the url extension for Google's "I'm feeling lucky" functionality but want to copy the url this function opens (i.e. the direct url). I'm using the below macro which works fine but need it to loop down a list until it finds a blank cell. I have a list of hyperlinks in column E...

Hello, I have the following code that transfers all the Excel files in Folder 1 to Folder 2: Sub Move_NRAuto() Dim fso As Object Dim FromPath As String Dim ToPath As String Dim FileExt As String FromPath = "\\TJ-file-dfs-01\Central\DataList\Folder1" ToPath =...

Folks, How do I stop a loop after 3,000 iterations and start it back up at the same spot I left off, or make it slow down so I can pause it and step thru from there? I am investigating an error within the last 35 iterations of the For Step Next loop. Thank you, Rowland Hamilton Sub...

Hi All, So a bit of vba help please and thanks! I'm looking for a macro that will copy and paste the values in a range of cell from the sheets of one workbook to the sheets of another master workbook. I want a macro that will let me select which second workbook to copy from, and then copy the...

Hi everyone, I've got a range of data in sheet1 that I want to sort through and transfer to single column in sheet2. This should hopefully be quite a simple task. The data is in sheet1 in the range E12:M100. I want to some code that goes through each row (like reading a book) and transfers...

I have a mysterious problem in which a MsgBox infinitely displays after clicking its buttons. What is really strange is that the next portion of code executes, but doesn't exit the If statement. Sub XcaliburCSV() Dim XQNFile, ProcMet, InstMet As String...

This should be easy, but I can't for the life of me figure it out. I have a workbook with 20 sheets, and column C in all of the sheets contain numbers that are stored as text. I want to loop through each sheet, define the max rows in column C as a variable, then convert C2:Cvariable from text...