Ashish Sir,
you are really Great...
i am very big fan of you..
thank you so much for the providing the code, this is working good.
On Saturday, 22 March 2014 11:38:08 UTC+5:30, ashish wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Sub create()
>
>
> Dim wk As Worksheet, wk2 As Worksheet
> Dim
amp;
> z).Value
>wk.Range("e" & s & ":e" & s + (z - i - 1)).Value = .Range("b" &
> z).Value
>wk.Range("f" & s & ":f" & s + (z - i - 1)).Value = .Range("c" &
> z).Value
>&#
Dear sir,
i dont want to use pivot. i need only formula for offset or index is it
possible...
On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
> Hi
>
> You can do using Pivot Table, see attached file.
>
>
>1. In the Pivot Table, click the drop down arrow in the RowLabels
>fi
:
>
> Its not possible to do without any help column.
>
> Another way out is shown in attached file. Ref col E & F.
>
> Thx
>
>
> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari
> > wrote:
>
>> Dear sir,
>>
>> i dont want to use pivot.
Dear sir,
thank you so much.your given a great help..
On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
>
> Hi
>
> PFA alternate method using formula & help sheet.
>
> Thanks
>
>
> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari
> > wro
Dear Sir,
countif function creating more violation for huge data range. is there any
possible to overcome or use any other function.
please guide me...
thanks...
On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote:
>
> Dear sir,
>
> thank
ou can do so by creating UDF.
>
> See UDF sheet.
>
> Thanks
>
>
> On Wed, Apr 30, 2014 at 12:08 AM, renuka chari
> > wrote:
>
>> Dear Sir,
>>
>> countif function creating more violation for huge data range. is there
>> any poss
Dear Vabs,
Super ...
On Wednesday, 30 April 2014 12:23:46 UTC+5:30, amar takale wrote:
>
> Dear Vabs Brother
>
> Its really cool formula which you have sent me… There was a glow in my
> face
>
> Thanks very very muchfor helping excel enthusiasts
> voluntarily !!
>
> Regards
check and confirm..
On Monday, 21 April 2014 16:39:40 UTC+5:30, kapil Gupta wrote:
>
> But what is the password in this code. Please reply
>
>
> On Saturday, March 22, 2014 7:03:12 PM UTC+5:30, renuka chari wrote:
>>
>> Dear Deepak,
>>
>> thank
SaveAs Filename:=StrDocName, FileFormat:=51
> oWorkbook.Close Savechanges:=wdDoNotSaveChanges
> StrFilename = Dir$()
> Wend
> MsgBox "Conversion is completed", , "ODS to XLSX"
> Exit Sub
> End Sub
>
> Cheers!!
>
>
> On Thu, May 15, 2014 a
please provide/
On Thursday, 3 July 2014 00:03:44 UTC+5:30, renuka chari wrote:
>
> *dear group,*
>
> *please provide the vba macro for sheet names having alphanumerics then
> it wont sort asc or dsc*
>
>
> *suppose for example one workbook having 23 worksheet
www,,
thanks vab sir,,,
thanks alot,
On Saturday, 5 July 2014 16:37:05 UTC+5:30, Vabz wrote:
>
> Chek dis...
>
> it has bot macro for normal name & for alpha numeric name too...
>
>
> Cheers!!
>
> On Sat, Jul 5, 2014 at
Dear sir,
i was prepared a macro for autofilter the range based on column a1 in
unique values and
paste this range into sheet2 side by side
in this i have succed in the autofilter the range data but failed to copy
this data into sheet2 side by side
i think may be some logic was missing in secoun
Thanks alot sir
On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote:
>
> Hi
>
> PFA
>
> Cheers!!
>
>
> On Fri, Jul 18, 2014 at 9:27 AM, renuka chari > wrote:
>
>> Dear sir,
>> i was prepared a macro for autofilter the range based on colu
Dear sir,
i am unable to use this code because its showing error, so please copy
rectify the error and provide the excel sheet for that..
thanks alot.
On Friday, 26 September 2014 11:58:17 UTC+5:30, Vabz wrote:
>
> chek this:
>
>
> http://www.excelguru.ca/content.php?122-Creating-an
Thank you mr. Pramod, this is only i am expecting thanks alot..
On Wednesday, 15 October 2014 08:59:44 UTC+5:30, pramodb35 wrote:
>
> Hi Renukachari,
>
>
> Please find the attachment as per your requirement..
>
> On Wed, Oct 15, 2014 at 12:10 AM, Paul Schreiner > wrote:
> > I'm sorry
Hi Sir,
i tried to copy all the code and controls into new workbook still i
have been facing the same problem
please guide me in this regard ,
thanks lot
On Monday, 15 December 2014 18:10:46 UTC+5:30, renuka chari wrote:
>
> Dear Experts,
>
> please solve
Hi Paul,
Thanks for your replay,
my data having segment and 2 quarter values
i need below kind of report
Segment vlaues1 vlaues2
A (Q3) 1
A (Q4) 2
B (Q3) 1
B (Q4) 2
On Friday, 13 November 2015 02:01:19 UTC+5:30, Paul Schreiner wrote:
>
> Wha
hi
it was not work actually in my excel backend some code is there once
can you check tahat and give me solution for that
thanks for ur valueble replay
On Feb 17, 4:48 am, NOORAIN ANSARI wrote:
> Hi Renu,
>
> Please see attached Screen shot, it might be helpful
>
> On Fri, Feb 17, 2012 at 1:1
hi
Option Explicit
Sub ExportToExcel()
On Error GoTo ErrHandler
Dim appExcel As Excel.Application
Dim wkb As Excel.Workbook
Dim wks As Excel.Worksheet
Dim rng As Excel.Range
Dim strSheet As String
Dim strPath As String
Dim intRowCounter As Integer
Dim intColumnCounter As Integer
Dim msg A
hi
Noorain
i know that formula, but i neet To Address,bcc Address & Subject. At
a Single glance
thanks
On Feb 19, 11:34 am, NOORAIN ANSARI wrote:
> Dear Vijay/Renuka,
>
> Please use it to keep subject line while opening new outlook window..
>
> *=HYPERLINK("**mailto:"&G2&"?Subject="&"
gt; =HYPERLINK("mailto:"&G2&"?bcc=noorain.ans...@gmail.com&Subject=Ladger
> > statement",G2)
>
> > --
> > Thanks & regards,
> > Noorain Ansari
> > *http://noorainansari.com/*
> > *http://excelmacroworld.blogspot.com/*<http:
Hi Alll
i am extremely Sorry for that
On Feb 21, 2:46 pm, "Asa Rossoff" wrote:
> Hi Renukachari,
>
> Sorry, your query is against group rules. "3) Don't post questions
> regarding breaking or bypassing any security measure." is stated at the
> bottom of every message and on the website.
>
> Asa
Hi Noorain,
Congrats
On Mar 15, 3:49 am, 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 been consistent contributor t
Hi rajan thanks for ur replay
but i need not like that
2 payslips are sending to 2 employees individually in at a time
how is it possible?
On Thursday, 17 May 2012 17:24:23 UTC+5:30, renuka chari wrote:
>
> Dear experts
>
> Excel macro for sendin outlook emails f
; file will be sending to the xyz2
customer and so on .like this
in the end of the month i need to send payslip .pdf files also send as like
that only
On Thursday, 17 May 2012 17:24:23 UTC+5:30, renuka chari wrote:
> Dear experts
>
> Excel macro for sendin ou
can u help me any one how to use offset, index, match in indepth
i know basics to use these functions
i need indepth summery
using arrays like that
i need more and more help for offset function
thanks in advance
--
--
Date & Time
04/15/2009 06:02:35
04/14/2009 16:46:49
04/14/2009 16:46:49
04/14/2009 16:46:49
04/14/2009 16:46:48
04/14/2009 23:58:34
i need this kind of format in internally, formula bar have this kind
of format only i dont need am or pm in internallcell formula in
formula bar
how to change this kin
Thanks Ashish
it's working good
On Jan 17, 10:37 pm, ashish koul wrote:
> goto control panel -> reginal settings -> select time and click on customise
> -> click on time tab and choose H:mm option
>
> On Mon, Jan 17, 2011 at 8:21 PM, renuka chari wrote:
> > Dat
thanks to all here i am attaching one sheet here how to remove this
kind of special characters help me plz
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
hi to all thanks in advance here iam attaching one file i need like
that but idont know how to do this can u help me any one Pl
thanks & regards
On 12 May 2011 05:58, wrote:
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
> Please help to ma
Congrats Rajan
On Aug 4, 7:19 am, Venkat CV wrote:
> Hi SantRam,
>
> Thank u so much...
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
> On Thu, Aug 4, 2011 at 12:21 AM, Sant Ram wrote:
> > congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS
> > S),Noorain..
>
> > On Wed, Aug 3, 2
Dear Member,
PFA
for Ur Solution
On Sunday, 22 July 2012 11:40:06 UTC+5:30, (%Allmydreams%) wrote:
>
> Hi,
>
> I have made clear brief in my attached excel workbook for calculating time
> difference and manually entered the slab of mins where dat would need to be
> automated.
>
> Also
Dear Member,
PFA for Updated file
Here i am sending navigation steps also
On Sunday, 22 July 2012 11:40:06 UTC+5:30, (%Allmydreams%) wrote:
>
> Hi,
>
> I have made clear brief in my attached excel workbook for calculating time
> difference and manually entered the slab of mins where dat wo
hi Ayush congrats
On Oct 3, 11:44 pm, Ayush Jain wrote:
> Dear members,
>
> I am proud to share that I have been re-awarded the Micrososft MVP award in
> 2011. My deep thanks to each group member for all your support and
> contribution to this group.
> I keep saying that this forum is a great co
hi Noorain
congrats..!
On Oct 2, 9:14 am, Sam Mathai Chacko wrote:
> Fabulous work Noorain. You make a difference, and all of us in the
> forum appreciate your contribution. Carry on the excellent work.
>
> Sam Mathai Chacko (GL)
>
> On 10/2/11, suryaprasad...@gmail.com wrote:
>
> > Hip
hi experts!
i am having a excel workbook, it contains 10 sheets
my query is "if i enter a one formula in first sheet in specific range
in one column that formula should be add in specific range in other
sheets at single time" is it possible
if any macro or macro sheet cna you send as soon as pos
Hi
Try This Formula
=+DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))
Regards
On Oct 11, 6:08 pm, Suman wrote:
> Hi,
> Good evening to all,
> Please help in changing date formate.
>
> --
>
> «•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
> «´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`»
> «•´`•.(¸.•´
Plz give me the replay ASAP
Thanks
On Nov 17, 6:17 am, Renukachari Kasee wrote:
> Hi experts can you solve this problem Plzzz i dont know how to
> do that i need this ranges into chart axis
>
> thanks in advance
>
> *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
>
hi
Sam Mathai Chacko,
Don Guillett.
thanks for ur responce
Actually this Excel Project Will work like this:
here Ohlc Sheet Having data it is automatically coming from yahoo site
if we need to select symbol, next cell for company, and enter starting
date and ending date then click on get data b
plz help me any one
On Nov 21, 12:46 pm, Renukachari Kasee wrote:
> Hi All
>
> Plz Find this Attachment ithink now it is clear my doubt
>
> plz solve this problem ASAP
>
> Thanks in Advance
>
> p_fchart(Chari)(testing).xls
> 1524KViewDownload
--
FORUM RULES (934+ members already BANNED for vio
sorry Don Guillett
its working good but chart was not shown
ur done good work once i will check this Code and inform you soon
thanks
On Dec 6, 1:30 pm, Renukachari Kasee wrote:
> hi
> Don Guillett
> thanks for your response
>
> once check this file
>
> here max is 14000 then this macro was not w
hi maries thank you very much
On Dec 9, 5:12 pm, Maries wrote:
> Hi,
>
> Find the attached file.
>
> Regards,
>
> MARIES.
>
> On Fri, Dec 9, 2011 at 12:55 PM, Renukachari Kasee wrote:
>
>
>
> > hi thanks for you valuble replay
>
> > but i need like this can you see this attachment
>
> > On 8 Dec
hi
good evening
i need a macro for outlook Bcc mail ids keep in every new or forworded
messagesHow?
can you any one give me aguidance for that.
thanks in advance
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Ple
ya, sending on daily basis
On Feb 14, 12:25 pm, Mahesh parab wrote:
> Hi
>
> Do you want to send bulk emails to respective person from that worksheet ?
>
> HTH
> Mahesh
>
>
>
>
>
>
>
> On Tue, Feb 14, 2012 at 9:14 PM, dguillett1 wrote:
>
> > Don Guillett
> > SalesAid Software
> > dguille...@gmai
Hi
dguillett1
Its working Good Thank you so much
On Feb 14, 10:44 am, "dguillett1" wrote:
> Right click sheet tab>view code insert this. Now when you select col G (no
> need for col H)
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> On Error GoTo nomo
> If Target.Colu
thanks maries And All
On Feb 14, 2:02 pm, Maries wrote:
> Hi,
>
> Find the attached file.
>
> Regards,
>
> MARIES.
>
>
>
>
>
>
>
> On Tue, Feb 14, 2012 at 9:25 PM, Mahesh parab wrote:
> > Hi
>
> > Do you want to send bulk emails to respective person from that worksheet ?
>
> > HTH
> > Mahesh
>
>
Hi
Don Guillett
is there any way to keep subject line also while opening that link
thanks for every one
On Feb 14, 8:44 pm, "dguillett1" wrote:
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Renukachari Kasee
> Sent: Tuesday, February 14, 2012 6:21 AM
> To: excel-macros@g
hi Excel beginner,
i don't know your name?
but you gave me a wonderful solution
thanks allot.
but is there any easy formula for that..
this mega formula usage in my sheet every time is difficult for me...
is there any alternate solution for that...
i mean that make it simple
Hi! jeet singh,
Thanks i am expecting this only thanks a lot
On Wednesday, 21 November 2012 11:20:48 UTC+5:30, jeet singh wrote:
>
> PFA
>
> On Tue, Nov 20, 2012 at 10:20 PM, renuka chari
> > wrote:
>
>> hi Excel beginner,
>> i don't know your name?
&
Hi Ashish!
thanks for your valuble replay,
this formula was fulfilling my requirement a little. Please suggest much
better output.
thanks
On Sunday, 10 March 2013 12:06:55 UTC+5:30, ashish wrote:
> Try this formula see if it suffice ur requirement
>
> *
> =HYPERLINK("#'"&B$1&"'!a"&M
is awesome Ashish thanks
On Monday, 11 March 2013 01:21:31 UTC+5:30, renuka chari wrote:
>
> Hi Ashish!
>
> thanks for your valuable replay,
>
> this formula was fulfilling my requirement a little. Please suggest much
> better output.
>
>
> thanks
>
>
End With
>
> End If
> Application.EnableEvents = True
> Exit Sub
> ERR:
> Application.EnableEvents = True
> MsgBox "Error Description:" & ERR.Description
>
>
> End Sub
>
>
>
> On Mon, Mar 11, 2013 at 1:49 AM,
hi excel experts i have a small problem
MY DATE AND TIME FORMAT IS "mm/dd/ hh:mm am/pm"
I WANT
TO CHANGE COL: A CHANGED IN TO COL:A"
=
col:a col:a
=
10/11/2010 18:37
;
> "&TEXT(TIME(HOUR(A1),MINUTE(A1),SECOND(A1)),"hh:mm am/pm")
>
> Let me know if this solves your problem :)
>
> Best Regards,
> DILIPandey
>
>
> On 10/11/10, renuka chari wrote:
> > hi excel experts i have a small problem
> >
> > MY DA
,MONTH(A1)+1,DAY(A1)),"mm/dd/")&"
> "&TEXT(TIME(HOUR(A1),MINUTE(A1),SECOND(A1)),"hh:mm am/pm")
>
> Let me know if this solves your problem :)
>
> Best Regards,
> DILIPandey
>
>
> On 10/11/10, renuka chari wrote:
> > hi excel
GOOD EVENIG ALL EXPERTS
CAN U SLOVE MY VLOOKUP PROBLEM
THIS IS MY DATA IN SHEET1
=
VNo CR Amt
=
CR-MSP-619+ 70
CR-MSP-620 600
CR-MSP-621 400
CR-MSP-622 180
CR-MSP-623 140
CR-MSP-624+ 60
CR-MSP-625 150
CR-MSP-626
ck the attachment see if it helps you
>
> you can apply customer filter on temp column and choose greater than 1 and
> copy all and paste into sheet2
>
> On Thu, Oct 14, 2010 at 8:06 PM, renuka chari wrote:
> > GOOD EVENIG ALL EXPERTS
> > CAN U SLOVE MY VLOOKUP PROBLE
hi experts good morning,
thanks in advance
i want to print in excel sheet cells to 1,2,3,4,5,6,.in the
selected rang, can u help me any one vba code for that macro.
thanking you for kind attention.
--
--
Some impo
hi experts good morning
i need help for insert flash(.swf) signature file into outlook
signature
how it possible can u help me pl
thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWIT
hi
good evening to all experts
currentely i am trubling in large range data with filtaration
my company data having nearly 4lac of rows in one file
i need to sort that data using auto filter Option then it was not
showing all filterd data i don't know how to filter that large rang of
data
can u
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 trubl
how to attach excel sheet to this blog posts
--
--
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.li
GOOD & GREAT "X" - MAS
On Dec 24, 3:47 pm, Venkat wrote:
> Hi Lucky,
>
> Find attached
>
> Best Regards,
>
> Venkat Cv
>
> On Fri, Dec 24, 2010 at 11:15 AM, lucky singh wrote:
>
> > Hi Guys,
>
> > Do anyone has a excel greetings for Christmas or new year...
>
> > plz do forward.
>
> > Thanx
Normally(Shift+F11), when we insert a worksheet in Excel, it will
appear left to the current sheet. Is it possible to insert a worksheet
to the right side?
--
--
Some important links for excel users:
1. Follow us on T
Dear Experts thanks alot
Hi *De Premor / Enrique Martin**
**
*thanks for giving this macro
this would be save my time alot and alot
thanks
On Tuesday, 17 September 2013 01:46:47 UTC+5:30, renuka chari wrote:
>
> Dear experts.
>
>
> please solve my query its very very urgen
Dear group any update. please help me out
thanks
On Sunday, 6 October 2013 18:11:35 UTC+5:30, renuka chari wrote:
>
> Dear Group
>
> Please help me this problem for multi sheets select with in the single
> click
> As per the requirement
>
> Thankss
Dear group please provide the solutions for above mentioned.
thanks
On Saturday, 30 November 2013 18:31:37 UTC+5:30, renuka chari wrote:
>
> Dear experts,
>
> Please solve my problem
>
> i have a one master data workbook that having three or two or more sheets
> master
Dear group please provide the solutions for above mentioned.
thanks
On Sunday, 1 December 2013 16:48:27 UTC+5:30, renuka chari wrote:
>
> Dear group Please provide the userform code here serial no should be
> capture on next record no on stored data sheet i.e volunteerlist if I
>
dear ashish/ any other guru's,
please provide the solution for this
On Tuesday, 3 December 2013 19:28:35 UTC+5:30, renuka chari wrote:
>
> Dear group please provide the solutions for above mentioned.
>
> thanks
>
> On Sunday, 1 December 2013 16:48:27 UTC+5:30, renuka c
\Sig
> 2p.jpg]<http://goo.gl/gHTB5E>[image:
> Description: C:\Users\Krushna.garkhede\Desktop\Sig
> 3p.jpg]<http://goo.gl/QNQP51>
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *renuka chari
> *Sent:* 03 December 2
in City column
> Selection.Offset(0, 4).Value = txtDtTIme.Text 'DtTIme entered in DtTIme
> column
> Call EmptyTextBoxes
> End Sub
> [/code]
> [code]
> Private Sub EmptyTextBoxes()
> txtSlNo.Text = ""
> txtNam.Text = ""
> txtCty.Text = "&quo
Dear sir
this code is not working
Please provide the alternate solution
On Monday, 16 December 2013 20:30:22 UTC+5:30, renuka chari wrote:
>
> Thank you sir,
> i will check this once and tell you
>
> thanks once again
>
>
> On Thursday, 12 December 2013
Dear sir,
thank you very much... thanks a lot
i am expecting this only sir
On Tuesday, 31 December 2013 04:34:19 UTC+5:30, Basole wrote:
>
> Hi renuka chari, solve your problem?
>
> Basole
>
> Em domingo, 29 de dezembro de 2013 13h46min05s UTC-2, renuka
thank you sir..
On Saturday, 30 November 2013 23:45:11 UTC+5:30, ashish wrote:
>
> visit below links
>
> you can create maps , etc in Excel 2013
>
>
> http://office.microsoft.com/en-in/excel-help/what-s-new-in-excel-2013-HA102809308.aspx
>
> http://www.techrepublic.com/blog/10-things/10-best-
75 matches
Mail list logo
