My client has asked me to look into something, and ive got white noise in my head now!!
They have created several Excel workbooks which contain a massive amount of data (eg lists of documents, lists of accidents etc) a lot of which them link to other workbooks, worksheets and websites. Along with a menu page, sub menu pages and other bits. There are probably 30+ worksheets, and nearly all of them are completely different in layout and function. Oh and that's for one site! so duplicate this 8x to cover the country.
OK so this is basically tabular data with hyperlinks... sort of.
Because this has become so big and clunky they now want to somehow "port" it to a website (I work in ASP.net, and they have in-house servers), and worse still they want to continue to use the old excel system whilst this is being developed, and "sync" the data when it goes live.
I'm at a loss as to if this can even be achieved...