Dear Rushiraj,
Yes, u can send to all
in the cells put all the emailids seperated with commas(",") and in outlook
sheet select dropdown and select that emailid's .
It should work.
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 11:20 AM, rushiraj patel wrote:
> Dear Anil,
>
> Tnxs for the ins
Dear Anil,
Tnxs for the instant reply. The macro is working so fine. One more
thing i would like to ask is can i use the same macro to send mails to
more that a mail IDs.?
like as we can put the list of emil ids to whom i wanna send mail in
addressbook sheet. As of now i have to drag down from va
Dear Pravin,
Pl see the enclosed sheet .
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 10:06 AM, Pravin Gunjal wrote:
> Dear Friends,
>
> Is it possible to make "freeze" for unique row & column at a time for many
> sheets?
> Hope to get the solution.
>
> Thank you,
>
> Regards
> Pravin
Thankyou. Now I can say I have seen this before a longg time ago.
On Tuesday, 19 March 2013 15:09:57 UTC+11, Shuzbut wrote:
> I have the following formula
>
> =COUNTIFS($B$2:$B$6,"*>=*1",$C$2:$C$6,"<6")
>
> Instead of counting if the number is between a hard coded 1 and 6 I want
> to ref
Dear Friends,
Is it possible to make "freeze" for unique row & column at a time for many
sheets?
Hope to get the solution.
Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
Dear Dhaval,
Your file in which u have mentioned some data is in text format. so direct
deoing sum formula will not work. firstly u should convert that text to
value by using following formula.
=value(a1) it gives u a value then do sum function .
It will work
Warm Regards,
Gawli Anil
On Mon,
Dear Ronmcfarlane,
you should use
=COUNTIFS($B$2:$B$6,">"&H2,$C$2:$C$6,"<"&H2)
Because " " inverted commas excel thinks it is a comment only to display..
Warm Regards,
Gawli Anil
On Tue, Mar 19, 2013 at 9:39 AM, Shuzbut wrote:
> I have the following formula
>
> =COUNTIFS($B$2:$B$6,"*>=*1",$
Dear Anil,
Whr is the data or report ?pl share the base sheet.
Warm Regards,
Gawli Anil
On Mon, Mar 18, 2013 at 6:38 PM, Anil B wrote:
> Hi Experts,
>
> find attached the excel sheet
>
> I need ur help to pull up the report by just one click on button with the
> help of Macros and i have t
I have the following formula
=COUNTIFS($B$2:$B$6,"*>=*1",$C$2:$C$6,"<6")
Instead of counting if the number is between a hard coded 1 and 6 I want to
refer these top another cell
For Example
=COUNTIFS($B$2:$B$6,">=H2",$C$2:$C$6,"= and < operators within the " ".
Your assistance would be a
so, do you need help finding what someone else already asked and answered?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever yo
Dear Experts,
I required a macro to send automatic emils to my sending list. some one had
posted the same long back.
rgds,
Rushiraj
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.faceb
Dear Experts,
I required a macro to send automatic emils to my sending list. some one had
posted the same long back.
rgds,
Rushiraj
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebo
Hi ashish,
your suggestion is really awesome,
but this code was not working please suggest how to use this
code.
or please share the workbook
thanks,
On Saturday, 16 March 2013 20:01:32 UTC+5:30, ashish wrote:
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As
OK, you have a couple of problems here that I can see:
1) In your routine:
Set r = .Find(Date, LookIn:=xlFormulas, lookat:=xlWhole)
the "Date" function will return a string in the format of the current Date
environment variable for your Windows OS.
try something like:
Sub chkdate()
MsgBox Da
Hi Experts,
find attached the excel sheet
I need ur help to pull up the report by just one click on button with the
help of Macros and i have total eight reports for your information i dont
want hyperlink option.
Thanks,
Anil
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
Thanks Dear
still i m not getting what i want pls refer sheet
On Mon, Mar 18, 2013 at 5:59 PM, Kuldeep Singh wrote:
>
> Hi Dhaval,
>
> You can use below formula:
>
> *=SUM(INT(A1:A22)) With Ctrl + Shift + Enter.*
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0
The problem is:
even though the cells contain only numeric values,
when you opened the downloaded file, the cells were read as TEXT.
Changing the cell/column format to numeric does not change the existing values.
If you select the entire column and replace "." with "."
Excel will "re-evaluate" the
*Thanks Kuldeep
can i add subtotal function with below mention formula
*
On Mon, Mar 18, 2013 at 5:49 PM, Kuldeep Singh wrote:
>
> Hi Dhaval,
>
> You can use below formula.
>
> *=SUMPRODUCT(--(A1:A22))*
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-484110
Hi Dhaval,
You can use below formula.
*=SUMPRODUCT(--(A1:A22))*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you re
Dear Friends
me downlaod daily file from my back office pls refer NEt.xls
i m not able to do sum at the end of the amount
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/dis
Please find the attached file..
On Mon, Mar 18, 2013 at 10:49 AM, ravinder negi wrote:
> Hi,
>
> A1
> 0.6875
>
> B1
> =1.5/24
>
>
>
> =A1+B1 0.6875 =1.5/24 =A2-B2
> Please convert the A1 into numbers
>
> --- On *Mon, 3/18/13, JosephJoseph * wrote:
>
>
> From: JosephJoseph
>
> Subject: $$Excel
Hi Viney, Thanks a lot for your suggestion...in the end we arrive to the
same solution. I was managing the problem in a similar way!
Sergiovery
Il giorno sabato 16 marzo 2013 06:14:13 UTC+1, viney mehta ha scritto:
> hi Sergiovery,
>
> i tried is for you.see the solution sheet..
>
> hope thi
22 matches
Mail list logo