Formula in excel
 

I have a rather large personnel spreadsheet which I am collating every
employee's details into, a similar but less extensive and recent spreadsheet
had a formula to calculate people's age, using the day's date and their
inputted dob.
Now am not so stupid that didn't think to copy it into my new spreadsheet,
which I have done and it works.
However when I try to copy throughout the specific column that I require it
for, I am told that there has been an error VALUE! appears in each cell. When
I click into the individual cells the formula has changed from the cell in
which the current day's date is held to another: the day's date is in column
B1 and the incorrect formula will remain in B column but will move to the
line that the cell I wish the formula to be placed in is held. Does this make
sense?
I don't really want to have to manually into this formula into each
corresponding cell as it will take me to Christmas, next year!
Cheers

Rhianne

Formula in excel
 

Your formula that works will be referring to cell B1. Change all
references to B1 to $B$1 instead, and then copy the formula down the
column.

Hope this helps.

Pete

On Nov 13, 9:00*am, Rhianne wrote:
I have a rather large personnel spreadsheet which I am collating every
employee's details into, a similar but less extensive and recent spreadsheet
had a formula to calculate people's age, using the day's date and their
inputted dob.
Now am not so stupid that didn't think to copy it into my new spreadsheet,
which I have done and it works.
However when I try to copy throughout the specific column that I require it
for, I am told that there has been an error VALUE! appears in each cell. When
I click into the individual cells the formula has changed from the cell in
which the current day's date is held to another: the day's date is in column
B1 and the incorrect formula will remain in B column but will move to the
line that the cell I wish the formula to be placed in is held. Does this make
sense?
I don't really want to have to manually into this formula into each
corresponding cell as it will take me to Christmas, next year!
Cheers

Rhianne

Formula in excel
 

Many thanks! Top tip!!

"Pete_UK" wrote:

Your formula that works will be referring to cell B1. Change all
references to B1 to $B$1 instead, and then copy the formula down the
column.

Hope this helps.

Pete

On Nov 13, 9:00 am, Rhianne wrote:
I have a rather large personnel spreadsheet which I am collating every
employee's details into, a similar but less extensive and recent spreadsheet
had a formula to calculate people's age, using the day's date and their
inputted dob.
Now am not so stupid that didn't think to copy it into my new spreadsheet,
which I have done and it works.
However when I try to copy throughout the specific column that I require it
for, I am told that there has been an error VALUE! appears in each cell. When
I click into the individual cells the formula has changed from the cell in
which the current day's date is held to another: the day's date is in column
B1 and the incorrect formula will remain in B column but will move to the
line that the cell I wish the formula to be placed in is held. Does this make
sense?
I don't really want to have to manually into this formula into each
corresponding cell as it will take me to Christmas, next year!
Cheers

Rhianne

Formula in excel
 

You're welcome - glad it worked for you.

Pete

On Nov 13, 10:49*am, Rhianne
wrote:
Many thanks! Top tip!!



"Pete_UK" wrote:
Your formula that works will be referring to cell B1. Change all
references to B1 to $B$1 instead, and then copy the formula down the
column.

Hope this helps.

Pete

On Nov 13, 9:00 am, Rhianne wrote:
I have a rather large personnel spreadsheet which I am collating every
employee's details into, a similar but less extensive and recent spreadsheet
had a formula to calculate people's age, using the day's date and their
inputted dob.
Now am not so stupid that didn't think to copy it into my new spreadsheet,
which I have done and it works.
However when I try to copy throughout the specific column that I require it
for, I am told that there has been an error VALUE! appears in each cell. When
I click into the individual cells the formula has changed from the cell in
which the current day's date is held to another: the day's date is in column
B1 and the incorrect formula will remain in B column but will move to the
line that the cell I wish the formula to be placed in is held. Does this make
sense?
I don't really want to have to manually into this formula into each
corresponding cell as it will take me to Christmas, next year!
Cheers

Rhianne- Hide quoted text -

- Show quoted text -