help.

[Guest]

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

 

[Nick Hodge]

ranssff

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

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

2) Format via Format>Cells>Custom... and enter dddd

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

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]

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
(e-mail address removed)