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/*http://excelmacroworld.blogspot.com/
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)
THANKS NOORAIN
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
Dear All
Please go through the mail and help me.
Ragards,
sanjib
-- Forwarded message --
From: Sanjib Chatterjee chatterjee.kolk...@gmail.com
Date: Fri, Sep 30, 2011 at 12:15 PM
Subject: date format help
To: excel-macros excel-macros@googlegroups.com
Dear All members,
please
Dear dguillett and noorani,
I don't want to remove double I want show that and copy in other sheet. for
removing I use Alt +AM
Thanks Regards
Anil
--
--
Some important links for excel users:
1. Follow us
Hello suman,
thanks for reply, it works and fulfill my needs. but not that way I want. If
you have better
Idia plz send me.
Thanks Regards
Anil
--
--
Some important links for excel users:
1. Follow us on
Hello Dear,
I think It's work use this key Shift+Ctrl+3.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Dear Sanjib,
Please use below code as per your requirement.
*Function Date_Format(d As Date)
Date_Format = Format(d, dd-mmm-)
End Function
*
On Fri, Sep 30, 2011 at 1:19 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear All
Please go through the mail and help me.
Hi Anil,
Please find the attached sheet. here i am using countif function with if
function . and later on autofilter to draw the value of duplicate value. and
then then later on you can copy that A-Column data.
On Wed, Sep 28, 2011 at 12:46 PM, anil kumar kmr7a...@gmail.com wrote:
Hi everybody,
I seem to be missing something...
PROVIDED that your Windows Date format is dd/mm/
when you enter a string in this format, Excel recognizes it as a date.
As such, you can:
Right-click the cell(s)
select Format Cells
on the Number tab, select Date.
There SHOULD be a format at the bottom called
If ??? I understand, simply CUSTOM format the cell as dd-mm-
From: Sanjib Chatterjee
Sent: Friday, September 30, 2011 12:33 AM
To: excel-macros
Subject: $$Excel-Macros$$ date format in Excel
Dear
I like to put the date format in Excel as dd/mm/, and like to get the
output as
I don't see all of my original code here but
also give me meaning of r = Cells(Rows.Count, J).End(xlUp).Row
Excel is looking in col J for the bottom most cell, ie 22
Range(J2:J r) in above code.
Excel is using range(j2:j22)
makes little difference what r is called. could be lastrow or x or many
Dear Excel experts
I would request that if any VBA expert can help in automating some reports .
fees can be discussed over meeting . we are based in Mumbai
Regards
Jatin Agarwal
09322335208
--
--
Some
SIMPLE WAY
SELECT THAT CELLS
GO TO FORMAT CELLS
THEN
CLICK ON NUMBER--CUSTOM---
TYPE THE DD-MMM-YY IN THE TYPE FIELD
On Fri, Sep 30, 2011 at 2:28 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi PFA Solution.
On Fri, Sep 30, 2011 at 12:49 AM, Sanjib Chatterjee
You can select the date format as dd-mmm- format cell option.
On 30 Sep 2011 13:19, Sanjib Chatterjee chatterjee.kolk...@gmail.com
wrote:
Dear All
Please go through the mail and help me.
Ragards,
sanjib
-- Forwarded message --
From: Sanjib Chatterjee
Respcted Sir group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want the same cell to trimed as look as --- 25989599vvv [ i want to
remove the space in between]
is it possible with excel function.
Thanks
--
Just modify my code to this. You could also sort by site ascending with
descending dateadvance filter to uniquecopy but this is easier.
Option Explicit
Sub CopyLastDatetoothersheeetSAS()
'run from source sheet
Dim i As Long
Dim dlr As Long
On Error Resume Next
For i = 3 To Cells(Rows.Count,
I can do it from Texas at $75 hourly
-Original Message-
From: Jattin Agarwal
Sent: Friday, September 30, 2011 3:35 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel expert required .
Dear Excel experts
I would request that if any VBA expert can help in
=SUBSTITUTE(F9, ,)
From: big smile
Sent: Friday, September 30, 2011 6:54 AM
To: EXCEL MACRO GROUP
Subject: $$Excel-Macros$$ TRIM FUNCTION
Respcted Sir group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want the same cell to trimed as
That's what I do DAILY.
(currently maintining over 80,000 lines of VBA code)
If it can be done remotely, I'd be glad to help.
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
Hi Jatin
i recommend,
Krishnakumar KC
http://www.freelancer.co.nz/users/513618.html
http://www.linkedin.com/profile/view?id=14325892authType=nameauthToken=wPDQlocale=en_USpvs=pptrk=ppro_viewmore
if you are looking someone from India, even some expert from this group can
help you.
HTH
Mahesh
USE
=INDEX(INDIRECT(TEXT(D1,MMMYY)!$A$2:$A$65536),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))),ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))-MIN(ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536)))+1,),ROW(A1)))
in B8
Regards
Sam Mathai Chacko (GL)
On Sat, Oct 1, 2011 at 8:03
HI group,
This is a Great amazing group in learning excel vba..
*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)*
*Dim st As String*
*Dim sh As Worksheet*
*Set sh = Sheets(Sheet2)*
*st = Target.Address*
*sh.Activate*
*sh.Range(st).Activate*
23 matches
Mail list logo