vba calculations

I am new to this and trying to get each row to automatically get copied to my second sheet "Completed", then deleted off my main sheet... So - when I select "completed" from the dropdown in Column "N", that entire corresponding row essentially moves over to the second sheet labeled "Completed"...

Hi Guys, I have a pretty large excel worksheet that is used to help clean up financial transactions when rebuilding a companies historical accounting. The sheet uses a mixture of VBA as well as hard-coded formula's living in the cells. ( For this current project that I am working on, I have a...

I need to pare down the number of calculations on the worksheet because it is slow. I'm trying to convert the following formula to a VBA code. {=SUM(IF(I:I>=AI3,IF(I:I<AI4,1,0),0))} where, col1 = "I" col8 = "AI" col11 = "AL" i = 3 the current cell = AL3 Does anyone know how this could be...

I'm trying to convert this formula to VBA code: =SUMIF(I:I,N3,G:G) Cells(i, col6).Value = Application.SumIf(Range(col1 & _ Chr(58) & col1), Cells(i, col2), (Range("G:G"))) Where col1 = "I" col2 = "N" i = 3 I get a type mismatch error in VBA; however, the formula runs fine in Excel. How do I...

I have two similar challenges I need help with: 1. I have about a hundred workbooks saved in a folder. I need to get the sum of all H columns in those workbooks. How can I do this without opening them all and using something like this:=SUM('[Workbook1.xls]Sheet1'!H:H...

Hi I have a problem running VBA code. My colleague has programmed functions (modules and classes), but it simply does not work for me. I know that the code is ok, but maybe I got some Excel properties wrong...? The cell calling the function simply returns '#VALUE!'. Do I have to allow for the...

Hi, I am trying to create a macro to change cells in the final colum in all worksheets whith a sum formula if they already contain a numerical entry. The formula will sum from column c to the second last column (left adjacent) in the same row. Here is where I'm at so far which I'm thinking...

What's the best way to do calculations between same sized ranges in VBA? I've got several ranges that have to use the same kind of calculations between them : Take the first cell value from one range and add/minus/multiply it with the first cell value in another range and put the value in the...