Re: $$Excel-Macros$$ Excel :: Final Completion date problem

Thanks Noorain It solved my problem. Thanks alot. Regards Amit On Wed, Jun 15, 2011 at 9:21 PM, NOORAIN ANSARI wrote: > Dear Nemi, > > This is basically Array function...it come after press ctrl+shift+enter.. > Please use below formula to your convenience..it is easy to Copy Paste > > Kindly

Re: $$Excel-Macros$$ Macro for copying single column from excel sheet to text file

> > try this > Sub create_txtfile() > > MyFile = "C:\Documents and Settings\achamanlalko\Desktop\ashish.txt" > 'set and open file for output > fnum = FreeFile() > Open MyFile For Append As #1 > Write #1, > For i = 3 To Sheets(1).Range("a65356").End(xlUp).Row > 'Write #fnum,Sheets(1).Cells(i, 2).Val

Re: $$Excel-Macros$$ excel query

thanks everyone for offer of help. Here is the sample data. On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c wrote: > Hi Azeema, > Send the sample data and some one will assist the query.. > Best Regards, > Venkat.. > > > On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: >> >> I have a tabl

Re: $$Excel-Macros$$ Macro for copying single column from excel sheet to text file

try this create any text file and write its location in MyFile = Sub create_txtfile() MyFile = "C:\Documents and Settings\ashish\Desktop\ashish.txt" 'set and open file for output fnum = FreeFile() Open MyFile For Output As fnum For i = 3 To Sheets(1).Range("a65356").End(xlUp).Row 'Write #fnum,

Re: $$Excel-Macros$$ PDF File

Please try it.. http://www.pdftoexcelonline.com/ On Wed, Jun 15, 2011 at 5:27 PM, Mishra, Kailash (GE Capital, Non-GE) < kailash.mis...@ge.com> wrote: > Dear Experts > > > > How can convert the PDF File in Excel file > > > > Regards > > > > > > -- > > ---

RE: $$Excel-Macros$$ Excel 2007 dashboards tutorials

Thanks Noorain Ansari. From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com] Sent: Wednesday, June 15, 2011 4:44 PM To: excel-macros@googlegroups.com Cc: John Mutesi Subject: Re: $$Excel-Macros$$ Excel 2007 dashboards tutorials Hi John, Please try it... http://chandoo.org/wp/excel-dashboards

RE: $$Excel-Macros$$ Protect cells if it have data(re post)

Hi, I am sorry rajesh, I don't know how to do this. Somebody please help on this and let us know how to do... Thanks, Hariharan Tharagan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh K R Sent: Wednesday, June 15, 2011 10

Re: $$Excel-Macros$$ Excel :: Final Completion date problem

Dear Nemi, This is basically Array function...it come after press ctrl+shift+enter.. Please use below formula to your convenience..it is easy to Copy Paste Kindly see attached sheet =SUMPRODUCT(MAX(($A$6:$A$15=A6)*($C$6:$C$15))) -- Thanks & regards, Noorain Ansari On Wed, Jun 15

Re: $$Excel-Macros$$ Excel 2007 dashboards tutorials

Hi John, Please try it... http://chandoo.org/wp/excel-dashboards/ http://top-pdf.com/download/excel-dashboard-tutorial-3.html Thanks & regards, Noorain Ansari On Wed, Jun 15, 2011 at 6:09 PM, John Mutesi wrote: > Friends, > > > > Is there a website or an e-book or a book you would want to acc

$$Excel-Macros$$ Re: Run time error '13'... Type mismatch error

ActiveCell.Rows("1:" & nrow).EntireRow.Select On Jun 15, 4:11 pm, Hiren Sheth wrote: >    Hi > > I am getting following error while running below mention code. > > Please help. > > [cid:image001@01CC2B7B.1B6C0EA0] > > Dim nrow As Long > ActiveCell.Select > Cells(8, 1).Select > ActiveCell.Offs

$$Excel-Macros$$ I want Institute or Sites to Learn VBA

Dear Experts, As I am beginner in VBA, please suggest me any institute in Hyderabad or any best sites which can give coaching from basics. Thanks, Waheed -- -- Some important links for excel users: 1. Follow us on T

Re: $$Excel-Macros$$ Protecting certain cells based on conditions

Thank you very much for your help, it worked perfectly!!! On Tue, Jun 14, 2011 at 9:49 PM, ashish koul wrote: > try this > > > Private Sub Worksheet_Change(ByVal Target As Range) > > If Target.Column = 10 And Target.Row >= 8 Then > > 'target.column =3 because column c is no 3 column > > 'you can

$$Excel-Macros$$ Excel 2007 dashboards tutorials

Friends, Is there a website or an e-book or a book you would want to access or have in order to master excel dashboards? Yesterday, I bought an e-book which requires an adobe digital edition to read it but since I changed to a work PC and that book cannot be accessed anymore. Please help Joh

Re: $$Excel-Macros$$ Excel :: Final Completion date problem

Thanks Noorian But there is still some problem. If I copy your formula in my another file, result came to "{=MAX(IF($A$6:$A$15=A6,$C$6:$C$15,""))}". If I press F2 in that cell, { } brackets disappears and result is 10-oct-11 in all cells. Pls help me to get correct result. Regards Amit On Tu

RE: $$Excel-Macros$$ how to put password in vba coding.??

Sorry Yaar..now only I am seeing your reply And I don't know that yaar Thanks, Hariharan Tharagan From: kannan excel [mailto:kannan.ex...@gmail.com] Sent: Wednesday, June 15, 2011 7:52 AM To: Hariharan Tharagan; noorain.ans...@gmail.com Cc: excel-macros@googlegroups.com Subjec

$$Excel-Macros$$ PDF File

Dear Experts How can convert the PDF File in Excel file Regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ how to put password in vba coding.??

Guru!! Thanks guru, thank u very much... i am really happy. i want another help. do u know any animation and multimedia group. like excel googlegroup.com? i want immediate reply. refer me. On Wed, Jun 15, 2011 at 5:12 PM, wrote: > Hi Kannan V > > > > Module – To

RE: $$Excel-Macros$$ how to put password in vba coding.??

Hi Kannan V Module - Tools - VBA Project Properties - Protection - Check (Lock Project for viewing) and give password to it. Thanks, Hariharan Tharagan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Wednesday, June 15, 2011

Re: $$Excel-Macros$$ excel query

Hi Azeema, Send the sample data and some one will assist the query.. Best Regards, Venkat.. On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: > I have a table in excel of # of employees by age, sex and category of > employment. The ROWs have three diff categories by sex and the COLU

Re: $$Excel-Macros$$ how to put password in vba coding.??

Hi Kannan, Please go to Module--->VBA Project Properties--->Protection--->Give Password The above way is to protect VBA Project... *Best Regards,* *Venkat* On Wed, Jun 15, 2011 at 2:09 PM, kannan excel wrote: > Hi Guru... > > how to put password in vba coding.?? > > how to protect that? > >

$$Excel-Macros$$ Require code which appends signature to the foot of the lotus notes mail body

Hi , I have got a code which does the work of sending emails using Lotus notes. However I am not able to append the signature. Require ur input on how to *include the signature at the end using macro*.Looking forward to your response. Sub SendWithLotus() Dim noSession As Object, noDatabase A

$$Excel-Macros$$ Protect cells if it have data(re post)

Hi Experts, I already posted this query, but i think my elaboration was not good. Now I made the necessary changes in the sample file attached. pls check it once more and tell me how to solve it. Regards Rajesh Kainikkara -- -

Re: $$Excel-Macros$$ Re: help in vba coding and excel function

which query can you post it again On Wed, Jun 15, 2011 at 11:08 AM, Bhushan Sabbani wrote: > Pls help in the query. > > Thank in advance. > > Bhushan. > > -- > > -- > Some important links for excel users: > 1. Follow

Re: $$Excel-Macros$$ excel query

can you attach the sample workbook On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: > I have a table in excel of # of employees by age, sex and category of > employment. The ROWs have three diff categories by sex and the COLUMNS > have age (5 10-year age groups). Each cell provides the

$$Excel-Macros$$ Job

-- Forwarded message -- From: Phi Consulting Date: Wed, Jun 15, 2011 at 10:54 AM Subject: Urgent requirement for Reporting analyst-- Gurgaon Location *Experience required for Job:* 3 - 6 years *Job Annual Salary:* 3.0 - 5.0 Lacs *Job location:* Not Mentioned A Leading US based F

Re: $$Excel-Macros$$ how to put password in vba coding.??

Dim x As Worksheet Sub Protectsheet() For Each ws In Worksheets x.Protect Password:="abc" Next End Sub On Wed, Jun 15, 2011 at 2:09 PM, kannan excel wrote: > Hi Guru... > > how to put password in vba coding.?? > > how to protect that? > > regards > > Kannan V > 9941077703 > onechennaiproperty.c

$$Excel-Macros$$ Run time error '13'... Type mismatch error

Hi I am getting following error while running below mention code. Please help. [cid:image001.png@01CC2B7B.1B6C0EA0] Dim nrow As Long ActiveCell.Select Cells(8, 1).Select ActiveCell.Offset(1, 0).Range("A1").Select Range(Selection, Selection.End(xlDown)).Select nrow = Range(Selection, Selecti

Re: $$Excel-Macros$$ sorting

Tx Ashish Regards Akhilesh AIren -- -- 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

$$Excel-Macros$$ Excel Tips&Tricks Video's Link...

Dear All, Please watch below link in YouTube you may get hundreds of Excel Tips &Tricks... With Excel Sample Excel Workbooks Also [image: image.png] *http://www.youtube.com/user/ExcelIsFun?blend=1&ob=5* * * *Best Regards,* *Venkat* -- -

$$Excel-Macros$$ excel query

I have a table in excel of # of employees by age, sex and category of employment. The ROWs have three diff categories by sex and the COLUMNS have age (5 10-year age groups). Each cell provides the number (frequency) of employee for a particular age group and job category and sex!! I would like to c

$$Excel-Macros$$ how to put password in vba coding.??

Hi Guru... how to put password in vba coding.?? how to protect that? regards Kannan V 9941077703 onechennaiproperty.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ कविता : दास्तान-ए-VLOOKUP (Excel Function)

Tussi Vadde Mazakiya Ho Ji.. :-) 2011/6/15 NOORAIN ANSARI > कविता : दास्तान-ए-VLOOKUP > > आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप. > खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप. > हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP . > > LOOKUP महोदय के दो बेटे दोनों गजब होनहार. >

RE: $$Excel-Macros$$ querry new

Maybe this file ? Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nemi Gandhi Envoyé : mercredi 15 juin 2011 08:44 À : MS EXCEL AND VBA MACROS Objet : Re: $$Excel-Macros$$ querry new Thank you Daniel, but when i drag the

Re: $$Excel-Macros$$ querry new

Thank you Daniel, but when i drag the formula to other cells in column D22:022, , it whows 'YES". Only J22 column should show "YES' and all other cells should be blank because D4:04 (except J4 against "surya" and col "7" YES is mentioned) has "NO". So in target D19:O30, all cells hould be blank,

Re: $$Excel-Macros$$ कविता : दास्तान-ए-VLOOKUP (Excel Function)

Great...Keep it up. Regards, Yusuf 2011/6/15 NOORAIN ANSARI > कविता : दास्तान-ए-VLOOKUP > > आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप. > खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप. > हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP . > > LOOKUP महोदय के दो बेटे दोनों गजब होनहार.

Re: $$Excel-Macros$$ कविता : दास्तान-ए-VLOOKUP (Excel Function)

good one 2011/6/15 NOORAIN ANSARI : > कविता : दास्तान-ए-VLOOKUP > > आओ दोस्तों बैठो, Excel की दुकान में, करे  कुछ गपसप. > खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप. > हंसी मज़ाक में जान ले  दास्तान-ए-V/H LOOKUP . > > LOOKUP महोदय के दो बेटे दोनों गजब होनहार. > खासियत दोनों गुणी बेटों

Re: $$Excel-Macros$$ कविता : दास्तान-ए-VLOOKUP (Excel Function)

it's very interestinggg *"pazi tosi great hao "* -- One Team One Dream One Goal Warm Regards, Brajesh Kumar Porwal > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Wednesday, June 15, 2011 11:18 AM > *T

$$Excel-Macros$$ Re: help in vba coding and excel function

Pls help in the query. Thank in advance. Bhushan. -- -- 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:/

Re: $$Excel-Macros$$ EXCEL INDEX FOR FILES IN FOLDER

Hi Venkat fantastic job... how u do this all... amazing thanks its help our company also. thanks guru. kannan V On Tue, Jun 14, 2011 at 11:14 AM, Venkatesan c wrote: > Dear Vivek, > > Find attached file and use get file names option...You may get it > > > *Best Regards,* > *Venkat* > >