I am using Excel 2016.
I have Eleven columns of data (Col A through K).
Col A has a unique code and that column does not have any empty cells.
Only one cell in Col B through Col K has an entry. For e.g. the entry in range B25:K25 is in H25.
On rare occasions there may not be any entry in Col B to Col K.
Row 5 (A5:K5) has column headings.
Data starts in row 6. The last row changes from file to file.
ISSUE TO RESOLVE:
In Col L, create a header called Consolidate (cell L5)and insert the cell from Col B to K that has data from row 6 onwards. I would like to do this for all the rows. If there isn't an entry in any cell for Cols B-K for a row, Col L for that row should be blank.
I have to do this over and over again. A macro would be greatly appreciated.
I have Eleven columns of data (Col A through K).
Col A has a unique code and that column does not have any empty cells.
Only one cell in Col B through Col K has an entry. For e.g. the entry in range B25:K25 is in H25.
On rare occasions there may not be any entry in Col B to Col K.
Row 5 (A5:K5) has column headings.
Data starts in row 6. The last row changes from file to file.
ISSUE TO RESOLVE:
In Col L, create a header called Consolidate (cell L5)and insert the cell from Col B to K that has data from row 6 onwards. I would like to do this for all the rows. If there isn't an entry in any cell for Cols B-K for a row, Col L for that row should be blank.
I have to do this over and over again. A macro would be greatly appreciated.