Hi I'm new to macros. I've been trying to make a workbook that I can use at
work to track the progress of numerous projects. I have created a master
copy which will be modified for several different projects. When milestones
are reached the owner of the projects records this in the sheet in a colum
named "Done". This is compared to another column called "planned" and a
percentage can be made called "adherance to planned" This is then tracked for
each month for each ROW, (as each row will represent a new component of the
project).

In another sheet I devised a formatted repot to summaris the data. I got
this working, even made a macro to do it, But my problem is in worksheet 1,
extra lines will be added/deleted and the cell reference for the SUM of the
rows above will constantly have a different row address (same column). I
would like to up date my macro so that it copies a range of cells at the
bottom of my spreadsheet.

Any ideas would be appreciated.
--
agibson

--
agibson