How to link dynamically: range with in one worksheet to another worksheet

[SK Rutenbeck]

I am attempting to create a dynamic workbook to track and
report staff time, resources and expenses vs assignments.

Worksheets consisting of basic information, eg list of
assignments would link to a custom report in another
worksheet for a specific business unit, and to another for
my staff total across assignments. When the base
information is updated, the custom reports would update.

I know how to link cells and remove zeros in empty cells.

what I can't figure out is how to link a range of cells,
such that when I add or delete a row in the base
information, a custom report would add/delete the same row.

I do not want to use assess or ms project. there's too
much to learn and I need to set this sheet up by week's
end.

I know it's possible in excel, because I've done it very
successfully about three years ago. I just for the life
of me cannot recall how I set it up!! 8-(

Can anyone help me?

thanks!!

(e-mail address removed)

 

[Bernard V Liengme]

Not sure if I understand the question but here are suggestions:
1) to reference a cell on another sheet use formula in the form =Sheet2!B2
2) do you know how to make a dynamic range such that zeros are not needed to
fill cell for which data is currently unavailable? There is an example of a
dynamic chart at www.stfx.ca/people/bliengme/ExcelTips.

Best wishes
Bernard