I would like to put some code into my spreadsheet do that it copies a range into columns based on the value in row 1 of each column
I hacve a tab entitled "TABLES"
Column C contains a range of data (c3:c204)
Columns D > EL the columns are numbered 2>140 in row 1
Row2 downwards is all blank in columns D>EL (Only column C has data in it)
I would like the code to copy the range in column C (c3:c204) into any column where the value in row 1 is equal or less than the value which is
located in a separate TAB "COVER Sheet" cell 14
thanks
I hacve a tab entitled "TABLES"
Column C contains a range of data (c3:c204)
Columns D > EL the columns are numbered 2>140 in row 1
Row2 downwards is all blank in columns D>EL (Only column C has data in it)
I would like the code to copy the range in column C (c3:c204) into any column where the value in row 1 is equal or less than the value which is
located in a separate TAB "COVER Sheet" cell 14
thanks