Getting data to display from an adjacent cell

Hopefully i can explain this clearly enough

I am trying to analyse a whole heap of data generated by an image analysis package. The data is exported out in to excel, I then need to be able ot rearange it a bit and export it out to another program.

I have attached a smaller version of the data as an example. The example data set only contains 3 image planes with ~100 entries for each. A full data set contains 96 planes and ~2000 entries each.

So what i want to do.

I want to setup a workbook i can dump this data into and have it spread everything out over 96 different sheets (1 for each plane).

I can get it to do it for the first lot of data using a IF command like =IF('Object Data'!B:B=1,'Object Data'!D3,)

But that only really works for the first plane, as the starting cell for plane 2 is always going to be different.

So what i need is a formula that will say: look at the plane column, if it equals a certain value print out the value for the other cells in that row.

Is that possible?

Thanks

You could use formulae sure, but if you have lots of data and lots of sheets it will get a little excessive, I would suggest a quick VBA based approach, based on your file something like the below should work:

Please Login or Register  to view this content.

It's not clear if the content of the header cells (ie column B) will need to adapt per sheet but a basic approach would be to store the required header info on a separate sheet and simply copy that into each new sheet as it is added to the file, see attached (note .xlsm format).

If we can make the assumption that this is a saved file (we assume it is obviously) then on the HEADER sheet insert the below into cell B4:

Please Login or Register  to view this content.

When the header is copied the formula will update accordingly
(note: CELL is a Volatile formula but given it's being used in moderation this is no big deal in this instance)

You could adapt the code to do the above but you would need to insert a few extra bits to establish where exactly the field of interest is located within th header ... if the Header layout is rigid, ie you will never alter HEADER sheet, and you prefer not to use any formulae then (having disregarded the above) you could add a line below this one in the existing routine:

Please Login or Register  to view this content.

such that the code would read:

Please Login or Register  to view this content.

The choice as they say is yours.

the workbook needs to be saved for that formula to update itself.

yep, as inferred in my prior post

I had assumed given the VBA routine present in the file that the file would be saved.

You just need to change this section of the code from:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Re: accrediting me - don't worry about that.