Search for last column and insert column header in first cell

Hi,

What I’m trying to achieve is to search my work sheet for the last empty column i.e. nothing in the cell header cell (b1,c1, etc) and add four new column headers i.e. Total Cumulative Hours, Total Cumulative Amount, Comments, x into the next four blank columns.


Any assistance would be greatly appreciated

Excel version 2003

Many thanks

Rob

This will do what you want

Please Login or Register  to view this content.

However, it is more efficient to fix where the Column Headers are.