I would like to take this excel template and program the spreadsheet so that I would be able to do the following
1. Sort on Column A (MD) and write output to new workbook so that each MD (shown by initials) would have its own worksheet - all data fields would populate the new worksheets in the new workbook called 'Doctor'
2. Sort on Column B (Floor) so that each Floor (shown by initials) would have its own worksheet labeled by the initials of the floor, in a new workbook called 'Floor' Only columns A,B, C, D and E would be exported to the new workbook
3. Both these workbooks would be saved to the local hard drive
4. The two sorts would be shown as buttons on the top of the spreadsheet
20 freelancers are bidding on average £252 for this job
Hey, I am an excel expert and can create a code that would sort the data and generate files as required. Please check private message for details... Thanks and Regards, Shikha