Thanks a lot, I never heard this formula and it works well.
23 Nisan 2013 Salı 18:05:37 UTC+3 tarihinde Oxco yazdı:
>
> Hi all,
>
> I searched about the macthing algorithm but I found only cell-cell
> matching. However, I want an algorithm like that.
>
> I have a workbook that has 41 worksheets.
Thanks a ton!!
completely solved the problem
Regards,
Deepak
On Tue, Apr 23, 2013 at 7:29 PM, priti verma wrote:
> Hi Deepak
> Please see the attachment.
>
>
> On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote:
>
>> Why not
>> actually firstly i prepared a 2 dyanamic range by using offset for
Thanks Prabhu sir
On Tue, Apr 23, 2013 at 8:52 PM, Prabhu Pinky wrote:
> Hi Amar,
>
> Please check the attached file. hope it works for your concern.
>
>
>
>
> On 17 April 2013 17:03, amar takale wrote:
>
>> Dear All
>> Can tell anyone tell me how to count cell of decimal no.value in range.I
>>
I think other graph is not updating automatically
Regards,
Deepak Rawat
On Tue, Apr 23, 2013 at 7:41 PM, priti verma wrote:
> I hope you got your solution
>
>
> On Tue, Apr 23, 2013 at 7:19 PM, Deepak Rawat wrote:
>
>> thanx for ur consideration
>>
>> i need to add more graphs like this with au
Thanks Paul & Preeti.
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 really need to.*
*
*
On Tue, Apr 23, 2013 at 9
Hi Experts, please let me know if requirement is not clear. Thanks !
On Tue, Apr 23, 2013 at 1:27 PM, Smitha S R wrote:
> what is the option for the same in Excel 2007
>
>
>
> On Mon, Apr 22, 2013 at 1:13 PM, ravinder negi wrote:
>
>> you can use auto corrrect feature which will replace off int
Hi Kuldeep,
Please use the following code
Sub ProtectAll()
Dim sheet As Worksheet
Dim myPassword As String
myPassword = "password"
For Each sheet In ActiveWorkbook.Worksheets
sheet.Protect Password:=myPassword
Next
End Sub
Regards,
Priti verma
On Tue, Apr 23, 2013 at 9:16 PM, Kuldeep Singh wr
try:
Sub prot()
Dim sht
For Each sht In Sheets
sht.Protect
Next sht
End Sub
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 c
Hi Experts,
I want to protect all sheets Via VBA. Anyone please help me.
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 unles
Hi Rakesh,
PFA, hope it will works for you..
On 17 April 2013 17:23, Rakesh Kumar Sharma wrote:
> Dear Experts,
>
> I want the month wise sum amt where the column "tr" is #N/A. I used SUMIF
> but i don't know how to use conditional sumif.
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact:
You could use the formula:
=INDIRECT(A1&"!B10")
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 you can.” - John Wesley
-
Hi all,
I searched about the macthing algorithm but I found only cell-cell
matching. However, I want an algorithm like that.
I have a workbook that has 41 worksheets. 41th worksheet is the major file.
In the 41th page, there are 40 row which has also the same name with 40
worksheets. If the wo
oh i see... thanks a lot... [?]
On 23 April 2013 20:00, priti verma wrote:
> Hi Prabhu,
> Its just depand on dyanamic range.
> if you want to add more graph you have to prepare a new dyanamic rang
> .and have to add these new range into legend series.
>
>
>
> On Tue, Apr 23, 2013 at 7:52 PM, Pr
Hi Prabhu,
Its just depand on dyanamic range.
if you want to add more graph you have to prepare a new dyanamic rang .and
have to add these new range into legend series.
On Tue, Apr 23, 2013 at 7:52 PM, Prabhu Pinky wrote:
> Hi Preti,
>
> Really this is excellent one. this one will be very usef
Hi Preti,
Really this is excellent one. this one will be very useful for me very
often. May i know the working procedure of this. so that i can easily do it
in my workings.
On 23 April 2013 19:41, priti verma wrote:
> I hope you got your solution
>
>
> On Tue, Apr 23, 2013 at 7:19 PM, Deepa
I hope you got your solution
On Tue, Apr 23, 2013 at 7:19 PM, Deepak Rawat wrote:
> thanx for ur consideration
>
> i need to add more graphs like this with auto update
> what i need i have attached could u kindly see that
>
> Regards,
> Deepak
>
>
>
> On Tue, Apr 23, 2013 at 7:06 PM, priti verma
Hi Deepak
Please see the attachment.
On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote:
> Why not
> actually firstly i prepared a 2 dyanamic range by using offset formula .
> one is lable and second one is rnglabel .and then i defined the name of
> that formula. after that i select the chart o
ok
On Tue, Apr 23, 2013 at 7:19 PM, Deepak Rawat wrote:
> thanx for ur consideration
>
> i need to add more graphs like this with auto update
> what i need i have attached could u kindly see that
>
> Regards,
> Deepak
>
>
>
> On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote:
>
>> Why not
>> a
thanx for ur consideration
i need to add more graphs like this with auto update
what i need i have attached could u kindly see that
Regards,
Deepak
On Tue, Apr 23, 2013 at 7:06 PM, priti verma wrote:
> Why not
> actually firstly i prepared a 2 dyanamic range by using offset formula .
> one i
Why not
actually firstly i prepared a 2 dyanamic range by using offset formula .
one is lable and second one is rnglabel .and then i defined the name of
that formula. after that i select the chart on right clicking on the chart
.and go to add series and in the series name box i selected the a2 ce
Hi Priti,
If i have to add some more graphs than its not working, kindly will u share
how to add more graphs with same feature
example is attached
regards,
Deepak
On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote:
> Hi Deepak,
>
> Please see the attachement.Here I used Dyanamic name range by
Good job!
On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote:
> Hi Deepak,
>
> Please see the attachement.Here I used Dyanamic name range by using offset.
>
> Regards
> priti verma
>
>
> On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat wrote:
>
>> Dear all,
>>
>> I have a problem regarding graph aut
You're not including the entire macro code, so the loops are not complete.
Are you familiar with the concept of loops?
For instance, if you define two variables:
Dim ColumnNo
Dim RowNum
and you set up two loops
For ColumnNo = 1 to 5
For RowNum = 2 to 10
Cells(RowNum,ColumnNo) = "Value:
HI
how did u do this will u clarify a bit
Regards,
Deepak
On Tue, Apr 23, 2013 at 6:33 PM, Deepak Rawat wrote:
> Thanx!!
> exactly what i need...
>
> Regards,
> Deepak
>
>
>
> On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote:
>
>> Hi Deepak,
>>
>> Please see the attachement.Here I used Dyana
Thanx!!
exactly what i need...
Regards,
Deepak
On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote:
> Hi Deepak,
>
> Please see the attachement.Here I used Dyanamic name range by using offset.
>
> Regards
> priti verma
>
>
> On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat wrote:
>
>> Dear all,
>>
Superb Priti Good job done !!
.
Enjoy
Team XLS
On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote:
> Hi Deepak,
>
> Please see the attachement.Here I used Dyanamic name range by using offset.
>
> Regards
> priti verma
>
>
> On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat
Hi Deepak,
Please see the attachement.Here I used Dyanamic name range by using offset.
Regards
priti verma
On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat wrote:
> Dear all,
>
> I have a problem regarding graph auto update...
>
> I have to add date daily then i select data manually, is there any
Dear all,
I have a problem regarding graph auto update...
I have to add date daily then i select data manually, is there any idea
that i add date and the graph update automatically?
Sample is attached.
regards,
Deepak
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa
Hi,
I am sure that this is possible, but don't know how to work out.
On Tue, Apr 23, 2013 at 1:39 PM, priti verma wrote:
> Hi Smitha,
> This is not possible.erma
> thanks
> Priti v
>
>
>
> On Tue, Apr 23, 2013 at 1:25 PM, Smitha S R wrote:
>
>> Hi,
>>
>> Please help..
>>
>> -- Forwarde
Share the sample file with datat
On Monday, April 22, 2013 6:14:48 PM UTC+5:30, Amit Desai (MERU) wrote:
>
> Dear Friends,
>
>
>
> In general we filter data based on the contents in rows. I would like to
> know if we have any options to filter data columns.
>
>
>
> Could you please help.
>
Hi Smitha,
This is not possible.erma
thanks
Priti v
On Tue, Apr 23, 2013 at 1:25 PM, Smitha S R wrote:
> Hi,
>
> Please help..
>
> -- Forwarded message --
> From: Smitha S R
> Date: Mon, Apr 22, 2013 at 5:08 PM
> Subject: Fwd: $$Excel-Macros$$ selecting the word from a list wi
what is the option for the same in Excel 2007
On Mon, Apr 22, 2013 at 1:13 PM, ravinder negi wrote:
> you can use auto corrrect feature which will replace off into Office
> Supplies.
>
> Just go to file->option->proofing->autocorrect, type off in replace box
> and office Supplies in with box.
>
Hi,
Please help..
-- Forwarded message --
From: Smitha S R
Date: Mon, Apr 22, 2013 at 5:08 PM
Subject: Fwd: $$Excel-Macros$$ selecting the word from a list with the
first letter.
To: excel-macros@googlegroups.com
Hi,
Anyone please help in this regard.
-- Forwarded me
Thanks =text(cellref,"mm") appears to be the one that works.
btw, month does not as it returns just a 3.
cheers
Colm
On Friday, April 19, 2013 2:44:29 PM UTC+2, colmkav wrote:
> Hi,
>
> what excel formula do I need to convert a date field into the month number
> like 03 for March?
>
> fo
34 matches
Mail list logo