Do you want to insert a column before the Column containing "Top" in Row 1,
on ALL sheets and enter 1-Oct-08 in Row 1 for the new column, Oct-08 being
the current month?

"Yossy" wrote:

how can I automatically insert column before "Column name Top" across
multiple sheet. Also date each column for current month E.g) 1 - Sep -08

all help totally appreciated. thanks