loop functions

How would I create a VB Macro to loop through several dropdown lists and then add all the values to cells on another worksheet? I would like to automatically generate the various combinations for the values in a group of 10 dropdown lists, so when it reaches the end of the last dropdown list...

Hi everyone, I'm quite new to VBA on Excel and haven't quite been able to figure out how to get my macro working yet. I have data that looks like this: <tbody> Date Amount 1 Type Amount 2 Amount 3 Macro Output 01/01/2013 -100 A -80 -20 01/02/2013 -150 B -30 03/05/2014 -200...

I am trying to design a function that grabs an average of only numbers that are within a certain deviation of the mean. I got the plan down, and have done this before without VBA, its just a user defined function will be much quicker. The gist of what I am doing: Find the standard deviation...

Hi Guys I'm relatively new to looping and im looking for some help. My problem is I want to loop an action based on the value of a cell (that value will change). Example: If Sheet 1 Range A1 = 10 Copy selection from Sheet 2 Return to Sheet 1, and paste selection 10 times (based on the...

Hi everyone, Im learning VBA and I have this code Sub SmartRunningTotals()</pre> Dim rng As Range Dim cell As Range Dim lastRow As Long Dim totalTime As Double ' I'm assuming your time column is in column A lastRow = Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row...

Hi, I am writing a VBA code to restructure the multilevel BOM dump taken out from SAP. In this data the number of coloumn's are fixed and row numbers are dynamic depending upon the size of BOM data I have finished with my code, except one part where i am stuck. I tried various things but its...