Automate Excel Spreadsheet Template
$5-10 USD
Paid on delivery
Every day I get a new spreadsheet filled with data for up to 30 people. The data is arranged in rows (i.e. 30 rows, or one row per person). This might continue for up to a year (i.e. up to 365 new spreadsheets). I need to create a separate worksheet for each person. At present I cut-and-paste each row into the appropriate worksheet. This is time consuming and I am sure can be automated. Therefore the goal of this project is to develop an excel template which automates this process and which can be customized and used for different projects. Specifics of the template: The first two columns of the Spreadsheet A are the Date (d/m/year eg. 1/2/2009) (ColumnA) and the number of days after the start of the project (Column B). Columns C - Y in Spreadsheet A are to befilled by the data from the daily reports. Then there are existingformulas in Spreadsheet A (columns Z - AY), which need to be updated (draggeddown) when a new row of data has been entered in the column. I have included some example spreadsheets.
Project ID: #2891577