Hi guys,
if anyone have PowerPoint VBA book, please share.
Thanks,
Maksood Alam
--
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/discussexcel
FORUM RULES
1) Use co
Hi Paul,
Thank you very much. It solved my query. [?]
Regard,
Maksood Alam
On Thu, Dec 5, 2013 at 5:59 PM, Paul Schreiner wrote:
> In your script, you have a line:
> FileName = Dir(CurrDir & "*.*", vbDirectory)
> This basically creates a "collection&q
(PathAndName)
If Filesize < 0 Then Filesize = Filesize + 4294967296#
Cells(WorksheetFunction.CountA(Range("C:C")) + 1, 3) =
Filesize
Cells(WorksheetFunction.CountA(Range("D:D")) + 1, 4) = _
FileDateTime(PathAndName)
ou received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-m
>
> Hi All,
>
> if we covert a macro file to the a different language file, let's say in
> Spanish. will the macro work in that converted laguage file?
>
>
> Thanks,
> Maksood Alam
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b
Hi All,
if we covert a macro file to the a different language file, let's say in
Spanish. will the macro work in that converted laguage file?
Thanks,
Maksood Alam
--
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 pa
Hi Guys,
I have workbook with codeing below
Private Sub Worksheet_Change(ByVal Target As Range)
*Sheets("MMPs").Unprotect "1234"*
**
If ActiveSheet.Name = "MMPs" And Target.Column = 2 Then
If Selection.Value = "F" Then
Selection.EntireRow.Interior.Color = vbYellow
ElseIf Selectio
Noorain bhai,
Need it throgh Vba Coding.
On Tue, May 7, 2013 at 6:39 PM, NOORAIN ANSARI wrote:
> Dear Maksood,
>
> Pls see attachment hope it will help to you.
>
>
> On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
>
>> Hi guys,
>&g
end date
is dynamic, I will create a form to select the start and end date.
*31-Dec*
*7-Jan*
*14-Jan*
*21-Jan*
*28-Jan*
*4-Feb*
*11-Feb*
*18-Feb*
Thanks
Maksood alam
--
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
Hi ashish,
Thanks your very much, it solved my query.
On Sat, Mar 30, 2013 at 10:03 AM, ashish koul wrote:
> try the attachment .. see if it helps
>
>
>
> On Fri, Mar 29, 2013 at 10:37 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Hi all
>>
>>
Hi all
please send me the code to attach a file in outlook and send it to
respective email address.
Thanks
Maksood alam
--
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
Hi Aju,
Could you please share the coding part also.. so we can learn.
On Thu, Jan 17, 2013 at 10:10 AM, Aju Chacko wrote:
> Please see the *Reconciliation Tool *attached herewith,Which is an *
> EXCEL-ADDIN* created by me.Which very useful for Handling large excel
> database. This utility has
Please try
=TEXT(TEXT(A2,"hh:mm")-TEXT(B2,"hh:mm"),"hh:mm")
On Wed, Oct 3, 2012 at 6:33 PM, Chandra Shekar wrote:
> Hello,
>
> Could you please help me in the attached file.
>
> Thanks in advance.
>
> Regards,
>
> Chandra Shekar B
>
>
>
> --
> Join official facebook page of this forum @
> https
confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegr
don don don, i did't find it thats why am asking, why u take all the
thing in wrong way.
On 9/7/12, dguillett1 wrote:
> Is there some reason you cannot “google” it yourself
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
&
Hi Rajan
Please provide the link to download
*Excel function and formulas by Berend held*
On Fri, Sep 7, 2012 at 7:24 PM, Rajan_Verma wrote:
> *Google and Download this book*
>
> * *
>
> *Excel function and formulas by Berend held*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838
1 Step -1
>> If IsNumeric(Mid(strText, lngLen, 1)) Then
>> lng = lng + 1
>> If lngLeaveDigits < lng Then
>> Mid(strText, lngLen, 1) = "*"
>> End If
>> End If
>> Next
>>
;
>
> On Fri, Sep 7, 2012 at 10:52 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Paul,
>>
>> I want excel function solution.
>>
>> On Fri, Sep 7, 2012 at 10:21 PM, Vabs wrote:
>>
>>> superb answer sam..
>>>
>>>
Chacko
>>
>> On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786ma...@gmail.com> wrote:
>>
>>> Partially correct, but it show as per below
>>>
>>>*Numbers*
>>> *Required out put*
>>> 555-55-5505
>>> ***-***-5505
>&
see attached file.
>
> =RIGHT(SUBSTITUTE(A1,"-",""),4)
>
> Regards,
> Kuldeep Singh
>
>
> On Fri, Sep 7, 2012 at 8:38 PM, wrote:
>
>> **
>> First use Substitue fn to subst "-" with "" and then use Right function.
>>
s one.
>
> =RIGHT(A1,4)
>
> Regards,
> Kuldeep Singh
>
> On Fri, Sep 7, 2012 at 8:15 PM, maksood alam <786maks...@gmail.com> wrote:
>
>> Hi Guys,
>>
>> Below are the number i want to show only last four digit of the numbers
>> and rest of all should be &q
Hi Guys,
Below are the number i want to show only last four digit of the numbers and
rest of all should be "*", please provide me the solution.
*Numbers*
*Required out put*
555-55-5505
***-***-5505
555-55-125-0
***-**-***-*
555-55--23
***-**-**55-23
--
Join official faceb
Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *maksood alam
> *Sent:* 04 September 2012 11:47
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ need tool for automation
>
> ** *
Hi Gusy,
Please provide some website from where i can download automated tool for
excel.
Thanks
Maksood alam
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread
s://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may
Thanks Noorain bhai.. its solved my qurey..
On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI wrote:
> See attachment for more clarity
>
> On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Hi experts,
>>
>> I have data in once she
cannot send any attchment due to system restrictions.
On Tue, Aug 28, 2012 at 8:20 PM, ashish koul wrote:
> can you send us the attachment
>
>
> On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Hi experts,
>>
>> I have data
Hi experts,
I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
B). In 2nd sheet i want a formula if i enter 20 its should show me the name
of all the candidate who has 40 marks in 1st sheet. can it done with array
forumla. please help.
*Name* *Marks CT-1* SOMERSET
ed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, s
ver post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
d Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypa
signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To
-
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
--
Thanks & Regards
Seraj Alam
*+91 989 130
--
Thanks & Regards
Seraj Alam
*+91 989 130 1776*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may
res are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group
ormula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, foru
e
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums com
mula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the respo
-
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Thanks & Regards
Seraj Alam
*+91 989 130 1776*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Ne
Hi
U can try below code also...
Sub Rename_sheet()
Sheets(2).Activate
ActiveSheet.Name = "Sheet ka name Change hua"
End Sub
On Mon, May 14, 2012 at 11:56 AM, hilary lomotey wrote:
> tnks boss
>
>
> On Mon, May 14, 2012 at 5:44 PM, Seraj Alam wrote:
>
>> H
Hi Expert,
I have attached sheet in which I need total time taken in column C, I have
applied formula but its not working properly. So please help me on this one.
--
Thanks & Regards
Seraj Alam
*+91 989 130 1776*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use con
n't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.co
hread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowled
-----
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Thanks & Regards
Seraj Alam
9891301776
--
FORUM RULES (986+ members already BANNED for violation)
1) Use conc
superb noorain bhai.
2012/3/22 NOORAIN ANSARI
> जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
> जहाँ Question,Answer करने की,है खूब आज़ादी.
> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया.
> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गया.
> चाहे
Congrats noorain bhai.
[?][?][?][?][?]
On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has be
Hi,
Please find below link to hide formula in spreadsheets...
http://www.techonthenet.com/excel/cells/hide_formulas.php
Thanks
Seraj
On Sun, Mar 11, 2012 at 4:57 PM, ashjain2...@yahoo.co.in <
ashjain2...@yahoo.co.in> wrote:
> Dear Team
>
> I use many formulas in the excel sheet and i want th
Please find below link for how to creat pivot table on multiple sheet...
http://www.youtube.com/watch?v=ZBn1-r0I5oE
On Sat, Mar 10, 2012 at 10:40 AM, Mohammed Muneer wrote:
> Dear Group Plz, tell me how I can use it? And for what purpose?
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,***
Hi,
See attached...is that what u want..?
Suggest...
On Thu, Mar 8, 2012 at 2:05 AM, Gulam Hameed wrote:
> Dear All Experts…..!!
>
> ** **
>
> WISH U ALL EXPERTS HAPPY HOLI……!!!
>
> ** **
>
> Can some help me out please find attach example sheet
>
> ** **
>
> Thanks & Best Rega
Hi,
See attached...is that what u want..?
Suggest...
On Thu, Mar 8, 2012 at 2:05 AM, Gulam Hameed wrote:
> Dear All Experts…..!!
>
> ** **
>
> WISH U ALL EXPERTS HAPPY HOLI……!!!
>
> ** **
>
> Can some help me out please find attach example sheet
>
> ** **
>
> Thanks & Best Regard
Hi,
In 200 version u can use only 7 if condition however in 2007 and later
version u can use 64 if condition...
Thanks
seraj
On Tue, Mar 6, 2012 at 8:14 PM, Ashish Bhalara wrote:
> Dear expert,
>
> If function used maximum 7 time in an function, if the requirement of
> condition if is more th
Hi,
Please find below link to join this group.
http://groups.google.com/group/excel-macros
On Mon, Mar 5, 2012 at 7:50 PM, Mohammed Muneer wrote:
> Dear Friends,
>
> ** **
>
> I want to subscribe this group with another mail id not Outlook –
> munnu130134...@gmail.com
>
> ** **
>
Hi,
Please try this with Ctrl+shift+enter
=INDEX($B$3:$B$11,MATCH(LARGE(IF($A$3:$A$11=$E$3,$C$3:$C$11,""),1),$C$3:$C$11,0))
On Wed, Feb 29, 2012 at 11:40 AM, dguillett1 wrote:
> Is this “homework” for an excel class?
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* M
Hi,
You can also try this one
=SUMPRODUCT(($A$1:$A$5=A7)*($B$1:$B$5))
Thanks
Seraj Alam
On Tue, Feb 28, 2012 at 10:24 AM, finos wrote:
> Dear groups
>
> ** **
>
> How can take the multiple values from the database using vlookup formula
> . can u guide me .
Please try this
=IF(B1="Y",TODAY(),"")
On Mon, Feb 27, 2012 at 7:55 PM, Mohammed Muneer wrote:
> Dear Friends have a nice day,
>
> ** **
>
> I have a small question.
>
> ** **
>
> For example, I have two cols A and B as shown below one is for date & the
> other have letter “Y”.**
On Wed, Feb 15, 2012 at 8:58 PM, Seraj Alam wrote:
>
>1. Select the whole table with data
>2. Choose the command Format | Conditional Formatting
>3. Choose Formula is
>4. Write in following formula: =MAX($A$1:$A$13)=A4 where A4 is the
>first cell with data
1. Select the whole table with data
2. Choose the command Format | Conditional Formatting
3. Choose Formula is
4. Write in following formula: =MAX($A$1:$A$13)=A4 where B4 is the first
cell with data
5. Create the wanted format
6. Close the form
On Fri, Feb 10, 2012 at 6:02 AM
congrates noorain bhai
On Wed, Feb 1, 2012 at 9:31 AM, chandra sekaran wrote:
> Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett, Kris,*are a
> player, Each & every one contribution great .
> chandru
>
> On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote:
>
>> Hello Everyon
Hi Ravinder,
Please attach the sheet...
On Tue, Dec 20, 2011 at 8:10 AM, Abhishek Jain wrote:
> Which test?
>
>
> On Mon, Dec 19, 2011 at 12:19 PM, Ravinder Negi wrote:
>
>> For Excel Beginner, please try this test...and enhance your
>> skills..
>>
>> --
>> FORUM RULES (934+ members already
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on fa
m
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> L
Hi,
Just try it..
=SUMPRODUCT(--($A$1:A10=A1)--($A$1:A10=A2)*(B1:B10=B1))
On Thu, Sep 15, 2011 at 9:09 AM, ArtySin wrote:
> Hi
> I have two columns as below using Excel 2000 (unfortunately, corporate
> no spend policy): These columns have been exported from a database and
> appear as the exa
जो मुरझाये ना कभी वो कवल है दोस्ती.
दिल के पवित्र ख्यालों की पहल है दोस्ती.
दोस्ती दोस्तों के दम से निभाई जाती है,
मिले आप जैसे दोस्त तो सफल है दोस्ती.
खुदगर्ज दोस्त हो तो गन्दी नाली है दोस्ती,
सच्चे दोस्त के खातिर गंगाजल है दोस्ती.
रिश्तों में सबसे ऊँचा दर्जा है दोस्ती का,
थोड़ी शोख,थोड़ी नटखट, थोड़
Hi Ashish,
Many many congrats...
With best wishesh,
Seraj Alam
On Mon, Jul 4, 2011 at 9:40 PM, Hari wrote:
> Thanks for getting the award. Even though, i am very new to this group,
> I proudly wishes to keep this spirit high always,
> Have a nice day
>
> with best wishes
Hi!
FIND OUT DRPODOWN LINS
AFTAB
On Thu, Sep 23, 2010 at 3:08 PM, Kal xcel wrote:
> Dear expert,
>
> I am facing a problem to create dependent dropdown list.
>
> Please check the attached file & help.
>
> Thanks in advance
>
> Kalyan
>
> --
>
> --
dear all
plz find an enclosed files
aftab ali
On Sat, Sep 18, 2010 at 5:00 PM, Vinod N wrote:
> Hi Janet,
>
> Please enter the date in Excel recognizable format i.e., mm/dd/ instead
> of dd/mm/. Then days can be calculated with the formula you have already
Dear all,
I want to make complete Attendance sheet in excel format and
other application or S/w. like FoxPro/ c++ /V.B.
Note:--
1. I have three sheets in excel format ( *Hide File, Attendance
Sheet, Output*)
2. Two sheets (*Hide file and Output*) are *Hide
On 8/19/10, None wrote:
>
> Dave,
>
> Can I trouble you for an example? I'm not sure how the COUNTIF would work
> here. Thanks.
>
>
> --
> *From:* Dave Bonallack
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Wed, August 18, 2010 7:34:17 PM
> *Subject:* RE: $$E
Dear all,
Solve my poblems
Note:- I want to all details in excel sheet (like *NAME
IN-TIME DATE
) *JUST CLICK OF *EMP ID*.
ALSO WE ENCLOSED EXCEL SHEET FOR ALL OF U
--
Regards&Thanks,
AFTAB ALI
9310903589
--
-
Deat all,
pls solve my problems.
1. excell files export in Access files and import also.
2. How can make a attandence record attomaticaly in excel files.
we have 10 employee details and i want to make a Att. sheet
in
excel according to
DEAR ALL,
I WANT TO MAKE A MIS REPORT OF ATTANDANCE AS PER DATED.
REG
I WANT TO DETAILS ACCORDING TO EMP-ID, JUST FOR SELECTED
IMP-ID
PLS FIND AN ENCLOSED FILES
--
Regards&Thanks,
AFTAB ALI
9310903589
--
---
Dear all,
pls find an enclosed files..
I want to details in excel formate, for mis as per dated.
just click every id,
--
Regards&Thanks,
AFTAB ALI
9310903589
--
--
Some important
-- Forwarded message --
From: ALAM
Date: Aug 10, 2010 1:47 PM
Subject: FOR EMP DETAILS
To: excel-macros@googlegroups.com
DEAR ALL,
I WANT TO DETAILS FOR ALL EMP,
1, I WANT TO ALL DETAILS, JUST PUNCH OF ANY ID NO.
PLS FIND OUT ATTACHMENT FILE...
--
Regards
DEAR ALL,
I WANT TO DETAILS FOR ALL EMP,
1, JUST PUNCH ID NO.
PLS FIND OUT ATTACHMENT FILE...
--
Regards&Thanks,
AFTAB ALI
9310903589
--
--
Some important links for excel users:
1. Follow u
hi!
starting from into..
then 1. Lookup (a,b,c)
2. validations
3. More VBA
4. Reports sheets (day/wk/month/year)
5. filter
6. list
7. subtotal
AFTAB ALI
On 7/9/10, saggi wrote
THANKS
On 6/29/10, ayush jain wrote:
>
> Hi Nadine,
>
> You may also use mid function as *=MID(A2,9,LEN(A2)).*
>
> Also, your message posting is moderated. Hence your post will not appear
> immediately in group. It may take 3-10 hours for message to get approved.
> Let me know if any further assi
Really it's wondering Amazing.
On 11/25/08, Sunita Paudel <[EMAIL PROTECTED]> wrote:
>
> m shocked this type of ppl also here in this group !!
>
>
>
> -- Forwarded message --
> From: Sunita Paudel <[EMAIL PROTECTED]>
> Date: Nov 18, 2008 9:20 AM
> Subject: Re: Abt macro
> To: Sha
you can moved data in a single coloumn thourh the excel function
"Concatinate"
Use this one.
Regards.
On 11/19/08, TerryP <[EMAIL PROTECTED]> wrote:
>
>
> I have data in multiple columns like this :
> http://spreadsheets.google.com/pub?key=pD3DJDAymrEspkRfQWMOTUg
>
> I'd like data moved to one s
just double click to the particular data and select as needed and ctrl+C
as same go the desrable area where they want to paste same process d. click
and paste.
On 10/19/08, Mattathil M. Pradeep <[EMAIL PROTECTED]> wrote:
>
> Dears..
>
>
>
> How to copy particular data from one cell ? attached
79 matches
Mail list logo
