Malik Aap Gr8 ho…
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: Wednesday, June 15, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ कविता : दास्तान-ए-VLOOKUP (Excel Function)
कविता :
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 venkat1@gmail.comwrote:
Dear Vivek,
Find attached file and use get file names option...You may get it
*Best
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 @
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
*To:*
good one
2011/6/15 NOORAIN ANSARI noorain.ans...@gmail.com:
कविता : दास्तान-ए-VLOOKUP
आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप.
खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप.
हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP .
LOOKUP महोदय के दो बेटे दोनों गजब होनहार.
खासियत
Great...Keep it up.
Regards,
Yusuf
2011/6/15 NOORAIN ANSARI noorain.ans...@gmail.com
कविता : दास्तान-ए-VLOOKUP
आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप.
खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप.
हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP .
LOOKUP महोदय के दो बेटे
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, except
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
Tussi Vadde Mazakiya Ho Ji.. :-)
2011/6/15 NOORAIN ANSARI noorain.ans...@gmail.com
कविता : दास्तान-ए-VLOOKUP
आओ दोस्तों बैठो, Excel की दुकान में, करे कुछ गपसप.
खाए Logic के पकौड़े, और पिए, फोर्मुलों का Tea एक-एक कप.
हंसी मज़ाक में जान ले दास्तान-ए-V/H LOOKUP .
LOOKUP महोदय के दो बेटे
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
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
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=1ob=5*
*
*
*Best Regards,*
*Venkat*
--
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 @
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,
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 kannan.ex...@gmail.comwrote:
Hi Guru...
how to put password in vba coding.??
how to protect that?
regards
Kannan V
9941077703
-- Forwarded message --
From: Phi Consulting shr...@phirms.com
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
can you attach the sample workbook
On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa aze...@gmail.com 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
which query can you post it again
On Wed, Jun 15, 2011 at 11:08 AM, Bhushan Sabbani bsabban...@gmail.comwrote:
Pls help in the query.
Thank in advance.
Bhushan.
--
--
Some important links for excel users:
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
--
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
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 aze...@gmail.com wrote:
I have a table in excel of # of employees by age, sex and category of
employment. The ROWs have three diff categories by
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
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, hariharan.thara...@wipro.com wrote:
Hi
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.
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 Tue,
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
Thank you very much for your help, it worked perfectly!!!
On Tue, Jun 14, 2011 at 9:49 PM, ashish koul koul.ash...@gmail.com 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
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
ActiveCell.Rows(1: nrow).EntireRow.Select
On Jun 15, 4:11 pm, Hiren Sheth hiren.sh...@viteos.com 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
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 jmut...@mtc.com.na wrote:
Friends,
Is there a website or an e-book or a book you
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
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
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...
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
thanks everyone for offer of help. Here is the sample data.
On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c venkat1@gmail.com 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
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).Value
Print #1,
Thanks Noorain
It solved my problem. Thanks alot.
Regards
Amit
On Wed, Jun 15, 2011 at 9:21 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
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
37 matches
Mail list logo