Check if it helps ...
[image: Inline image 1]
Regards,
ZAFAR IQBAL
+966 (14) - 325 1654, 325 3484, 325 4148 - Ext - 2011
On Sat, Jul 15, 2017 at 5:31 PM, Srinivas G wrote:
> Hi Friends,
>
> I want to help in Excel
>
> ramu Ramu False
> Raju Raju True
> mohan Mohan
Hi All,
I am trying to make pivot table using VBA.but I am getting runtime error 5 or
so. Can someone suggest me a code to make pivot cache and then table.
Thanks
Abhishek Bhalla
From: "amar takale"amartak...@gmail.com
Sent:Thu, 25 Feb 2016 10:20:12 +0530
To: excel-macros@googlegroups.com
Subje
>
> Your Date is not date but to convert a date to number you can simply
> multiply it with one this scenario works most of the cases but not for all.
>
For Example your date is in A1 put formula in b1 = A1*1
Regards,
Mandeep baluja
ticket closed
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Dear sir
I cannot understand kindly brief/example
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 6:15 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Re: Help Required
Multiply date
] *On Behalf Of *Mandeep Baluja
> *Sent:* Thursday, January 14, 2016 4:50 PM
> *To:* MS EXCEL AND VBA MACROS
> *Subject:* $$Excel-Macros$$ Re: Help Required
>
>
>
> PFA !! Ticket closed
>
> Regards,
>
> Mandeep baluja
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(
Dear sir,
Thanks sir !!
Kindly share the formula.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 4:50 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help Required
PFA !! Ticket
>
> PFA !! Ticket closed
>
Regards,
Mandeep baluja
--
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 concise, accurate thread titles. Poor
> Hi Sam
> Thank you very much for your quick response
> Later i researched on the particular question and i concluded a result
> which may be seen in the attach workbook...but thank you very much for your
> quick response
>
> --
> *Izhar Ul Haq*
>
>
>
> Cell# 009203069072597
>
--
Are
I've tried so many times in the past but failed to do so, the reason was,
when I tried to search a file in which I have to find something I typed the
word with the extension of the software which was unsuccessful but now I
tried to search without the extension I find whatever I required. In the
[mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anand Tiwari
> *Sent:* Tuesday, August 04, 2015 4:24 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ RE: Help required
>
>
>
> Hi Neeraj
>
>
>
> Please use this,
>
Thanks Anand
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Anand Tiwari
Sent: Tuesday, August 04, 2015 4:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: Help required
Hi Neeraj
Please use this,
Alt+D+E then
Hi Neeraj
Please use this,
Alt+D+E then Delimited next click Date and choose format DMY then finish.
*Regards,*
*Anand Tiwari*
On 4 August 2015 at 16:14, Neeraj Chauhan
wrote:
> Dear experts I want to change the date format
>
>
>
> Date
>
> I want this format
>
> 31/7/2015
>
> 31-Jul-15
>
Dear experts I want to change the date format
Date
I want this format
31/7/2015
31-Jul-15
--
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
Thanks sir
its working and I want this
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Wednesday, May 20, 2015 3:25 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help Required
Want this ?
Regards
Want this ?
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, May 20, 2015 at 2:59:09 PM UTC+5:30, neeraj chauhan wrote:
>
> Dear Experts,
>
>
>
> Kindly find the sheet and do the needful for
Brother the code which you have given it is for excel.
I am talking about MS Access
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
> Hi Experts,
>
> I want to split table from main table with their names available in column
>
> For example.
>
> I have a database in the d
Use this code basically it use the Autofilter technique to create sheets
and use of collection class to remove the duplicates.
Sub Macro60()
'Step 1: Declare your Variables
Dim MySheet As Worksheet
Dim MyRange As Range
Dim UList As Collection
Dim UListValue As Variant
Dim
Thanks dude
but I need code to make separate sheet for each LOB as these needs to
assign work to each individual.
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
> Hi Experts,
>
> I want to split table from main table with their names available in column
>
> For exampl
Why you're not using the pivot table feature to create this, Create pivot
and use this column in row field to create separate sheets. only 6 are
required, but if you still wish you can use the code for the same.
Health Personal Accident Engineering Miscellaneous - Package Liability
Miscel
Thanks Mandeep for reply.
Below is the column in which we required separate Tablefor each LOB.
*LOB Name* Health Personal Accident Engineering Health Personal
Accident Health Miscellaneous - Package Health Health Personal Accident
Health Health Health Personal Acciden
Do you want to Create separate sheets on the basis of column.???
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
>
> Hi Experts,
>
> I want to split table from main table with their names available in column
>
> For example.
>
> I have a data
Glad to help :)
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Wednesday, May 6, 2015 at 12:28:39 PM UTC+5:30, rk sharma wrote:
>
> Thanks alot Mandee
Thanks alot Mandeep ji.
its working.
br//
rakesh
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
www.ericsson.
when you select your blank cells just see the buttons in home tab where
insert,delete,format button is showing you need to press delete ->delete
cells -> shift cells to left .
On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
>
> Thanks Mandeep ji,
>
> but dear i didn't und
Thanks Mandeep ji,
but dear i didn't under stand what your are talking about this line
*go into home tab delete cells and shift cells left you will get your data*
Pl help
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, IND
Select b3:m5 press f5 -> click special option->tick blank->go into home
tab delete cells and shift cells left you will get your data.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook
Ok Sir, I am trying.
Regards
Ashu Kenith
--
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 concise, accurate thread titles. Poor thread title
Dear Mandeep Sir,
All are enabled.
PFA the attachment.
Please provide Support.
Regards
Ashu Kenith
--
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 RULE
in this attachment did you enabled this library in refrences go to vba
editior enalble these library and then go to sheet1 and click the button
send mails .
microsoft outlook 14.0 object library
ole auotmation
microsoft excel 14.0 object library
visual basic for applications
microsoft forms 2.
remove option explicity statement which is in first line of your code, as
this code working perfecctly on my pc , Please send me the line number of
error.
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exa
PFA !!!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exam D
Dear Mandeep Sir,
Query is still pending from last 2 months. Last time you said that,
you will send the answer shortly.
Revert awaited from your side.
Please help.
Regards
Ashu kenith.
On 1/15/15, Ashu k wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
P
Hello
Correct me if mistaken. You want to sum time in column 1 with time in
column 2 in column 3 in format like hh hrs mm minute. If yes in column 3
add simply column 1 and column 2 (you can round it). Change format of
result by pressing ctrl+1 and typing in custom type: *hh "hrs" mm "minute"*
Dear Mandeep Sir,
Please help.
kindly send the macro.
Regards
Ashu Kenith.
On Thu, Jan 15, 2015 at 6:41 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please Help on the same issue. Can i explain again my query.
>
> Please help sir.
>
> Regards
> Ashu Kenith
>
> On Thu, Jan 15, 2015 at 12:30 PM, A
Dear Mandeep Sir,
Thanks a lot for your help.
I don't have an facebook account. So, request you to please share the macro
when you have time.
Thanks for your help and kind support.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja
wrote:
> https://m.facebook.com/VBAEXCELSQL
https://m.facebook.com/VBAEXCELSQL?__tn__=C
This is my page i have posted your macro on this blog top post is yours,
Copy the same and run in your sheet.
Sorry i forgot to send you the sheet.will send the same as i will be in office.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
Please help sir.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 12:30 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please help.
>
> Regards
> Ashu Kenith.
>
>
> On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote:
>
>> Dear M
Dear Mandeep Sir,
Please help.
Regards
Ashu Kenith.
On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Thanks a lot for your help.
>
> one more help required.
>
> If the Merchant ID is same then paste the data (Order No., Item ID, Item
> Name, RTO Date) on mail body which w
Dear Mandeep Sir,
Thanks a lot for your help.
one more help required.
If the Merchant ID is same then paste the data (Order No., Item ID, Item
Name, RTO Date) on mail body which was belongs to Same Merchant ID.
Example : - Merchant ID is 12345 and 10 orders is placed by this merchant,
then pas
>
> Try this Ashu k ,
This must meet your requirements. Thanks to RonDBurn Blog.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Dear Mandeep Sir,
Please Help.
Regards
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that as p
Dear Mandeep Sir,
Please Help!!
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that
Dear Mandeep Sir,
Solution was perfect. But i want Paste the data in Mail body.
Please check below sample Email :-
Dear Business Partner,
This is to inform you that as per our logistic partner report you have
received RTO shipments with details as follow:
*Order No*
*Item ID*
*Item Name
Done !!
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
>
>
--
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
Dear Mandeep Sir,
I don't want to send mail with attachment. I want send different mail to
different customers according to the merchant ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch the merchant
id,order n
Dear Anil Sir,
Thanks for your reply. But, i dont want to send mail with attachment. I
want send different mail to different customers according to the merchant
ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch
Amazing Code Bro !!
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exam Date
>
>
> and,
>
> I have data in Sheet 2
>
> Name Class Roll No. Exam Date
>
>
> But some Names are not in Name Column and Some
Dear Mr. Ashu,
Pls find attached as per you requirement.
P.S pls change the address of the attachment as you req.
.Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(),
"mm-dd-yy") & ".xls")
Warm regards,
Gawli Anil.
On Wed, Jan 7, 2015 at 1:24 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
Dear Mandeep Sir,
PLease help. I want send mail to the customers. Example is attached.
Thanks
Ashu Kenith
--
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
>
> check this sheet.
Try to understand what I did For i = 2 To lr + 700 you can set 700 to any
number. Datarange is not set in your data that's why i running the loop to
lastrow+700 if your data will be greater just change 700 to 7 or to any
number it will give correct result to you
Dear Paul Sir,
Thanks for your help and explaining me..
Dear Mandeep Sir,
Thanks a lot for your help, Please check the attached sheet. Result was not
showing in Last cell.
Please help.
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja
wrote:
> Hey Ashu,
>
>
> Check this sh
>
> Hey Ashu,
Check this sheet .* Note :- be careful to check this macro can only give
you error if the number are actually numbers not the Text values as your
sheet contain 1 value which was text that is the only reason it gives error
as paul has explained to you mostly people copy numbers f
---------
From: Ashu k
>To: Mandeep Baluja ; excel-macros
>
>Sent: Tuesday, January 6, 2015 11:38 AM
>Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA
>
>
>
>Dear Mandeep Sir,
>
>
>Please help on this. The sheet is provided by you is
Dear Mandeep Sir,
Please help on this. The sheet is provided by you is providing NA#. Please
Help.
Thanks
Ashu Kenith
-- Forwarded message --
From: Ashu k
Date: Wed, Dec 31, 2014 at 11:52 AM
Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA
To: Mandeep Baluja
23, 2014 at 11:06 AM
Subject: Re: $$Excel-Macros$$ Re: Help required for Match DATA
To: excel-macros
Dear Mandeep Sir,
It gives NA# again. Kindly run macro and See the result in Cell C1 and C12.
Sheet attached.
Thanks
Ashu Kenith
On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja
wrote
This solution will work for you !!! To create a dependent drop down list
provide some unique values as all persons having the same values .This can
be achieved without dependent drop down.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://ww
Dear Mandeep Sir,
It gives NA# again. Kindly run macro and See the result in Cell C1 and C12.
Sheet attached.
Thanks
Ashu Kenith
On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja
wrote:
> Now this macro works for 3 lakh rows you can increase the range as per
> your convenience.
>
> Regards,
>
Now this macro works for 3 lakh rows you can increase the range as per your
convenience.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrot
Dear Mandeep Sir,
It's not working.
Thanks
Ashu Kenith.
On Thu, Dec 18, 2014 at 8:00 PM, Ashu k wrote:
>
> Dear Mandeep Sir,
>
> The code which is provided by you is not working properly. It's giving NA#
> in sheet 2.
>
> Formula is working fine for me which is provided by Ashish Sir & Vaibhav
Dear Mandeep Sir,
The code which is provided by you is not working properly. It's giving NA#
in sheet 2.
Formula is working fine for me which is provided by Ashish Sir & Vaibhav
Sir.
Kindly check the output and Please Help me.
Sheet attached.
Thanks
Ashu Kenith
On Thu, Dec 18, 2014 at 12:42 P
Dear Sir,
Thank you very much.
Thanks
Ashu Kenith
On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja
wrote:
>
> check this out.
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
> On Wednesday,
check this out.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO.
Go here
https://myexcelschool.wordpress.com/category/excel/
On Wednesday, January 20, 2010 10:48:24 AM UTC+5:30, pmnitie wrote:
>
>
>
> Hi
>
> am working scheduling problem in excel. i would like to know...is there
> any way i can get the chart for the datas in Gantt Chart format.
> It will b
Hi
You can format cell as DD-Mmm- or
you can use formula =text(ref,"DD-Mmm-) where ref is your reference
cell.
Thanks
On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan
wrote:
> Dear experts,
>
>
>
> We have given below date format how to convert right format of date like
> 13-Jan-2014
Dear experts,
We have given below date format how to convert right format of date like
13-Jan-2014
TT Modified Date & Time
13/01/2014
15/01/2014 19:51
2-Nov-14
1-Jun-14
2-Nov-14
15/01/2014 19:57
1-Jun-14
13/01/2014 17:10
15/01/2014 19:47
18/01/2014 15:44
From:
ok De Premor, tks.
Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon
escreveu:
>
> Dear All,
>
>
> I have a DBF Table containing Vouchers Month wise like
>
> 70001 (Dated : 05-July-13)
> 70002 (Dated : 08-July-13)
> 80001 (Dated : 02-August-13)
>
>
> Now i want to get
No it's not, that file protected by simple method to prevent user
opening it they change the file header structure
Try attached DBF, i've repair the header by changing 1st byte on file
with correct value.
Pada 11/09/2013 21:19, Basole menulis:
Hi, the dbf attachment is corrupted.
Em quart
Hi, the dbf attachment is corrupted.
Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon
escreveu:
>
> Dear All,
>
>
> I have a DBF Table containing Vouchers Month wise like
>
> 70001 (Dated : 05-July-13)
> 70002 (Dated : 08-July-13)
> 80001 (Dated : 02-August-13)
>
>
> No
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've seen all ur tricks for this..i dnt know where my trick
fails...but i am getting the desired output via my trick also..
so its a question just out of curiosity that my trick is wrong or not, and
if it's wro
Hi Jai,
I m not able to understand ur requirments. Please provide us at least on
example to what we needs to do.
Regards
Prince
On Friday, January 11, 2013 10:57:48 AM UTC+5:30, Jai Bhati wrote:
>
> HI GUROPS MEMBER ,
>
>
> PLEASE HELP REGARDING THIS SHEET .
>
--
Join official Facebook pa
Hi Cheer,
Please use the same mail chain for solution instead of new mail.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote:
> Hello Neeraj
>
> CTRL+1 on the value column --> Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan
Hi Cheer,
Please use the same mail chane for solution instead of new mail.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote:
> Hello Neeraj
>
> CTRL+1 on the value column --> Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauha
Hello Neeraj
CTRL+1 on the value column --> Custom --> select type *0.00*
cheers
On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan wrote:
>
> Dear Experts,
>
> kindly find the attached sheet.
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexc
Hi Sriram,
Please use the below mentioned formula to remove special charactors.
=SUBSTITUTE(F4,{"#","$","%","&","!","~","_",";",'""},"") With
ctrl+shift+Enter
Note F4 is containing your text.
Regards
Prince
On Wednesday, October 10, 2012 4:02:24 PM UTC+5:30, sriram ji wrote:
>
> Dear Excel
Hello,
Maybe this UDF would be useful for you.
Function RemoveSpChars(s As String) As String
Dim re As Object
'List all allowed characters, but start with the negation "^"
Const sPat As String = "[^A-Z0-9 ]"
'List all characters to be removed, "-" must
' be listed first or last
'Const sPat As S
Hi neeraj ,
you can use this
=IF(HOUR(TIMEVALUE(RIGHT(A2,8)))<12,"Night","Day")
On Thursday, 4 October 2012 14:40:45 UTC+5:30, neeraj chauhan wrote:
>
> Dear Experts
>
>
>
> Kindly see the attached sheet and urgently req.
>
--
Join official facebook page of this forum @
Core. Please REPLY to messages instead of creating a new one.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: CoRe
Sent: Wednesday, May 16, 2012 4:57 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: help required for creating a formula
Hello
Dear Ashish
PFA
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Wed, May 16, 2012 at 3:27 PM, CoRe wrote:
> Hello,
>
> PFA!
>
>
>
> On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote:
>>
>> Dear All,
>>
>> I have a list of industry in one column and in cor
Hello,
PFA!
On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote:
> Dear All,
>
> I have a list of industry in one column and in corresponding column
> the rates as per industry are given. I want to create a formula
> whereby when i selected a specific industry from the dro
Hi vijay,
You can do that by using ASAP utilities.
There are hosts of other features. below link is for you.
http://www.asap-utilities.com/
hope this will meet your requirement.
Regards
Vishwanath
On Oct 20, 8:49 pm, vijayajith VA wrote:
> HI,
>
> I have 10 to 15 tabs with different name in one
Dear Prakash
Thanks for your solution. but 1 thing is pending if u can solve (i want hide
row number 15 if I select bank of baroda)
Dear Rohan
Thanks to you also, but your solution is giving me the box for only to the
digit 7,8,and 9 but I want box on every number, the same is solved by
prakash
hi experts
thanks for ur valuable replays
i need more ans
if any macros are there can u help me
i am trubling this large data
Actualy my data having names and codes cobination
On Dec 22, 8:28 pm, renuka chari wrote:
> hi
> good evening to all experts
>
> currentely i am trubling in large ran
Hi Renuka,
In excel 2003 you can only see 1000 unique items in autofilter,however in
excel 2007 and 2010 you can view upto top 10001 unique items in Autofilter.
In your case, You should use simple sort or Pivot table to manage your large
data set.
I hope it helps.
Thanks.
Best Regards,
Ayush
Hi,
I have attached a spreadsheet which contains list of document numbers and
their respective names. What I want is I need a word macro that will do the
following.
Note:
The file name will always starts with the Doc Number (5 digits). Ex: 12345
(Refer "Sample_Findlaw.xls" for list of Doc Number
Hi,
This is what I actually looking for. It works great and solves my query.
Thanks for your efforts and help.
Regards,
Sharma
On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa wrote:
> the sub test is just one example of how to use the function into a routine.
>
> Sub test()
> Dim s As String
>
the sub test is just one example of how to use the function into a routine.
Sub test()
Dim s As String
s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
s = ProperCase_r(s)
Debug.Print s
End Sub
r
--
--
Some
Hi,
I meant to say every time I need to change the "S" value as Input which is
taking more time.
I am unable to copy the result since it is showed via message box. I want to
copy the result and updated in documents.
It would be helpful if you could change the code as per the need.(Macro have
to
I don't understand
which linguage do you use?
In visual basic as I have proposed is a function you can pass any text and
use its result
regards
r
2010/10/28 amrahs k
> Hi,
>
> This works great. Thanks for your efforts and help. Though I have a small
> need as well.
>
> The code gives the ou
Hi,
This works great. Thanks for your efforts and help. Though I have a small
need as well.
The code gives the output through message box. Due to this I am unable to
copy the value (i.e) Output.
Also the code is only execute for the input "AGREEMENT. THE ADOPTION THE
ADULT OR MARRIED MINOR". Wha
Hi Maniyan,
Please check the file. I think this might help you.
Regards
Rakesh
On Jan 20, 10:18 am, Maniyan wrote:
> Hi
>
> am working scheduling problem in excel. i would like to know...is there any
> way i can get the chart for the datas in Gantt Chart format.
> It will be greatful if somebo
Hi Team,
Can you please help me below my request.Thanks in advance
On Tue, Sep 22, 2009 at 4:11 PM, minimaster <
hartmut.gruenha...@bakerhughes.com> wrote:
>
> How can I attach an excel workbook to this reply? I added some macro
> code to your workbook. But for some reason I can't find a way to
How can I attach an excel workbook to this reply? I added some macro
code to your workbook. But for some reason I can't find a way to
attach it here.
--~--~-~--~~~---~--~~
--
Some impor
Hello try the following macro :
Sub Copy()
Dim Row1 As Long, Row2 As Long
Row1 = 1
Row2 = 7
Do
Set sh1 = Worksheets("Sheet1")
Set sh2 = Worksheets("Sheet2")
sh1.Range("C" & Row1).Resize(8).Copy
sh2.Range("M" & Row2).PasteSpecial Paste:=xlPasteAll, Transpose:=True
Thanks a ton :)
On Mon, Jul 20, 2009 at 3:44 PM, Dilip Pandey wrote:
> Hi Steven,
>
> Solved. Have a look at the attached file. Thanks
>
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On
Hi,
For that you need to define a key in the dump sheet in Column A -
Merging data from cells in column B & C and then use sumif formula in
Analysis sheet,
For your reference I have done and attached excel sheet.
Hope this is what you required...
On 7/20/09, Steven Dsouza wrote:
> Hi,
>
>
Hi
You can use following formula in Excel 2007
SUMIFS(Dump!$C$2:$C$23,Dump!$A$2:$A$23,Analysis!A2,Dump!$B$2:$B$23,Analysis!B2)
Regards
Krupesh
On Mon, Jul 20, 2009 at 8:20 AM, Steven Dsouza wrote:
> Hi,
>
> Iam a regular user of this group, and some of the tips have helped me a lot
> in my
Hi Dilip
Excellent one, just one issue
You would have to lock the cells where you have given the table array,
otherwise the values go out of range and the formula does not work on
all the cells
On 7/20/09, Dilip Pandey wrote:
> Hi Steven,
>
> Solved. Have a look at the attached file. Tha
Hello.
Have a look at the attached file. Use the following formula in C2 and drag
down :
=SUMPRODUCT((Dump!$A$2:$A$23=A2)*(Dump!$B$2:$B$23=B2)*Dump!$C$2:$C$23)
Regards.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Steven Dsouza
Sent: lundi 2
Hi Steven,
Solved. Have a look at the attached file. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jul 20, 2009 at 6:50 PM, Steven Dsouza wrote:
> Hi,
>
> Iam a regular user of this group
Hi Shivashankar,
All you got to do is copy the cells A1 to A10 and then place your cursor in
B1 Cell and right click your mouse and choose Paste Special...In the Paste
Special Screen, Choose Values and also choose Transpose and Click on
Ok...You'll get what you are looking for...
Let us know, If y
1 - 100 of 156 matches
Mail list logo
