#1   Report Post  
ranssff
 
Posts: n/a
Default 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
  #3   Report Post  
ranssff
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"