Thread: Dynamically Transpose Data??

Cheers guys, that worked like a charm (until I realised some of the workplaces weren't unique) - but I've worked around that now - thanks for your help!

James

Originally Posted by oldchippy

I've just checked out the "Evaluate formula" and can see now

Thanks Chippy! I am still on 2000 so don't have the "Evaluate Formula" option yet. Supposedly our company will update to 2007 by June of next year. We're cutting edge as long as everyone else has done it first.

ChemistB