Hi,
I am using Microsoft Excel 2000. I have just done a spreadsheet which
contains information about patients. In one worksheet I have the raw data and
then in others I have copied columns across and then used IF(AND) statements
to abstract the information I need, e.g. to work out how many males there are
in each of the hospitals. What I need to know is how do I set it up so that
when a new entry is added to the raw data, i.e. another patient in a new row,
it automatically updates the information in the other worksheets? What is
happening at the moment is when I add another row the IF statements only work
up to the cell that I put the formula in, so I have to go through every
worksheet and drag down the formula into the new cells in every column, which
takes a lot of time. Can you please help me?