Hi all, Extracting data blocks

[JakeBlues]

I have a sheet with several blocks of data I am trying to extract for analysis.
Is there a way to select each block for copying and pasting depending on a single cell contents?
ie the top left cell will alway include the letters TEC
I hope this make sense though I doubt it

 

[Cubist]

You can give your blocks names and call it like this.

Book1
	A	B	C	D	E	F	G	H	I
1		Block 1				Block 1	0	0
2		1	1	1		1	1	1
3		1	1	1		1	1	1
4		1	1	1		1	1	1
5		1	1	1		1	1	1
6		1	1	1		1	1	1
7		1	1	1		1	1	1
8		1	1	1		1	1	1
9
Sheet4

Cell Formulas
Range	Formula
F1:H8	F1	=block1
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
block1	=Sheet4!$B$1:$D$8	F1

 

[rlv01]

I have a sheet with several blocks of data I am trying to extract for analysis.

Are the data blocks all the same size?
When you say "extract for analysis", what does that mean?

 

[JakeBlues]

The block will change when the data is updated but follow the same basic structure, can this be done through VBA?

 

[JakeBlues]

Are the data blocks all the same size?
When you say "extract for analysis", what does that mean?

Occasionally the blocks will be a row larger, the analysis part is so users can look at when their subject is being taught, ie Module C Tracked Technology will run for different classes several times a year

 

[JakeBlues]

As it stands I have vba to run through each block and pull out the info required, this seems very cumbersome, I'm sure there must be a more elegant way to do this

 

[rlv01]

Yes, VBA can be used to identify (and select) a block by it's TCM number, but what you want it to do then is still something of a mystery.

 

[JakeBlues]

Yes, VBA can be used to identify (and select) a block by it's TCM number, but what you want it to do then is still something of a mystery.

Yeah I can see I'm not explaining this very well.
Each block is a class cohort and all the subjects they have to cover.
What I need in the end is to report by subject, what class and when.
Essentially the data changes from listed by class to listed by subject.
Any better?