Hi,
I've got a basic handle on the application/use of macros, & personally use them for cleaning up data exported from a very very old as400esq application.

My problem is that i have managed to clean up all the blank data & piffle, but Im stupped by the header part of the text dump.
Heres an example;
A B C D E F
-------------------Header A-------------
1 3 john 50 piano
4 1 Bill 25 horn
6 5 Ted 60 trumpet
-------------------Header B-------------
3 3 Phil 71 Cello
1 1 James 83 Viola
3 2 Earnie 62 Violin


I basically want to rid the header rows from the spreadsheet & drop the header description (Header A/ Header B) into column F for all those items below until you get to the next header.

I hope ive explained myself well enough.....for something as logical as a spreadsheet its quite difficult to explain!!

Its beyond me! Your help is much appreciated,
Cheers,
L