I would like to be able to create a project plan that will enable me to
manage when my projects happen and how much they cost. What I envision is
being able to move a project from one month to another month and having the
associated cost of the project also move to the next month (on another
spreadsheet) and that will show a total cost at the bottom of the month.
Ultimately, I would like to have one spreadsheet with projects and one
spreadsheet with the associated monthly costs (in the same workbook), which
will automatically update when I move a project to another time period. I
would imagine you would have to link the spreadsheets but how do I link text,
numbers and moving pieces all at once??