I have a workbook that I manually import data from an external database. The data goes onto a master sheet, then is transferred to individual sheets by date. I want to use formulas in the mastersheet to copy and sort the data into the appropriate cells on the daily sheets. (sort by date to get the data onto the correct sheet, then copy to the range for each office location). Due to security restrictions, I can't save excel files that contain vba code. I can use excel formulas however.