spreadsheet design question
I am rewriting a series of spreadsheets and not 100% sure that Im going
about it the right way.
Im working in a recruitment agency that has contracts with 5 companies for
drivers.
Im planning on setting up a workbook for each company into which I will put
Time sheet information.
From these timesheets I will need to create a sheet which combines data by
driver as the drivers work on different contracts to produce a costing
sheet.
I was planning on filtering the time sheet data and pasting this onto the
costing sheet.
Does this sound like the best way forward?
Thanks
|