• Nice Spreadsheet, in my job , I Tend to get the Data in the Tables rather the the Spec's , it is up to me/the team to decide the specifications

    Eventually , as I seemed to be doing it on a daily basis I ended up writing some VBA which Analyzed all the Data in the Columns and then built the Tables around the information , this tended to save me much more time. I haven't used it since I upgrade to Excel 2007 and Therefore I have not updated the Context menu's that let me execute this

    But at some point I'll do that and put up Post for it

    There is usually some minor alterations , like setting Keys and and Adding a couple of Columns , but most of the leg work is done so its just tweaks