Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
functions within them. Chilexcel 2012/8/3 Rajan_Verma rajanverma1...@gmail.com * * *Hi Group,* * * *Is there any difference in Trace Precedents and Trace Error in Excel??* * * *I don’t need any link to see because I have already Google it.* * * *Regards* *Rajan verma* *+91

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
Mr.Sam Mathai Chacko I only answer queries or questions .. if you do not like my answer you propose another solution .. and everyone happy!!! Chilexcel 2012/8/3 Sam Mathai Chacko samde...@gmail.com Rajan isn't asking about Formula Auditing, which I am sure he is aware of. His question

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
the text again, there is an effort by someone else, ..thanks for posting the link 3) I clearly understand the question, you are who do not understand rajan did not want links or anything He wanted an answer this reviewer Rajan.. is what matters !!! Chilexcel 2012/8/3 Sam Mathai

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
Mr Sam Mathai Chacko Yes i make last comment ...!! You start a discussion unutil only to draw attention? or just bothering I do not know how you use your time but mine is important Now yes.. I end up here Chilexcel 2012/8/3 Sam Mathai Chacko samde...@gmail.com :) ending this here

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

2012-07-31 Thread ChilExcel
Hi Hilary Lomotey you have Custom Cell Formatting _(* #.##0,00_);_(* (#.##0,00);_(* -??_);_(@_) you must change by: _(* #.##0,00_);_(* (#.##0,00);_(* ??_);_(@_) or another of your choice Chilexcel 2012/7/31 Hilary Lomotey resp...@gmail.com thanks Dave On Tue, Jul 31, 2012 at 12:48 PM

Re: $$Excel-Macros$$ Nokia PC Suit API !!

2012-07-08 Thread ChilExcel
Hi Rajan Please see attached link .. (you must translate) http://jose-juan.computer-mind.com/jose-juan/PC-Suite-Connectivity-API.php Chilexcel 2012/7/8 Rajan_Verma rajanverma1...@gmail.com *Hi Group,* * * *I am searching for PC Suit API, if anybody have any good link where I can

Re: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

2012-07-06 Thread ChilExcel
B Sharma Please see attached file ,I think is what you need Chilexcel 2012/7/6 B Sharma sharma@gmail.com Dear Friend Noorain, Thanks for your quick reply... I tried this but failed, I was unable to insert rows in the table. I have attached a file for your reference too. Please see

Re: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

2012-07-06 Thread ChilExcel
B Sharma Please see attached file ,I think is what you need Chilexcel 2012/7/6 ChilExcel chilexcel...@gmail.com B Sharma Please see attached file ,I think is what you need Chilexcel 2012/7/6 B Sharma sharma@gmail.com Dear Friend Noorain, Thanks for your quick reply... I tried

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

2012-07-04 Thread ChilExcel
Rajan Congratulations . Excellent Chilexcel 2012/7/4 Ayush Jain jainayus...@gmail.com: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of June'2012. This is third time in row. :) He has posted 149 posts in June 2012 and helped many people

Re: $$Excel-Macros$$ age month days calculations - Reg

2012-06-22 Thread ChilExcel
Excelent Rajan fine solution Chilexcel 2012/6/22 Suman ksuman1...@gmail.com: Tkanks Rajan ji Regards, @Suman Send on the move with Galexy y. On Jun 22, 2012 5:58 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Here are two vba solution for  that : 1). Function DOB(rng

Re: $$Excel-Macros$$ All Ideas matter : Need your support here.

2012-06-21 Thread ChilExcel
please add in nodule Function User() As String User = Application.UserName End Function Chilexcel 2012/6/19 Ayush Jain jainayus...@gmail.com: Dear members, Last year,I started an initiative to collect ideas for improvements in excel. The initiative received the great response of 165

Re: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread ChilExcel
please add in Module Function User() As String User = Application.UserName End Function Chilexcel 2012/6/21 santosh subudhi santoshkumar.subu...@gmail.com: Hi Group, Is there a formula to get the user name in a cell the way we get it in VBA i.e application.username My comp doesn't

Re: $$Excel-Macros$$ All Ideas matter : Need your support here.

2012-06-21 Thread ChilExcel
Sorry response to another question Chilexcel 2012/6/21 ChilExcel chilexcel...@gmail.com: please add in nodule Function User() As String User = Application.UserName End Function Chilexcel 2012/6/19 Ayush Jain jainayus...@gmail.com: Dear members, Last year,I started an initiative

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2012-06-21 Thread ChilExcel
. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- FORUM RULES

Re: $$Excel-Macros$$ Saving Photos from webpage

2012-06-20 Thread ChilExcel
Kiran Please you use: 1 you should use DownThemAll , add on for firefox , and download all photos in a folder 2 use chilexel add ins for working with images I send a copy in file posted above ..I not delayed 1 minute to download all images Insertar Imagenes Excel (Chilexcel

Re: $$Excel-Macros$$ Saving Photos from webpage

2012-06-20 Thread ChilExcel
...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

2012-06-19 Thread ChilExcel
Rajan .. I created an add ins to add to the clock its purpose is to determine the timecode breaks talk about its usefulness example Stat End time difference 21:49:23,66 21:49:28,61 00:00:04,95 Chilexcel 2012/6/19 Rajan_Verma

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

2012-06-19 Thread ChilExcel
Rajan only commented the work I've done 1 .- move the cursor and enter hours 2 .- hours Clickleft button entry 3 .- add ins stopwatch to determine differences 4 .- formulated to test differences Atte Chilexcel 2012/6/19 Suman ksuman1...@gmail.com Thanks a lot rajan jee

Re: $$Excel-Macros$$ Translating

2012-06-15 Thread ChilExcel
please see http://office.microsoft.com/en-us/excel-help/where-are-the-translation-options-HA010215829.aspx Chilexcel 2012/6/15 Kiran Kancharla srkira...@gmail.com: Hi All, Request you to please let me know, is there any Inbuilt formula or a Macro to translate words in Excel. -- Thanks

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

2012-06-09 Thread ChilExcel
/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

2012-06-09 Thread ChilExcel
Please replace previous Please see attached 2012/6/9 ChilExcel chilexcel...@gmail.com: Please see attached 2012/6/9 Vivek vivek.j...@gmail.com: Dear All, Please find enclosed herewith the sample file. Thanks CA Vivek Jain. On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote: I have

Re: $$Excel-Macros$$ User Form

2012-05-24 Thread ChilExcel
Good Job Noorain Ansari !!! Chilexcel 2012/5/24 NOORAIN ANSARI noorain.ans...@gmail.com: Dear Deba, Please see attached Userform, hope it will help you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 22, 2012 at 6:01 PM

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

2012-05-10 Thread ChilExcel
Hi Asa Rossoff I'm working on a solution, with the help of friends, when finished. I send a result Chilexcel 2012/5/8 Asa Rossoff a...@lovetour.info: Hi Chil, Did you try to use those functions, and if so, please post your effort and what trouble you are having. Asa -Original

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

2012-05-10 Thread ChilExcel
Microsoft could pay me Incentive for Sale (jejeje), thx Asa Rossoff Chilexcel 2012/5/10 Asa Rossoff a...@lovetour.info: Excellent.  I hope I didn't give the impression I was unwilling to help more.  I am happy to.  But if you need more help, I prefer a specific question than just giving

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

2012-05-10 Thread ChilExcel
I understand Thank you for your attention and for your time, I have nothing more to add thanks again Chilexcel 2012/5/10 Asa Rossoff a...@lovetour.info: Hi Chilexcel, The problem for me comes because if the person requesting help does not look at themselves as a student

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

2012-05-08 Thread ChilExcel
Thx Asa Rossoff ,all this I know, also the links Please Rajan you help !!! ... Chilexcel 2012/5/7 Asa Rossoff a...@lovetour.info: Chil, Also see Bob Phillip's method @ http://www.xldynamic.com/source/xld.CFConditions.html -Original Message- From: Asa Rossoff [mailto:a

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

2012-05-08 Thread ChilExcel
Thx Don Guillett ,all this I know, also the links 2012/5/8 dguillett1 dguille...@gmail.com: http://www.xldynamic.com/source/xld.ColourCounter.html Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: ChilExcel Sent: Monday, May

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012-05-02 Thread ChilExcel
Congratulations Rajan, a great contribution to the forum Thanks also for your patience and help A hug! Chilexcel from Chile 2012/5/2 Asa Rossoff a...@lovetour.info Congratulations Rajan, you're very generous with your time and expertise! Asa ** ** *From:* excel-macros

Re: $$Excel-Macros$$ Sum_Hours week

2012-04-27 Thread ChilExcel
Fantastic work , Rajan , I am very grateful was what I needed thank you very much Chilexcel 2012/4/27 Rajan_Verma rajanverma1...@gmail.com HI Please try this Code *Worksheet Is attached * ** ** Sub MakeTotal() Dim rngSumRange As Range Dim

$$Excel-Macros$$ New Videos excel by Chilexcel

2012-04-20 Thread ChilExcel
Hello all group I share my new videos uploaded to my youtube page Please see this link Chilexcel PunteroCelda.xla http://www.youtube.com/watch?v=lZOsLCBSR2wcontext=C487180dADvjVQa1PpcFNtKYvBzpQ5HbSYGT3M8FSjxtRwaVrbdaM = All videos http://www.youtube.com/user/timextag41 Chilexcel -- FORUM

Re: $$Excel-Macros$$ New Videos excel by Chilexcel

2012-04-20 Thread ChilExcel
Rajan In the video is a download link Download here please http://sites.google.com/site/chilexcel/descargas-gratis Regards Chilexcel 2012/4/20 Rajan_Verma rajanverma1...@gmail.com Amazing J it would be great if you can share the code behind it. ** ** Rajan. ** ** *From

Re: $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

2012-04-20 Thread ChilExcel
Please download ; http://www.minipdf.com/ I tried it and it works fine ... Chilexcel 2012/4/20 Rajan_Verma rajanverma1...@gmail.com I think No, you can’t change. ** ** You can convert it in PDF and make it readable by One Adobe Tools [name I don’t remember) , Please google

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

2012-04-20 Thread ChilExcel
Please see http://www.minipdf.com/ I tried it and it works fine ...jpg at xls Chilexcel 2012/4/20 Shekhar Sharma shekhar1...@gmail.com Hey Kris, Thanks for the quick response, however I am looking for the code for not just adding the image in excel. I want to use the the data available

Re: $$Excel-Macros$$ New Videos excel by Chilexcel

2012-04-20 Thread ChilExcel
Yes...!!! ok 2012/4/20 Rajan_Verma rajanverma1...@gmail.com Hi Bro, Can u develop it in English.. ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ChilExcel *Sent:* Apr/Fri/2012 08:23 *To:* excel-macros

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

2012-04-16 Thread ChilExcel
Congratulations Don. thanks for your help !!! Chilexcel 2012/4/15 Somnath Khadilkar khadilka...@gmail.com Happy Birthday Mr. Don, May God Bless you with Long Life Peaceful Future Somnath Khadilkar On 4/14/12, Ayush Jain jainayus...@gmail.com wrote: Dear members, Don

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

2012-04-16 Thread ChilExcel
Don I also worked at ING (Chile) Congratulations again Chilexcel 2012/4/16 ChilExcel chilexcel...@gmail.com Congratulations Don. thanks for your help !!! Chilexcel 2012/4/15 Somnath Khadilkar khadilka...@gmail.com Happy Birthday Mr. Don, May God Bless you with Long Life

Re: $$Excel-Macros$$ Call a Function

2012-04-05 Thread ChilExcel
Please attach example, to better understand Chilexcel 2012/4/5 Matt moni...@gmail.com Hello, I'm trying to call a public function in one module from another Sub procedure in another module and it won't call the the function. I get an error that says..sub function not defined But when I

Re: $$Excel-Macros$$ Call a Function

2012-04-05 Thread ChilExcel
of the project name, and then click *OK*. 3. Check the name of the routine. 2012/4/5 ChilExcel chilexcel...@gmail.com Please attach example, to better understand Chilexcel 2012/4/5 Matt moni...@gmail.com Hello, I'm trying to call a public function in one module from another Sub procedure

Re: $$Excel-Macros$$ Re: Exact names Find

2012-04-03 Thread ChilExcel
Great job Haseeb !!! thank you chilexcel 2012/4/3 Aamir Shahzad aamirshahza...@gmail.com Haseeb, Can you breif your formula if I want to understand the logic. Regards, Aamir Shahzad On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A haseeb.avarak...@gmail.comwrote: Hello Deba, Try

Re: $$Excel-Macros$$ Sum hours weeks

2012-03-15 Thread ChilExcel
Excellent !!! dguillett1 is what I need Thank you very much for your attention Chilexcel 2012/3/15 dguillett1 dguille...@gmail.com You may want to use this to total at the bottom of column E Option Explicit Private Sub CommandButton1_Click() Dim tr As Integer Dim b As Range Dim lr

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-29 Thread ChilExcel
Don Guillett Great contribution, thanks Don Guillett Chilexcel 2012/2/29 Sam Mathai Chacko samde...@gmail.com Just a guess without testing For i = Cells(Rows.Count, Z).End(xlUp).Row To 2 Step -1 If Cells(i + 1, Z) = Cells(i, Z) Then Sam On Wed, Feb 29, 2012 at 4:41 PM, Jorge Marques

Re: $$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

2012-02-22 Thread ChilExcel
check whether this help http://www.rondebruin.nl/key.htm Thanks Chilexcel 2012/2/22, Indrajit $nai talk2indra...@gmail.com: Hi All, Is there any coding is available which can capture the Keystroke in a Excel file, Like whenever I am pressing alt+ctrl+del or locking the system

Re: $$Excel-Macros$$ Forgot my workbook encrypted password

2012-02-21 Thread ChilExcel
Please attached file to remove password see: https://sites.google.com/site/chilexcel/desbloqueos-y-removepass Chilexcel 2012/2/21 renuka chari jva.ch...@gmail.com Hi Alll i am extremely Sorry for that On Feb 21, 2:46 pm, Asa Rossoff a...@lovetour.info wrote: Hi Renukachari

Re: $$Excel-Macros$$ Forgot my workbook encrypted password

2012-02-21 Thread ChilExcel
Respecting the rules of the group .. and only One Time and thinking it to good use Please attach a file to remove password see: https://sites.google.com/site/chilexcel/desbloqueos-y-removepass Chilexcel 2012/2/21 ChilExcel chilexcel...@gmail.com Please attached file

Re: $$Excel-Macros$$ Capture Image using VBA

2012-02-09 Thread ChilExcel
working with images !!! please, see ; http://www.youtube.com/watch?v=B1qUrTKsnGocontext=C3697427ADOEgsToPDskKiaWsIL-0TfBoVlGZ-qD8u add ins by chilexcel, Hyperlink to do with ListFolder in this group 2012/2/9 Prakash Gusain gusainprak...@gmail.com You can use any excel file. I just

Re: $$Excel-Macros$$ Paste into a Named Range

2011-10-17 Thread ChilExcel
to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

Re: $$Excel-Macros$$ Re: can I unprotect a sheet

2011-10-07 Thread ChilExcel
that is what you need??? remove password of book? or unlock leaves? Please attach file chilexcel 2011/10/7 GoldenLance samde...@gmail.com To unprotect sheet / workbook structure protection, this should help. however, this will not open the workbook, if you have protected the file

Re: $$Excel-Macros$$ can I unprotect a sheet

2011-10-07 Thread ChilExcel
follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow

Re: $$Excel-Macros$$ Re: can I unprotect a sheet

2011-10-07 Thread ChilExcel
Please see attached for unlock sheets.. 2011/10/7 ChilExcel chilexcel...@gmail.com that is what you need??? remove password of book? or unlock leaves? Please attach file chilexcel 2011/10/7 GoldenLance samde...@gmail.com To unprotect sheet

Re: $$Excel-Macros$$ can I unprotect a sheet

2011-10-07 Thread ChilExcel
hi Dilip straxx password ,,does not work, this discontinued Chilexcel 2011/10/7 ChilExcel chilexcel...@gmail.com Please see attachment 2011/10/7 Bé Trần Văn betnmtdongna...@gmail.com 2011/10/7 Dilip Pandey dilipan...@gmail.com Hi Anil, see the below link. www.straxx.com

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-05 Thread ChilExcel
excellent solution, launching the message showing the repeat value thank you very much for your time and attention Rajan Chilexcel 2011/10/5 rajan verma rajanverma1...@gmail.com Try this : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Dim lngValue

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-05 Thread ChilExcel
End If If strMsg Then strMsg = Duplicate Record of Target.Value vbCrLf vbCrLf strMsg MsgBox strMsg End If Err: If Err.Number 0 Then Exit Sub End If End Sub 2011/10/4 ChilExcel chilexcel...@gmail.com Please see Mathai solution proposed by Sam Chacko

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-05 Thread ChilExcel
@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ChilExcel *Sent:* Tuesday, October 04, 2011 6:33 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row ** ** Thanks Rajan I need is to columns B and C (together

Re: $$Excel-Macros$$ Thanks everyone.

2011-10-05 Thread ChilExcel
Congratulations Ayush Jain chilexcel 2011/10/5 chhajersand...@gmail.com Dear sir the same problem is faced by all of us who r useing data to export in excel we can not use 'dr' as filter command as when we go to the cell which contains numbers it only shows no. Not number with the term 'dr

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-04 Thread ChilExcel
, ChilExcel chilexcel...@gmail.comwrote: hi i Need VB lines codes for Alert MsgBox Pair duplicate entry in row Column D function account and duplicates alerts (NO Problem!) Attach File , thank you all -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-04 Thread ChilExcel
:$B$57))*(Hoja1!$B$2:$B$57Hoja1!$C$2:$C$57)*(Hoja1!$B$2:$B$57=Hoja1!B Target.Cells(1).Row )*(Hoja1!$C$2:$C$57=Hoja1!C Target.Cells(1).Row ), lngCount ))) vbNewLine Next lngCount MsgBox strMsg, vbOKOnly + vbInformation, Duplicates End If End Sub Chilexcel 2011/10/4 Jai

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-03 Thread ChilExcel
)*(Hoja1!$B$2:$B$57=Hoja1!B Target.Cells(1).Row )*(Hoja1!$C$2:$C$57=Hoja1!C Target.Cells(1).Row ), lngCount ))) vbNewLine Next lngCount MsgBox strMsg, vbOKOnly + vbInformation, Duplicates End If End Sub Regards, Sam On Mon, Oct 3, 2011 at 10:15 PM, ChilExcel

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-02 Thread ChilExcel
Urgent !! i Need VB lines codes for 2011/10/1 ChilExcel chilexcel...@gmail.com hi i Need VB lines codes for Alert MsgBox Pair duplicate entry in row Column D function account and duplicates alerts (NO Problem!) Attach File , thank you all -- Visita ; http://sites.google.com/site

$$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-01 Thread ChilExcel
hi i Need VB lines codes for Alert MsgBox Pair duplicate entry in row Column D function account and duplicates alerts (NO Problem!) Attach File , thank you all -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

Re: $$Excel-Macros$$ values and percentages in stack chart

2011-09-27 Thread ChilExcel
Please attach sample file Chilexcel 2011/9/26 joseph camill joseph.cam...@gmail.com How do I add percentages and values in a normal stack chart. -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-09-04 Thread ChilExcel
I have solved my problem Thank www.contextures.com everything I need in a PivotTable without using macros www.contextures.com excellent!! thanks 2011/8/26 ChilExcel chilexcel...@gmail.com in the example I use: 1 advanced filter 2 Pivot table 3 and formula for count unique

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-31 Thread ChilExcel
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread ChilExcel
://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread ChilExcel
-- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-08-26 Thread ChilExcel
: *NOORAIN ANSARI noorain.ans...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 26 Aug 2011 10:49:39 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique Dear ChilExcel, For Unique

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-08-26 Thread ChilExcel
in the example I use: 1 advanced filter 2 Pivot table 3 and formula for count unique i need macro for all in summary table 2011/8/26 ChilExcel chilexcel...@gmail.com Thx , I know all of the above my problem is to use all operations once Sum, Count, and Count unique !!! all, not separated

Re: $$Excel-Macros$$ help table percentage

2011-08-19 Thread ChilExcel
, b).End(xlUp).Row Range(j4:p Cells(Rows.Count, J).End(xlDown).Row).Delete Range(J3:P3).AutoFill Destination:=Range(J3:P slr) End Sub *From:* ChilExcel chilexcel...@gmail.com *Sent:* Thursday, August 18, 2011 7:36 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ help

$$Excel-Macros$$ help table percentage

2011-08-18 Thread ChilExcel
Hello everyone please, I need vb code to create percentage range or table 2 msgbox ideal 1 input range 2 output range values ​​and ranges are always different I attached an example of my need to automate -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http

Re: $$Excel-Macros$$

2011-08-12 Thread ChilExcel
sorry, just an exercise I have no questions all good thx 2011/8/11 ChilExcel chilexcel...@gmail.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

Re: $$Excel-Macros$$ Generate random numbers based on number given in a cell

2011-05-30 Thread ChilExcel
F9 key works for all open workbooks, without exception ... The macro must be enclosed in the book to which you want to work only work if it is enabled Chilexcel 2011/5/29 hanumant shinde arsfan2...@yahoo.co.in can u pls give some light on this coding. i tried to debug but it jus have

Re: $$Excel-Macros$$ Consolidate data

2011-05-10 Thread ChilExcel
Please see attached file By Chilexcel 2011/5/10 Rajesh K R rajeshkainikk...@gmail.com Hi Experts Pls check the attached file and tell me how to consolidate date month wise. Regards Rajesh Kainikkara

Re: $$Excel-Macros$$ go back to the last visited page

2011-05-09 Thread ChilExcel
Please see attached file Chilexcel 2011/5/9 rajan verma rajanverma1...@gmail.com HI, Please see if it help.. On Sun, May 8, 2011 at 4:01 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts Is it possible to create two buttons one for forward other for backward and move

Re: $$Excel-Macros$$ Outlook 2007 Calendar Meeting Setup to Excel 2007

2011-05-02 Thread ChilExcel
see this link , that's what you need http://office.microsoft.com/en-us/outlook-help/export-calendar-data-to-excel-HP001087241.aspx Chilexcel 2011/4/27 Susan 1 sunni...@gmail.com Hi, Does anyone know if it is possible to import or export an Outlook calendar template into Excel 2007

Re: $$Excel-Macros$$ Remove Password Protection

2011-04-24 Thread ChilExcel
see this link http://sites.google.com/site/chilexcel/desbloqueos-y-removepass break the password books, Sheets VB proyect 2011/4/22 Prakash Gusain gusainprak...@gmail.com Hi, Can any one provide me any code using which I can break the password of any excel add in? Prakash

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

2011-04-20 Thread ChilExcel
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

2011-04-19 Thread ChilExcel
at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user

Re: $$Excel-Macros$$ SEARCH FUNCTION

2011-04-19 Thread ChilExcel
on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

2011-04-19 Thread ChilExcel
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread ChilExcel
http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Help required in merging two attendance sheets

2011-04-03 Thread ChilExcel
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

Re: $$Excel-Macros$$ File attachement

2011-03-10 Thread ChilExcel
you need to do? Chilexcel 2011/3/10 Cesar Delanoval cdelano...@gmail.com I am sending you the sample file that goes my latest post since I was not able to attach it or upload it on the group website. I appreciate all your help Thanks

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
Hi use this formula in data validation =CONTAR.SI($C$2:$C$30;C1)=1 chilexcel Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 2011/3/8 Rabindra Thapa rabinthapa2...@gmail.com Dear all, I have one attach file where I am keeping

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
sorry, use this formula in data validation =CONTAR.SI http://contar.si/($C$2:$C$30;C2)=1 2011/3/9 ChilExcel chilexcel...@gmail.com Hi use this formula in data validation =CONTAR.SI($C$2:$C$30;C1)=1 chilexcel Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http

Re: $$Excel-Macros$$ help with formating

2011-03-04 Thread ChilExcel
with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4 pawel lupinski lupins...@yahoo.com Hi All, I realy need your help with formating of the cells. see inside. Thanks Pawel

Re: $$Excel-Macros$$ help needed

2011-03-03 Thread ChilExcel
I have macros to consolidate or merge Excel worksheets and workbooks if anyone needs them let me know but it is better to know the tools of Excel, then use macros chilexcel 2011/3/3 ChilExcel chilexcel...@gmail.com Please see attachment and tell me ... chilexcel 2011/3/3 ChilExcel

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

2011-03-02 Thread ChilExcel
://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

$$Excel-Macros$$ I repeat again, anyone can help me?

2011-02-28 Thread ChilExcel
I need to extract dynamic table, named worksheet or book name (for each double click) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

$$Excel-Macros$$ Fwd: I repeat again, anyone can help me?

2011-02-28 Thread ChilExcel
attached file Thx -- Forwarded message -- From: ChilExcel chilexcel...@gmail.com Date: 2011/2/28 Subject: I repeat again, anyone can help me? To: excel-macros@googlegroups.com I need to extract dynamic table, named worksheet or book name (for each double click

$$Excel-Macros$$ Need named range or named range book Pivot Table

2011-02-25 Thread ChilExcel
-- thx Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Hope so...

2010-12-15 Thread ChilExcel
yes sr see this link http://sites.google.com/site/chilexcel/desbloqueos-y-removepass 2010/12/15 SAJID MEMON sajidwi...@hotmail.com Hi All Experts, Can we crack any VBA password like attachment ! If Yes then please give me tips. awaiting your positive responce sajid memon

Re: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR

2010-12-04 Thread ChilExcel
yes yes, download this application . http://www.todoexcel.com/office-tabs/ also you can do with Navigator Toolbar for Workbook Sheets http://www.contextures.com/xlToolbar01.html I hope help you Chilexcel My link http://sites.google.com/site/chilexcel/Home http://www.youtube.com/user