MS Excel / VBA help thread

You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.

•

Dramatic_Hammer in reply to @Chalfie

Yeah you should have a table with:
Schoolref | disease | year | whatever you’re measuring

•

Chalfie in reply to @Dramatic_Hammer

That requires a whole lot of reorganising....

•

Dramatic_Hammer in reply to @Chalfie

How many lines currently in the table? I’ve used VBA in excel to convert similar in the past.
Obviously you’ve also got the database itself to configure still and reports/etc that mimic the handy way to view data when it’s all in a wide table.

About

Avatar for Chalfie @Chalfie started