I have a number of spreadsheets, with over 100 columns in each. I am
peforming a data mapping exercise and have to create a word document with a
table that has 3 columns. The first column in the table needs to be the
column ref from the excel spread sheet ie A, B etc. If I insert an new row
above the existing data in excel how can I easily add the column name (A, B)
to each row. I have tried using series fill and the CELL function, without
much luck.

Please advise