Dear all

I need help in order to produce a formula
as you can see in the attached file i have in column C some codes from a
system

The formula should be in column A
and it must bring the code from column C per category in front of each
product.
For example in C4 there is a code.
I wan to bring this code in Column A for lines A7 - A22

Then in the following to bring the code from C25 in front of A28 -A44
The problem is that there is not a specific range for the paragraphs. Some
of them are 10 lines, other 2 or 3 lines and there are some of 200 lines.
Imagine that all file should include more thatn 10.000 lines.

Thank in advace
Manos