Hello,

I am new around and new to Excel Macros.
I have a big file I am desparate for help with, the my understanding it has to be a macro.
The files has 5 columns and thousands of raws set by titles and sub-titles.
Column five is data that has to be repeated for every new title in column A and for every new value in column 4 (under same tilte).
So, I am looking the easiest way to:
Identify every new title copy cells in column 5
identify every new value in column 4 and insert the copied data.
When the title in column A changes start the process again
pls see example
https://docs.google.com/open?id=0B4i...nV4T2VGUlhWQVE