Copy an area

Hey Forum ! =)
I have a new problem for you. It seems easy but I am not sure wether it is easy or not.
Sooo.... My Problem is : How can I copy a specific Area with a Formular ?
In Cell E17 I have the Text C6 - C6 is where the Area to copy starts. In Cell E18 I have the Text C16 That is where the Area to copy should end. So I want to Copy C6:C16 into the same sheet for expample in row K. But the numbers in E17 and E18 are dynimic so they are changeing and there are different areas to copy.
Its basically like copying a cell - like =C7 than you get the content,... but I want to have it with an area.
Sorry for my english and my description, I am from Germany and its hard for me to explain that kind of problem =) I hope you can understand what I mean. Thanks so much and If you have questions just ask
Christian

Can somebody help me ?? =)
Ah ah ah :D

Okay, there might be a more eloquent way to do this but here's what I came up with.

Assuming you are starting your range in K1, the formula would be

Please Login or Register  to view this content.

Let's start from the end and work forwards....
The MID($E$17,2,5)+ROW()-1 takes the numerical part of what's in E17 and adds the current row # minus 1. So if E17 has C6 in it, and (when you drag the formula down) you're in K2, it'll return 6+2-1 or 7.

The LEFT($E$17,1) & puts the C in front of the numerical value we just discussed. The INDIRECT function says we don't want to treat the result as a value, we want to treat it as a reference (e.g. cell C7) so pull your results from that reference.

Now we want to stop pulling values when we reach the cell in E18, so that's the IF statement and the first part of the statement VALUE(MID($E18,2,5)>=VALUE(MID($E17,2,5)+ROW()-1.

Questions? It could probably be done with VBA or macros more eloquently but that's the formula solution.

ChemistB