Please check out following links.
http://www.mrexcel.com/tip083.shtml
Regards,
Mudassar Ramzan
- Original Message -
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent: Monday, June 01, 2009 7:52 PM
Subject: $$Excel-Macros$$ Re: SUMIF for multiple conditions
Hi Ni
Hi,
You can use sumproduct formula as below :
=SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
it's give the same result ...
On Jun 1, 7:52 pm, Dilip Pandey wrote:
> Hi Nidhesh,
>
> Excellent criteria.
> I have attached one file which can be of interest for you.
>
> Note:- If you need some
hi,
use this code in Worksheet_Change
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Target.Value = Left(Target.Value, 25)
End If
End Sub
Regards
bala
On Jun 1, 2:44 pm, manish gupta wrote:
> Hi Bala,
> Thank you for helping me in this matter,it is working
Hi there,
In arrays the tip is that you should press Ctrl+Shift+Enter together to get
the result as an array. Try for example MMULT formula...
On Sat, May 30, 2009 at 6:39 PM, anil kumar wrote:
> Hi All,
>
> First of all i would do the thanks to all the member those are associated
> with this
Hi,
What Information do you need to display on chart?
2009/5/31 god is gr8 i love u
> hi
>
> I want to make charts on excel data
> but i am not able to do that
> here i want to show chart with average
>
> plz help me
> i m sending file along with this mail
>
> plz help me
>
>
> regards
>
> ruc
Hi
Maybe I'm not using the right search terms, but I couldn't locate how
to import over 100 small files into Excel. Each file should get it's
own worksheet. And each worksheet should be name with the 3rd "word"
or character string in the file. In case someone is wondering, the
total number of
Hi, there is another way... look at column G.
2009/6/1 Mathan
>
> Hi find the attachment . I tried as much as i can.
>
> mathan
>
>
> -- Forwarded message --
> From: satish
> Date: May 29, 2009 2:47 PM
> Subject: $$Excel-Macros$$ hi
> To: excel-macros@googlegroups.com
>
> Hey Pe
IF you want to convert files to PDF, you should use the PrimoPDF (it's a
freeeware).
Regards
2009/6/1 Subu
>
> As expected, the Rapidshare links are not working for free users...
>
> Are there any alternate downloads ?
>
> regards
> subu
>
> On Jun 1, 11:00 am, "Mudassar Ramzan" wrote:
> > Dear
Hi
thanx a tonn..
Regards
ruchi
On Mon, Jun 1, 2009 at 8:01 PM, Dilip Pandey wrote:
> Thanks Subu..!!
> And one thing I would like to mention here... that we are not doing any
> favour to the users.. Actually we are helping ourselves to learn and
> develop.
>
> Thanks to all great people
Dear Mahesh,
Please go through the links below:
http://www.ozgrid.com/Excel/run-macro-on-time.htm
http://www.brainbell.com/tutorials/ms-office/excel/Run_A_Macro_At_A_Set_Time.htm
Please let me know if it helps.
Regards,
Andy
On Mon, Jun 1, 2009 at 11:06 PM, mahesh parab wrote:
> Dear All
>
Dear All
Any one knw how to set time for macro or run at speacified time, if any one
have sample sheet
please send it to me.
Thank You
--~--~-~--~~~---~--~~
-
Some important lin
Hi Nidhesh,
Excellent criteria.
I have attached one file which can be of interest for you.
Note:- If you need some more examples, then please let me know.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
O
plz replyyy
On Mon, Jun 1, 2009 at 7:13 AM, mayank khare wrote:
> Hai,
> I want to learn indepth excel macros.
> Plz tell the resource to learn this.
> I do not know any language ie Visual Basic ,which i know is required to
> write a macro.
> Plz guide me.
>
> --
> Warm Regards
> Mayank Khare
>
Dear All!
Please find below new link. Easy to download as per my
knowledge. If some one knows the better one then pl let me know.
http://www.4shared.com/file/109162436/7d544124/Able2Extract1Professionalv6000_Cracked.html
Regards,
Mudassar Ramzan
- Original Message -
F
I was going this route because of the autocomplete capabilities. I
should have mentioned that in my post. Any ideas as to how I can do
this would surely be appreciated.
Thanks,
Steve
On Jun 1, 8:08 am, norie wrote:
> Steve
>
> Why not just use Data>Validation... with the List option?
>
> On
Hai,
I want to learn indepth excel macros.
Plz tell the resource to learn this.
I do not know any language ie Visual Basic ,which i know is required to
write a macro.
Plz guide me.
--
Warm Regards
Mayank Khare
--~--~-~--~~~---~--~~
Hai,
I want to learn indepth excel macros.
Plz tell the resource to learn this.
I do not know any language ie Visual Basic ,which i know is required to
write a macro.
Plz guide me.
--
Warm Regards
Mayank Khare
--~--~-~--~~~---~--~~
Thanks Subu..!!
And one thing I would like to mention here... that we are not doing any
favour to the users.. Actually we are helping ourselves to learn and
develop.
Thanks to all great people for providing us the great queries and different
test scenarios.
Regards,
--
DILIP KUMAR PANDEY
MBA-H
As expected, the Rapidshare links are not working for free users...
Are there any alternate downloads ?
regards
subu
On Jun 1, 11:00 am, "Mudassar Ramzan" wrote:
> Dear Gaurav,
> Please download the following cracked version. Its
> working fine for me and my friends.
>
Hi find the attachment . I tried as much as i can.
mathan
-- Forwarded message --
From: satish
Date: May 29, 2009 2:47 PM
Subject: $$Excel-Macros$$ hi
To: excel-macros@googlegroups.com
Hey People
I need a small help, some of you might even find silly
I have big list of
Hi Ramesh
Try below code. File containing this code is also attached with this email
reply.
Sub Ramesh()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim i, k As Integer
Cells(1, 1).Select
For k = 1 To 256
ActiveCell.EntireColumn.Select
i = Application.WorksheetFunction.
Thanks for the quick revert Andy
I've enclosed a workbook. Not sure if the workbook makes it to the group, so
added a cc to your e mail as well
This work book has two sheets. One called Original data and another sheet
called desired results. I have made some notes on the desired results on wh
Hi Anil
You can use Index-Match, Offset-Match or VBA (Search) and SumIF (for
non-number data) instead of V-lookup and H-lookup.
Please let me know if you need a demo.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi
Hi Harmeet,
Any update on the below one. Whether this can be done through macro or not?
Please let me know am waiting for your valuable suggestion.
Regards,
Sharma
On Sat, May 30, 2009 at 4:58 PM, amrahs k wrote:
> Hi Harmeet,
>
> I have comeup with new task and I have explained the query in
Hi
The link below works well. Thanks for the same. Is there an off line
version ? i.e. instead of sending the file over the net (and being
connected all the time) is there an off line version that can be used
from one's own PC ?
Thanks in advance
Regards
Subu
>
> From: excel-macros@googlegro
'Hi Shakeel
'Try the following code:-
Sub shakeel()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim i, k As Integer
Cells(1, 1).Select
For k = 1 To 256
ActiveCell.EntireColumn.Select
i = Application.WorksheetFunction.CountA(Selection)
If i = 0 Then
ActiveCell.EntireColum
Though I did NOT send the original request, I' amazed at the level of
commitment and response from this group
Please accept my appreciate and keep up the good work
regards
subu
On Jun 1, 1:07 pm, Dilip Pandey wrote:
> Hi Ruchi,
>
> Please find attached the workbook with the solution. Technica
Steve
Why not just use Data>Validation... with the List option?
On May 31, 7:49 pm, Steve wrote:
> Hi,
>
> I've managed to get a combo box on a spreadsheet. Now I want to copy
> that combo box down in column A for a hundred and fifty or more rows
> and the linked cell to each combo box needs to
Dear Gaurav,
Please download the following cracked version. Its
working fine for me and my friends.
http://rapidshare.com/files/239495412/Able2Extract_1_.Professional.v6.0.0.0_Cracked.rar
Regards,
Mudasssar Ramzan
Cell: 0321-7325277
- Original Message -
Hi,
Try this code
Sub Test()
Range("A2").Select
While ActiveCell.Value <> ""
' For ZIP
If ActiveCell.Offset(0, 5).Value = "" Then
ActiveCell.Offset(0, 5).Value = 9
End If
' For B
If ActiveCell.Offset(0, 6).Value = "" Then
ActiveCell.Offset(0, 6).Value = 0
Hey.
thank you for looking into this...
In the top grid the days run from top to bottom. On the other grid it
goes from left to right. On monday i got persons 4,6,9,12,14 and 18 on
either morn or o-c. (open/close). On the grid below i use from that
person 6,12,18. On tuesday top grid morning peo
sample file needed
On May 29, 10:01 pm, "Abdul Shakeel" wrote:
> Hi All,
>
> I am searching for macro that hide or delete column(s) if they haven't any
> values, & if any cell in that particular column(s) have any value then we
> couldn't delete or hide the column.
>
> Regards,
>
> Shakeel
--~-
32 matches
Mail list logo
