Dear Expert,
I want to change the date format as per given below
Date
Date Want in this format
9/26/2018
Nov-18
--
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
Dear Experts,
As per Given detail how can I convert each Site ID in Row separate row
VehicleNo
SitesId
I Want this
UP23T1457
IN-1035632,IN-1035940,IN-1035968,IN-1075463,IN-1075466,IN-1081661,IN-1112678
,IN-1116387
IN-1000446
UP23T1457
IN-1035632,IN-1035940,IN-1035968,IN-1075463
Thanks Ganesh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ganesh N
Sent: Wednesday, 5 March 2014 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Record Macro to Filter out blanks
Hi Elaine,
Replace with Criteria1:="<>"
com [mailto:excel-macros@googlegroups.com]
On Behalf Of RicardoR
Sent: Wednesday, 5 March 2014 9:22 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA to change number
Hi elaine chong,
See attached this example
Basole.
2014-03-04 21:32 GMT-03:00 Elaine gm
Dear Ashish
It works well and produced the 3 PDF files into the folder created. But
there are 2 problems.
1. It will still says macro error and debug will bring me to the
highlighted
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Soa\" &
CL.Value & ".pdf", Qualit
ch sooner.
>
> Hope this makes sense to you.
>
> Cheers!
>
> AJ
>
> On Thu, May 2, 2013 at 9:30 AM, pankaj gmail account > wrote:
>
>> in VBA Form.
>>
>> Regards,
>> Pankaj
>>
>
> Dear Priti,
>
> I want user restriction in E
in VBA Form.
Regards,
Pankaj
On Wed, May 1, 2013 at 4:30 PM, ravinder negi wrote:
> please give more detail with example file so we can understand properly
> whether you want this in VBA for or normally in excel sheet.
>
>
> --- On *Wed, 5/1/13, pankaj gmail account * wrote:
>
nter into
> columns of name. am i right or not.
> Regards,
> Priti verma
>
>
>
> On Wed, May 1, 2013 at 2:30 PM, pankaj gmail account > wrote:
>
>>
>>
>> ------ Forwarded message --
>> From: pankaj gmail account
>> Date: Sat, Jan 5, 20
-- Forwarded message --
From: pankaj gmail account
Date: Sat, Jan 5, 2013 at 9:10 AM
Subject: Mandatory Cell Entry
To: excel-macros@googlegroups.com
Dear Gurus
I want to make a excel data entry form in which i want some cells to be
mandatory and some can be left out. But with
Dear Gurus
how can i create Curve bell Graph with this data.
Month - Failure in Month
Year - Failure in Year
Month Yr -2007 2008 2009 2010 2011 2012 2013 1 6 4 1 2 1 1 2 12 7 3
5 9 43 11 7 3 8 4 144 18 12 11 7 12 65 12 12 4 3 8 7 1 6 15 11
7 9 7 13 2 7 13 9 6 10 5 5 1 8
Dear Gurus,
Please suggest ideas to hide/restrict data viewing in excel data sheets
version 2007/2010.
using VBA also.
blocking right click, copy/paste, printing, saving, copy file, not able to
view formula's etc.
--
Thanks
Pankaj Kumar
9910075248
--
Thanks
Pankaj Kumar
9910075248
--
Ar
Dear All,
Pleae help to resolve the query.
DEar Prince
Please check
On Tue, Jan 15, 2013 at 12:40 PM, pankaj gmail account wrote:
> Dear Gurus
>
> Please help.
>
> Regards,
> Pnkaj
>
> On Thu, Jan 10, 2013 at 5:10 PM, Prince wrote:
>
>> Ok Pank
Dear Gurus
Please help.
Regards,
Pnkaj
On Thu, Jan 10, 2013 at 5:10 PM, Prince wrote:
> Ok Pankaj
> i can only reply in evening.
>
> regards
> Prince
>
>
> On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote:
>
>> Don't use differnt mails.
>>
>> REgards,
>> Pankaj
>>
>> On Thu, J
I have not received any answer.
Regards,
Pankaj
On Tue, Jan 8, 2013 at 7:56 PM, pankaj gmail account
wrote:
> Dear Prince and Lalit Thanks for response.
>
> what i wanted in a excel file:-
>
> Student ID Class SubjectMarks(Mandatory)
> 123
Don't use differnt mails.
REgards,
Pankaj
On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H wrote:
> Hi Prince,
>
> Its not working.
>
> Can you send me example with this formula.
>
> Rgds,
> Prabhakar
>
> On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote:
>
>> yes it is possible, pleas
Dear Prince and Lalit Thanks for response.
what i wanted in a excel file:-
Student ID Class SubjectMarks(Mandatory)
123 V Maths
345 V Maths
123 V English
456
Dear Gurus
I want to make a excel data entry form in which i want some cells to be
mandatory and some can be left out. But with sequence
Like
Name (Mandatory)
Address (Mandatory)
Phone ( not mandatory)
*first field entry should be name, he cannot move to phone directly until
name is filled. is
Good Quiz Keep it up.
Hope more quizes.
Pankaj Michel
On Tue, Nov 13, 2012 at 11:59 PM, Ayush Jain wrote:
> Dear group,
>
> Thanks for your participation in the quiz. There was very good response to
> the quiz from the members of this forum.
>
> Excel quiz : 250 responses
> VBA quiz : 228 resp
Thanks
On Sun, Oct 14, 2012 at 7:19 PM, SUDHIR VERMA wrote:
> thankx for sharing
>
>
>
> On 14 October 2012 10:23, Nikhil Shah wrote:
>
>> Hi
>>
>> Thanks for sending excellent file,
>>
>> (1). Prince Formula Bible (Updated Version)
>> (2). Updated Lets Learn Together ( Macro Bible )
>> Can you
Dear All,
Please guide hw to Debug VBA Programs
Regards
--
Pankaj Kumar
--
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 titles. Poor thread titles, like Please Help
Any Suggestions
outlook is open but excel 2007 is closed.
Regards
Pankaj
On Fri, Jul 27, 2012 at 4:28 PM, Pankaj wrote:
> Dear Gurus,
>
> Can we create a macro or how can we send mails if my excel book is closed.
>
> like i have data:--
>
> Name Email IDDate
AM, wrote:
> **
> Hi Pankaj,
>
> Its an appreciation given to group members for helping.
>
> Correct me Ayush if I am wrong.
>
> Thanks,
> Joseph
> Sent on my BlackBerry® from Vodafone
> --
> *From: * pankaj gmail account
> *
These kind of Congratulating etc
Regards
Pankaj
On Wed, Jul 4, 2012 at 10:20 PM, Bé Trần Văn wrote:
> I just want to congratulate Ashish and Dilip.
> and contributions that you want two more forums.
>
> 2012/7/4 Ayush Jain
>
>> Pankaj,
>>
>> Please let me know which advertisements you are refer
Dear Moderator,
Please also Ban these kinds of Promotional/Advertisements in this forum.
They are not related to Excel Help.
Please advice
Thanks and Regads,
Pankaj Michael
On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote:
> Dear members,
>
> I am extremely happy to inform you that two memb
It is very Helpful -- Thank you for sharing Please upload more examples of
Dashboards.
Regards,
Pankaj Michael
On Fri, Feb 10, 2012 at 12:46 AM, wrote:
> Its just historical stock market information for the Ghana stock exchange
> and major mkt indicators. But its the idea behind in tht u can
oorain,
>>>> In one of your Dashboard sample file (DASHBOARD REPORT-BROKERAGE-V2.5)
>>>> all the sheets are hidden but links are working, can you please explain how
>>>> to create this kind of file.
>>>> Thanks in advance.
>>>>
>>>
Thanks You both Really they are great.
We should share more sample Dashboards in Excel
Regards
Pankaj Michael
On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay wrote:
> Thanks Noorain for sharing such nice examples..!!!
>
>
>
> On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI
> wrote:
>
>> PFA
>>
Dear All,
Please share Dashboard Examples/Templates
I already viewed Chandoo's Site so no reference to that site.
--
Pankaj Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formu
Hi To All,
I also agree that we should also think about Job Posting in this forum.
If a Needy gets Job with our help that's the best result of the forum.
OK I also agree that this is not a Job Forum but instead of joining other
Job forums we should think some alternative like we can use some Mand
ple data
>
>
> On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account <
> pankaji...@gmail.com> wrote:
>
>> Dear Gurus,
>>
>> I want to create a chart with click event or any other option.
>>
>> Please suggest :-
>>
>> like if i have a
Dear Gurus,
I want to create a chart with click event or any other option.
Please suggest :-
like if i have a bar/pie chart with five products with some sale so i gets
five product bars.
what i wants is when i click on product 2 bar i should get/open product 2
sales charts linked to it go on fur
This link is also not working.
Pankaj
On Sun, Oct 23, 2011 at 8:01 PM, ashish koul wrote:
> http://www.susandoreydesigns.com/software/WordVBATechniques.pdf
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
> --
link is not working
Pankaj
On Sun, Oct 23, 2011 at 9:24 PM, ashish koul wrote:
>
> http://www.susandoreydesigns.com/software/AccessTechniques.pdf
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
> --
>
> ---
ttp://akoul.blogspot.com/2011/07/sending-birthday-images-messages-to.html
>
> try the attachment
>
>
> On Mon, Aug 22, 2011 at 8:21 PM, dguillett1 wrote:
>
>> Sounds a bit like “homework”
>>
>> *From:* pankaj gmail account
>> *Sent:* Sunday, August 21, 2011 11
Please forward same to me also
Thanks Pankaj
2011/8/20 Venkat CV
> You are welcome
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *
> *
> On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn wrote:
>
>> Thank venkat1@gmail.com has provided me the software conversion from
>> PDF to Excel, very useful
Dear Group,
Can you people help me I want to create a Excel based Birthday Mail which
will automatically forward to the User whose birthday is and CC to his
upervisor with his name and OFT template image or a image.
in Excel :- Name --- Date of Birth-- Supervisor mail id --- User mail Id
when d
Yes the format for the date is yymmdd
I am working with excel 97
Sent from my Blackjack via AT&T
On Oct 21, 2010, at 10:35 PM, Srinivasan Ethirajalu
wrote:
> 1)
>
> PropertyID Account#Date Time Net Funded
> 1212178 2 10/10/2010 11:02481
> 1212178
Please help
Pankaj
On Sun, Sep 19, 2010 at 5:25 PM, pankaj gmail account
wrote:
>
> Hi to the forum,
>
> Please help me it is very urgent for me
> i have a text file which is (|) delimited in which it contains all
> countries files, what i want to do is to create country wi
Hi to the forum,
Please help me it is very urgent for me
i have a text file which is (|) delimited in which it contains all countries
files, what i want to do is to create country wise files in .TXT same
format.
so there will be
singapore.txt
india.txt
etc.
i tried but i was not able to complet
39 matches
Mail list logo
