help.
 

two questions.

1) how do i add to a selected consolidated field source data from another
range located in another worksheet in the same workbook.

2) how do i create a number format so that dates i select (mm-yy) will
appear only as the full names of the days of the week.

any input will be greatly appreciated. thank you very much.

ranssff

ranssff

1) Simply add the reference to the formula you already have. e.g

=Sum(A1:A20)+Sum(Sheet2!A1:A20)

2) Format via FormatCellsCustom... and enter dddd

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ranssff" wrote in message
...
two questions.

1) how do i add to a selected consolidated field source data from another
range located in another worksheet in the same workbook.

2) how do i create a number format so that dates i select (mm-yy) will
appear only as the full names of the days of the week.

any input will be greatly appreciated. thank you very much.

ranssff

Mr. Hodge, i thank you very much for taking the time to answer my questions.
your answers were very helpful, unfortuantelly i still can't find the "rate"
button so i can tell microsoft how useful your help was. i'll keep looking.

i am preparing myself to take the mircosoft excel expert examination. any
recomendations as far as what to read and what to know. anything will help.
thank you.

ranssff

"Nick Hodge" wrote:

ranssff

1) Simply add the reference to the formula you already have. e.g

=Sum(A1:A20)+Sum(Sheet2!A1:A20)

2) Format via FormatCellsCustom... and enter dddd

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ranssff" wrote in message
...
two questions.

1) how do i add to a selected consolidated field source data from another
range located in another worksheet in the same workbook.

2) how do i create a number format so that dates i select (mm-yy) will
appear only as the full names of the days of the week.

any input will be greatly appreciated. thank you very much.

ranssff

ranssff

No need to vote...it's not why we do it! (Why do we do it???)

I would hang around here and see what others ask. It gives you a much
better perspective of 'real-world' issues.

You might also try the 'Excel Bible' series from John Walkenbach

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ranssff" wrote in message
...
Mr. Hodge, i thank you very much for taking the time to answer my
questions.
your answers were very helpful, unfortuantelly i still can't find the
"rate"
button so i can tell microsoft how useful your help was. i'll keep
looking.

i am preparing myself to take the mircosoft excel expert examination. any
recomendations as far as what to read and what to know. anything will
help.
thank you.

ranssff

"Nick Hodge" wrote:

ranssff

1) Simply add the reference to the formula you already have. e.g

=Sum(A1:A20)+Sum(Sheet2!A1:A20)

2) Format via FormatCellsCustom... and enter dddd

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ranssff" wrote in message
...
two questions.

1) how do i add to a selected consolidated field source data from
another
range located in another worksheet in the same workbook.

2) how do i create a number format so that dates i select (mm-yy) will
appear only as the full names of the days of the week.

any input will be greatly appreciated. thank you very much.

ranssff