excel doubts
 

i would like to know if the following 2 procedures are possible and, if
possible, how to carry them out-
1) for example, if i type the name of a month, say may, and in the next cell
i type a no., say 5, it should automatically fill out like this-'05-05-2008'
2) if i've prepared different sheets regarding different customers but i
would like to type the whole data in 1 sheet the data pertaining to different
customers should automatically transfer to their respective sheets
waiting for your reply
mehvish

excel doubts
 

I think I can help you with #1. First, let me say you gave a terrible
example. There is no way to tell from 05-05-2008 which of the 05 is supposed
to be the day and which is supposed to be the month. I'll assume the first
05 is the month for this response. For future reference, when giving dates,
pick a day number greater than 12 so we can tell by looking which part of
the date is which. Anyway, since you didn't say, I'll assume you are putting
the month name in A1 and the day number in B1. The following formula should
do what you want...

=--(PROPER(A1)&" "&B1&", "&YEAR(NOW()))

and Custom Format the cell using mm-dd-yyyy as the custom pattern (and you
should use dd-mm-yyyy if the first 05 was actually the day).

Rick


"mehvish91" wrote in message
...
i would like to know if the following 2 procedures are possible and, if
possible, how to carry them out-
1) for example, if i type the name of a month, say may, and in the next
cell
i type a no., say 5, it should automatically fill out like
this-'05-05-2008'
2) if i've prepared different sheets regarding different customers but i
would like to type the whole data in 1 sheet the data pertaining to
different
customers should automatically transfer to their respective sheets
waiting for your reply
mehvish

excel doubts
 

On Sat, 10 May 2008 01:33:01 -0700, mehvish91
wrote:

i would like to know if the following 2 procedures are possible and, if
possible, how to carry them out-
1) for example, if i type the name of a month, say may, and in the next cell
i type a no., say 5, it should automatically fill out like this-'05-05-2008'

C1: =--(A1&B1) and custom Format as mm/dd/yyyy (or dd/mm/yyyy, depending
on what you want).
--ron

excel doubts
 

On Sat, 10 May 2008 05:29:44 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

=--(PROPER(A1)&" "&B1&", "&YEAR(NOW()))

or

=--(A1&B1)

--ron

excel doubts
 

On Sat, 10 May 2008 05:29:44 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

=--(PROPER(A1)&" "&B1&", "&YEAR(NOW()))

Hit <Enter too quickly:

At least in Excel 2007

=--(A1&B1) will do the same thing.
--ron

excel doubts
 

Now **that** is an interesting shortcut. Excel sure can be surprising
sometimes. By the way, should you be wondering<g, now that I look at what I
posted again, the PROPER function call was left over from a slightly
different direction I thought I was going to need to take (I simply forgot
to remove it). Still, I would have not come up with the shortcut you posted
(Excel is so flexible in how it interprets dates).

Rick


"Ron Rosenfeld" wrote in message
...
On Sat, 10 May 2008 05:29:44 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

=--(PROPER(A1)&" "&B1&", "&YEAR(NOW()))

Hit <Enter too quickly:

At least in Excel 2007

=--(A1&B1) will do the same thing.
--ron

excel doubts
 

On Sat, 10 May 2008 10:55:34 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

Now **that** is an interesting shortcut. Excel sure can be surprising
sometimes. By the way, should you be wondering<g, now that I look at what I
posted again, the PROPER function call was left over from a slightly
different direction I thought I was going to need to take (I simply forgot
to remove it). Still, I would have not come up with the shortcut you posted
(Excel is so flexible in how it interprets dates).

Rick

It has to do with inputting an unambiguous month and date. In that case,
Excel will default to "this" year -- which is what you were doing with your
formula.
--ron

excel doubts
 

What I found interesting was that you didn't have to use a space to separate
the month name from the day number; and in doing a quick experiment, Excel
doesn't even care about the order of those two elements either. As I said,
Excel is so flexible in how it interprets dates.

Rick


"Ron Rosenfeld" wrote in message
...
On Sat, 10 May 2008 10:55:34 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

Now **that** is an interesting shortcut. Excel sure can be surprising
sometimes. By the way, should you be wondering<g, now that I look at what
I
posted again, the PROPER function call was left over from a slightly
different direction I thought I was going to need to take (I simply forgot
to remove it). Still, I would have not come up with the shortcut you
posted
(Excel is so flexible in how it interprets dates).

Rick

It has to do with inputting an unambiguous month and date. In that case,
Excel will default to "this" year -- which is what you were doing with
your
formula.
--ron

excel doubts
 

On Sat, 10 May 2008 13:31:58 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

What I found interesting was that you didn't have to use a space to separate
the month name from the day number; and in doing a quick experiment, Excel
doesn't even care about the order of those two elements either. As I said,
Excel is so flexible in how it interprets dates.

Rick

I was surprised by that, too. Especially since it seems to be the case that
you MUST use a space between a time and the A or P (M) following it
--ron

dashboard input and display
 

I have created a dashboard and it uses three filters.

Taking the input from the three filters I would like to read a row of data using the combination obtained from clicking on the filters.

I would like to diaplay that row of data as a graph on the dashboard.
The place where i am stuck is that..How to select the row of data using three filter inputs.
The dashboard that I have created is in Xcelsius.

Please reply.

Thanks
ps

dashboard input and display
 

You should consult the Xcelsius documentation.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


<p s wrote in message ...
I have created a dashboard and it uses three filters.

Taking the input from the three filters I would like to read a row of data
using the combination obtained from clicking on the filters.

I would like to diaplay that row of data as a graph on the dashboard.
The place where i am stuck is that..How to select the row of data using
three filter inputs.
The dashboard that I have created is in Xcelsius.

Please reply.

Thanks
ps

High light Totals or sub totals
 

can any one please let me know hot to highlight totals in a rang of data.

EX:-

Accounts 45,000 47,000
receivable 3,000 4,000
payment 42,000 43,000

In the above example "Accounts" value is the total

it means 45,000 47,000

Like the above is there any way to highlight that total by using a macro in excel

High light Totals or sub totals
 

I don't really understand your question, why not just colour it normally?

If you want to only colour it only if there is an figure in it then you can
use Conditional formatting with the formula:

=A4<""

where A4 is the Total cell and select the pattern you want to use.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


<kishore babu wrote in message ...
can any one please let me know hot to highlight totals in a rang of data.

EX:-

Accounts 45,000 47,000
receivable 3,000 4,000
payment 42,000 43,000

In the above example "Accounts" value is the total

it means 45,000 47,000

Like the above is there any way to highlight that total by using a macro
in excel