A
aileen
I have 6 columns of data and an unspecified number of rows. If a row has a
number that is not 0 in both columns 5 & 6 then I need to insert a row below
that row and copy all the data from the original row. Then I need to put a 0
in the original row column 5 and put a 0 in the inserted row column 6. e.g.
SPX OCT 2008 900 0 400(this row would be left alone) but SPX OCT 2008 1000
-200 300(this row would need the macro applied to it). Is this possible?
number that is not 0 in both columns 5 & 6 then I need to insert a row below
that row and copy all the data from the original row. Then I need to put a 0
in the original row column 5 and put a 0 in the inserted row column 6. e.g.
SPX OCT 2008 900 0 400(this row would be left alone) but SPX OCT 2008 1000
-200 300(this row would need the macro applied to it). Is this possible?