I'm new to Macros so any help would be much appreciated. The macro itself is very long, but basically I have a macro that loops through columns of data starting column 9 ("I") then when reaches last data row in column goes to next column (col 9 + 2) etc until no more columns of data. However, row 8 is always blank. Is there a way to get the loop to include if cell in row 8 is blank then get value of column B of workbook2 (list of values) moving down values in column B as loop goes to next column? The number of columns of data in workbook1 can vary from.
Or would it be better to first get the macro to fill workbook1, row 8 blank cells with values in workbook2 column B ? If so how?
Thanks in advance.
Or would it be better to first get the macro to fill workbook1, row 8 blank cells with values in workbook2 column B ? If so how?
Thanks in advance.
