$$Excel-Macros$$ PPT

Hello, I am looking for a macro which can copy slides based on TITLE and create a new presentation. Could u please help me out in the attached file. In this case I need create 4 PPTs i.e. for 1) Title A one PPT with same file name as Title, 2) Title B one PPT with same file name as Title, 3) Titl

Re: $$Excel-Macros$$ date format in Excel

Dear Sanib Da, Please use below formula and see attached sheet. * =TEXT(MID(A2,FIND("/",A2,1)+1,2)&"-"&LEFT(A2,FIND("/",A2,1)-1)&"-"&RIGHT(A2,LEN(A2)-FIND("/",A2,FIND("/",A2,1)+1)),"dd-mmm-") * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Fwd: $$Excel-Macros$$ date format in Excel

Dear all members please help to solve the problem Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Fri, Sep 30, 2011 at 11:03 AM Subject: $$Excel-Macros$$ date format in Excel To: excel-macros Dear I like to put the date format in Excel as "dd/mm/", and like t

Re: $$Excel-Macros$$ find doubling

Dear Anil, Please use simple Macro *Sub remove_duplicate()* *Dim s As Range Sheet1.Range("A2:A" & Application.WorksheetFunction.CountA(Range("A:A"))).Select Selection.RemoveDuplicates 1 End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ FW: How to remove the duplicate value

Dear Neeraj, You can also use Data->Remove Duplicates in 2007 and Advance Filter to remove duplicate. with formula you can use.. =sumproduct(--($C$2:C2=c2)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain

Re: $$Excel-Macros$$ Create worksheet from list

Dear Airen, r = Cells(Rows.Count, "J").End(xlUp).Row it is use to find last non-blank row in J Column. Searching Start from Excel End. On Thu, Sep 29, 2011 at 7:35 PM, airen wrote: > Hi dguillett, > Also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row " > Thanks > > -- > > -

Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

Dear John, For 7 Minute you can use..format =TEXT(I21-H21,"[h]:mm:ss") for number format use (I21-H21) and paste in Custom FOrmat [h]:mm:ss -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* <

Re: $$Excel-Macros$$ Ebooks for Pivot Table and Chart

Dear Nalini, See attached sheet if it help to u. On Thu, Sep 29, 2011 at 6:23 PM, N Pradhan wrote: > ** > Dear Noorain Sir, > > I am having some problem in the attached pivot. > > I want a calculated field (count of name - count of absent) which is > non-numeric > > Please solve. > > Thanks > >

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

Dear Paul, please do the needful thanks & regds ROHAN On Wed, Sep 28, 2011 at 11:31 AM, Rohan Young wrote: > Dear Paul, > > one more thing your indirect formula is not working in master sheet, > would u please explain > > thanks & regds > > On Tue, Sep 27, 2011 at 6:50 PM, Paul Schreiner > w

Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

(d2-c2)*24*60 ...change format to number Regards Chethan Kumar On Fri, Sep 30, 2011 at 1:36 AM, dguillett1 wrote: > =(D2-C2)*24 > > *From:* John A. Smith > *Sent:* Thursday, September 29, 2011 2:55 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Incremental Time Ca

$$Excel-Macros$$ MS EXCEL 2007 and Significance Testing

I have data from two surveys. One survey was completed on 900 people before a certain event happened, and then a second survey was completed on a further 900 people after an event happened. I need to calculate the % difference between the two whilst looking at the demographics of the individuals.

Re: $$Excel-Macros$$ Create worksheet from list

Hi dguillett, Also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row " Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyti

Re: $$Excel-Macros$$ Create worksheet from list

Hi dguillett, I am a learner, could you please tell me meaning of "& r" in Range("J2:J" & r) in above code. Thanks Akhilesh Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks a

Re: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

=(D2-C2)*24 From: John A. Smith Sent: Thursday, September 29, 2011 2:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format Excel Experts, I need to calculate the time differences between 11:30:00 AM and 11:37:00 A

$$Excel-Macros$$ Incremental Time Calculation from 11:30:00 AM Time Format

Excel Experts, I need to calculate the time differences between 11:30:00 AM and 11:37:00 AM and show the 7 minutes in the decimal hour format. Please see attached sample spreadsheet for the solution I need. Thank you for your continuing Excel help. John --

Re: $$Excel-Macros$$ Audit Trail

Hi Paul, thank you again!!! It works perfectly:) Best regards, seba On 29 sep., 15:32, Paul Schreiner wrote: > Evidently, the Target array doesn't start at '0' like normal arrays! > > change the loop to: > For inx = 1 To Target.Count > > and it should work just fine. >   > Paul > -

Re: $$Excel-Macros$$ Create worksheet from list

Haven’t followed this so Send your file with a complete explanation and before/after examples to dguille...@gmail.com From: Mr excel Sent: Thursday, September 29, 2011 4:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Create worksheet from list Macro 1: Option E

Re: $$Excel-Macros$$ FW: How to remove the duplicate value

Save file as an xlsM file and enable macros and use Option Explicit Sub nodupesperitemSAS() Dim i As Long For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If Cells(i, "d") = Cells(i - 1, "d") Then Rows(i - 1).Delete Next i End Sub From: Neeraj Chauhan Sent: Thursday, September 29, 2011 2

Re: $$Excel-Macros$$ Ebooks for Pivot Table and Chart

Dear Noorain Sir, I am having some problem in the attached pivot. I want a calculated field (count of name - count of absent) which is non-numeric Please solve. Thanks N Pradhan - Original Message - From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, Septem

Re: $$Excel-Macros$$ Audit Trail

Evidently, the Target array doesn't start at '0' like normal arrays! change the loop to: For inx = 1 To Target.Count and it should work just fine.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you ca

Re: $$Excel-Macros$$ find doubling

This will remove the duplicates. If you have xl2007 you could use the remove duplicates Sub advancedfilterunique() lr = Cells(Rows.Count, 1).End(xlUp).Row With Range("A1:A49") .AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range("b1"), Unique:=True .Delete Shift:=xlUp End With Columns(1).De

Re: $$Excel-Macros$$ Hijacked Thread

Hi Paul, I just took the your code above: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim inx Dim strFileName As String strFileName = "MyLocation\MyFile.txt" 'Chan

Re: $$Excel-Macros$$ Audit Trail

Interesting... Can you please post the code you're using? (at least for the loop)   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

Re: $$Excel-Macros$$ Computer moving average hrs of play per day

Send your file with a complete explanation and before/after examples to dguille...@gmail.com -Original Message- From: Ken Sent: Wednesday, September 28, 2011 1:03 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Computer moving average hrs of play per day I have a spreadsheet

$$Excel-Macros$$ Hijacked Thread

Amresh, If you have a question, please post a NEW discussion thread instead of hijacking another discussion.   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

Re: $$Excel-Macros$$ Audit Trail

Guys, you have any presentation ppt on internet.if you have pls send me.. Regards Amresh On Thu, Sep 29, 2011 at 5:40 AM, Seba wrote: > Hi Paul, > > thank you very much for aour effort. There is just one thing: I paste > 2 values in S14 and S15 and the macro records values in S13 and S14. > >

Re: $$Excel-Macros$$ Audit Trail

Hi Paul, thank you very much for aour effort. There is just one thing: I paste 2 values in S14 and S15 and the macro records values in S13 and S14. Cold you please help. regards, seba On 29 sep., 14:15, Paul Schreiner wrote: > The trick here is knowing that when target.count > 1, then the Targ

Re: $$Excel-Macros$$ Very tuff macro

Hi Mahesh, Thanks for your reply. I have added extra numbers below that. And this macro is not accepting. And also is it possible to make the matching cells as one color instead of moving to next column. /Suresh On Thu, Sep 29, 2011 at 1:19 AM, Mahesh parab wrote: > Hi Suresh > > find attach

Re: $$Excel-Macros$$ Audit Trail

The trick here is knowing that when target.count > 1, then the Target Range becomes an array. So, to get the cell address and values, you have to loop through the array.. like: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)     Dim inx     Dim strFileName As String   

Re: $$Excel-Macros$$ Create worksheet from list

*Macro 1:* Option Explicit Sub ExtractReps() Dim ws1 As Worksheet Dim wsNew As Worksheet Dim rng As Range Dim r As Integer Dim c As Range Set ws1 = Sheets("Sheet1") Set rng = Range("Database") 'extract a list of Sales Reps ws1.Columns("C:C").AdvancedFilter _ Action:=xlFilterCopy, _ CopyToRan

$$Excel-Macros$$ Audit Trail

Hi all, I need to setup a Audi Trail system for my excel workbooks and I found this code on the net by google search. - Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim strFileName As String strFileName = "Location\fil

$$Excel-Macros$$ How to Open password protected file

Hi All, I have got a file for which I have the password but when I click on the file, it does not show me the "password pop-up". Password: assets Kindly Suggests. Regards Mukesh Maurya -- -- Some important links f

Re: $$Excel-Macros$$ Re: find doubling

Hi hamal, Use can use filter if it help to you……. Ctrl+Shift+L -> drop filter -> *filter by color* -> *filter by cell color *-> Press enter. Regards, Brajesh On Wed, Sep 28, 2011 at 5:39 PM, hemal shah wrote: > If you have excel 2007 then follow the following procedure > > Select the your