Hi I have one challenge at my new job...
there are 65 partners of a company corresponding to each company there are 65 spreadsheets ..in each spreadsheet there are 3 different templates. each sheet contains data and columns have calculations. each sheet contains same sort of data and calculations . there are 3 summary sheets that contain data from 65 sheets. Now the thing is they are growing and there client may go beyond hundreds.. SO what is soluntion for this. because workbook is not going to be manageable in future. What should be solution. Is that good to make access database?...or any other solution...
Thanks
Bookmarks