Hello,
I have the following existing code that find the first eligible row, and to
start filling in data from an array, looking for the next eligible row (skip the row with "ASC" written in column I) after filling in 8 columns (I:N) and looping as many times as is specified in the call from the main routine.
I would like to modify the code so that instead of skip the entire row if column I is "ASC", but only skip the cell with "ASC" instead, but still in fill the data without "ASC" on the same row.
Old code sample data:
A H I J K L M N O P
Line# Mod 1300 1300 1500 1500 1700 1700 1100 1100
001 300 ASC
002 100 x x x x x x x x
003 200 x x x x x x x x
skip row 2 with line# 001 cause "ASC" is in column I2 so skipping cell J2
thru N2). Where x is data that the macro fill in.
New code wanted:
A H I J K L M N O P
Line# Mod 1300 1300 1500 1500 1700 1700 1100 1100
001 300 ASC x ASC x x x x ASC
002 100 x ASC x x x x x ASC
003 200 x x x x x x x x
it does not skip row 2 with line# 001, but rather fill in the missing cell
(J2, L2, M2 and N2) without "ASC" in the cell.
My code is too long to list here.
Bookmarks