VBA/Formula to copy a cell and paste it down column A

[lewdow]

Hi,

I have a spreadsheet which is downloaded in the following format:

(if this doesn't work go to http://tinypic.com/view.php?pic=v8jle&s=6)

I need whatever is in the grey merged cell to be copied into column A in all cells above it (see pic for explanation), then delete the merged cell.

Any ideas?

Open to VBA or formula's to do the job!

Many Thanks

 

[SamTYler]

Merged Cells + VBA = Bad juju. Can you format the sheet without Merged Cells.

How are you coloring the cells? Format or Conditional Format?

Do you want to Delete the entire row the grey cell is in?