Solved

# Excel VBA script

Posted on 2011-03-16

I need some help writing a visual basic script to run in Excel on output from a database program. The logic would be as follows.

*find "D" in column A and set x to the row number*

if C(x+1) is not null then copy Ax and Bx to A(x+1) and B(x+1) respectively

repeat

Essentially it just needs to copy the cells from column A and B down one row if there is a value in column C on that next row.

I can usually cobble together vbscript ok but as I have never worked with excel VBA I am having difficulty and I can't seem to find examples to work from with this so any help would be appreciated.