[UNRESOLVED] variable range selection determined on cell value?

[direktoren]

Hi

I have a bit of a complictaed problem (or at least complicated for a person with me novice VB programming skills)

I have a report in Excel, generated from an OLAP-viewer. I need to restructure the data so it is presented as I would like it. The problem is determining the range which I need to copy to a new sheet.

In my report I will be experiencing different amounts of rows in column B (Classic OLAP hierachical view - column A=group, cloumn B=subgroup, rest of the columns consists of the actual figures), as the number of subgroups may vary.

Column A Column B

BFORR GICS
a
b
c
d
e
f

W3744 GICS
a
b
c
e

SO - what i need is help with a code that will do something like this;

If range("B5")=GISC then range BFORR= ("B5: next cell in column B="GISC" (this cell not included in the range)).
After this I need to be able to copy it over in a new worksheet in a final structure.


Is this by any means possible??

/Nicolaj