drowningindata

Hi Guys, Just to let you know that a variation on the VLOOKUP with offsets has resulted in a solution I am pleased with and will try out on some tutors and students tomorrow. Thank you both for your help.

Have now found it!! I could swear it was not there before!!

Sounds interesting.......I am new to this forum!!.....but I cannot locate your attachment?

RE:make the master sheet delete any other sheets when it's selected How would I do that?

Thanks again, I can see that working, only downside I can see is that each teacher will end up spawning 25 new worksheets, I wonder if I can get the macro to name the sheet for them and ensure that the master sheet stays in view?

Thanks LosOjos, I had tried that. It allows you to put the data vertically, it responds to the filtering and does not pick up hidden columns but you cannot place the relevent fields side by side! Also it requires your user to carry out the transpose and not all of them are that IT literate. What I would like to a achieve is a SELECT student on sheet one, go to second sheet to see their data sensibly displayed. More ideas welcome!

I have an excel sheet outputted from SIMS.net of some 150 rows of student data with filters applied. The filters are used by tutors to select down to their tutor groups and then the individual data record (row) of interest. Because of the width of the screen and a sheet with 80 plus columns it is difficult to assimilate the data once selected. I would like to select a number of columns and display them vertically with their corresponding column headers. See second worksheet called Data Display. I had thought that pivot tables would work but have not been successful, any ideas? Sample data - December 2012 - Progress Check.xlsx