Hello,

I'm new here, and not exactly sure how to search the forum for the information I'm looking for... I've searched but not found what I need, though that might just mean I don't know the right terms to use, so I apologize if I'm asking a repetitive question.

I work for a creative company that hires mostly freelance artists and we are working on doing better tracking of the time we bid on a job vs the actual time worked. I am creating a spreadsheet to track bid hours and actual hours and display that information on a calendar sheet so we can track all of that information day-by-day and week-by-week.

Right now, I have it set up so that as I create a new project, I have to update the calendar sheet with additional rows and the formulas contained in each cell by hand each time a new project rolls in (by copying and pasting the rows/formulas from previously created rows). I would very much like to automate that process, as it's time consuming and making sure that the new formulas are referencing the correct cells in the data sheet has to be done cell-by-cell.

Is there a way to add a new project and have the calendar update with new rows and correct formulas automatically?

Many thanks!