vba loops

I download a .csv daily In the columns the following headers, Meter, serial num, value, uom, day, wk#, timestamp, and a few more rows of usless info. the meter name changes, the serial num, and the value changes. I added the columns for day, and week# in to make it easier I though. I use the...

Hello, I have a very basic VBA code like as follows: Sub Hello() 'Removes any duplicates Columns("A:A").Select ActiveSheet.Range("$A$1:$A$27").RemoveDuplicates Columns:=1, Header:=xlNo 'Copies name from top of CE List into Input tab G12 Sheets("Names").Select...

Hello all, I have been coming the archives of many forums trying to find a good, effective and safe solution for changing the layout of an SAP report exported to Excel 2010. It takes months and months to get them to provide us with information and while we have asked for raw data they seem...

Hi everyone I have been teaching myself VBA and have now started coding bigger "Projects". However, I am pretty unfamiliar with code Loops, which is why my codes are pretty insufficient and Long. :-) I have tried to read and learn how to shorten my specific codes but could unfortunately not...

Hello, I'm trying to use the following code to evaluate an array formula across a range of cells: Sub EvaluateTest() ActiveSheet.Range("D2:G2").Value =...

I have data in column A that I would like align right if =(LEFT($A10,4)=" ") is true. Is there a way with VBA to run through all of the rows in column A and apply the align right to all the cells that are true? Thanks for your help!

cheque book Bank Data Date cheque no amount matching cheque in bank date cheque no amount 01/10/2009 692201 40000 no match 01/10/2009 692203 23000 02/10/2009 692202 50000 no match 05/10/2009 692201 40000 03/10/2009 692203 23000 no match 06/10/2009 692205 51000 04/10/2009 692204 29000 no...