Congratulations Noorain. You are a real asset. Agreed that the
certificate is a great idea.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Wednesday, September 05, 2012 6:55 AM
To: excel-macros@googlegroups.com
Subject:
Hi,
thanks a lot your quick responce..
thanks,
kiran
On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Kiran,
Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime
under VBE editor.
On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI
Hi All,
Need your help.
I have Item Master (which has effective date of price applicable for a
product) and Sales Register (actual date of invoice with item and price
charged).
I need to check in Sales Register whether the rate applied is as per Item
Master.
Sample file attached. Please
---
You've been invited by jeet singh to use Google Talk.
If you already have a Google account, login to Gmail and accept this chat
invitation:
http://mail.google.com/mail/b-c937b1f53f-08548356f2-pLu-ioOM7CH0jtP62c_RBhXcwkc
To
Dear Friends,
Help me to find the circle and area. Please find the attached file for your
reference.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise,
PFA
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Friends,
Help me to find the circle and area. Please find the attached file for
your reference.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
Dear Friends,
Request to please help me on this issue.
I have attached an excel file for your reference.
I want the data to be filled in rows which has given in above columns of
the attached file.
Please help.
Thanks
Pravin Gunjal
--
Join official facebook page of this forum @
Hi Vikas,
You can use Lookup formula.
Regards,
Kuldeep Singh
On Thu, Sep 6, 2012 at 12:21 PM, Vikas Agarwal vikas@gmail.com wrote:
Hi All,
Need your help.
I have Item Master (which has effective date of price applicable for a
product) and Sales Register (actual date of invoice with
Hello,
I have attached an excel file which is having search option in it.
The VB code is gathering the data only from 1st column and it is not
applied for second column of the file.
I need to search some record which may have in any of the columns
(display name or e-mail id). Kindly help me out
Dear Noorain,
I am not able to run the programme and showing compile error (Method or
data not found) after running.
Thanks Regards,
KSAGAR
On Thu, Sep 6, 2012 at 12:07 PM, Kiran Kancharla srkira...@gmail.comwrote:
Hi,
thanks a lot your quick responce..
thanks,
kiran
On 9/6/12,
Dear Sagar,
First of all you have add library in VBE Area
Step:- Tools-Reference-Microsoft Scrinpting Runtime.
Brother check once again, if does',t work revert me.
On Thu, Sep 6, 2012 at 1:22 PM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Dear Noorain,
I am not able to run
Dear Noorain,
I have the same but it is not working.
Thanks Regards,
KSAGAR
On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
First of all you have add library in VBE Area
Step:- Tools-Reference-Microsoft Scrinpting Runtime.
Brother check once
Dear Sundar,
You can use single Vlookup for both required Column
*=VLOOKUP(K2,CHOOSE({1,2,3},$D$2:$D$20,$B$2:$B$20,$C$2:$C$20),{2,3},0)
*
with ctrl+shift+enter
See attached sheet for more clarity.
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Friends,
Wht error is showing, Please send screenshot.
On Thu, Sep 6, 2012 at 1:49 PM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Dear Noorain,
I have the same but it is not working.
Thanks Regards,
KSAGAR
On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI
Dear Noorain,
I want to manage share stock and there prices at the time of sale.
Purchase average prices should come automatically.
Kindly help me about this.
Thanks Regards,
KSAGAR
On Tue, Jul 31, 2012 at 11:54 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Sagar,
Please share a
Hi Pravin,
Try this.
=INDEX($B$3:$CP$3,MATCH($B10,$B$1:$CP$1),MATCH(C$8,$B$2:$D$2))
Regards,
Kuldeep Singh
On Thu, Sep 6, 2012 at 12:48 PM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Friends,
Request to please help me on this issue.
I have attached an excel file for your reference.
I
Dear Sagar,
Please use it.
Change Folder path as per your need.
Sub Protect_filesofFolder()
Dim MyFile As File
Dim MyFolder As Folder
Dim fso As Scripting.FileSystemObject
Set fso = New Scripting.FileSystemObject
Set MyFolder = fso.GetFolder(D:\VBA_Class\Extra\)
For Each MyFile In
Hello sir
In my attached files file1.xls is one month reports. file2.xls is next
month reports.
I want to cumulative values in cumulative columns automatically when i
enterd present month values in monthly columns.
Please help me.
Thanks in advance
--
Join official facebook page of this
Dear Excel Learner,
Please try it for cumulative sum
=SUM($E$4:E4,$F$4:F4) in cell G4 File 1
On Thu, Sep 6, 2012 at 2:58 PM, excel lerner exceller...@gmail.com wrote:
Hello sir
In my attached files file1.xls is one month reports. file2.xls is next
month reports.
I want to cumulative
Hai Noorin Sir
Thanks for your quick response. Small correction.Just read file1.xls is
april and file2.xls is may up to march.
In the month of april monthly and cumulative figures in male,female total
is same.
But in the month of may i enter the monthly figures in male female .
*IN THE SAME
Dear all,
I have made a UDF (formula) in personal.xls file. Though it is working when I
am working @ personal file but when ever I am trying to use it in my other
worksheet the formula is not working. Please help.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
Join official
Dear Sandeep,
Please change scope Public instead of Private.
else
share your UDF with group.
On Thu, Sep 6, 2012 at 4:14 PM, chhajersand...@gmail.com wrote:
Dear all,
I have made a UDF (formula) in personal.xls file. Though it is working
when I am working @ personal file but when ever I am
ANY UPDATE
On Thu, Sep 6, 2012 at 10:28 AM, jeet singh jeetexcelt...@gmail.com wrote:
Dear All,
plz find the attachment and help
Regards
Jeet
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Hi sandeep,
i hope scope of ur function or sub is private, so please make it public. If
it does not work then pls share the ur workbook with us.
regards
Prince
On Thursday, September 6, 2012 4:15:13 PM UTC+5:30, sandeep chhajer wrote:
Dear all,
I have made a UDF (formula) in
Have you read the Forum Rules?
(Well, SOME are more of a guideline.)
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 or may not be answered.
As an example:
My
It looks like your Item Master rates are based on a Date.
However, the dates in the Sales Register don't match up with the dates in the
Master.
Is this simply because it's sample data?
What is the relationship between the Product Code, Date, and Rate?
Is the Rate established on a date and
Thanks Asa, I have learned a lots of new thing from you.
Your description, your logic, your Concept and your solution always guide
me.
I think you are milestone of our group..please keep continue to post
your valuable solution..We are missing you last one or two month.
On Thu, Sep
*Thanks a lot Noorain Bhai*
**
Have you any programme for protecting the same files in that folder...?
Thanks Regards,
SAGAR
On Thu, Sep 6, 2012 at 2:41 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
Please use it.
Change Folder path as per your need.
Sub
I did NOT look at your attachment because you did not provide a meaningful
subject line in your post and you did not explain your problem in the body of
the email. I hope you explained, with examples, in the file. But, I didn’t look.
Don Guillett
Microsoft Excel Developer
SalesAid Software
Don,
I did (look)
He didn't (explain)
He has 5 columns of data and looks like he wants to do a bunch of sumifs,
but there's some selection criteria he has listed, but doesn't explain what
it
is or why.
I decided that it would take too much effort to ASK for the answers to
questions
he
HOME OFFICE?
2012/9/5 Vinay Kumar vi...@diverselynx.com
* *
*Need JAVA Developers for Chicago, IL/ Bloomington, IL/ **Raleigh, NC/
NYC, NY***
** **
*Duration: 12 months*
* *
Thanks,
*Vinay Kumar*
** **
Diverse Lynx LLC.
300 Alexander Park, Suite # 200
Princeton, NJ
Hi,
with the above macro I am able to add pasword to open the file.
In my case i need a maco to add pssword for VBA, not for opening the file.
plase help...
On 9/6/12, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote:
*Thanks a lot Noorain Bhai*
**
Have you any programme for
Its an array formula , confirm it as array by pressing Shit+Ctrl+Enter
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 06 September 2012 10:26
To: excel-macros@googlegroups.com
Download code from here
http://www.excelfox.com/forum/f12/color-chart-series-vba-58/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 06 September 2012 10:45
To:
=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 06 September 2012 12:37
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I did NOT look at your attachment because you did not provide a meaningful
subject line in your post and you did not explain your problem in the body of
the email. I hope you explained, with examples, in the file. But, I didn’t look
Don Guillett
Microsoft Excel Developer
SalesAid Software
ditto
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Thursday, September 06, 2012 6:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Please Help
Have you read the Forum Rules?
(Well, SOME are more of a
well said. Hopefully these messages will do some good??
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Thursday, September 06, 2012 7:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please Help
Don,
I did (look)
hi noorain,
yes i want to protect VBA
Thanks,
kiran
On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Means, You want to protect VBA Coding instead of Opening File.
Kindly confirm.
On Thu, Sep 6, 2012 at 6:32 PM, Kiran Kancharla srkira...@gmail.com
wrote:
Hi,
with the above
Req: Sun IDM Developer
Location: NY
Duration 12 months
Required Skills Include:
- Experienced in Sun Identity Manager 8.X (Oracle Waveset) and ability to work
on workflow Customizations in PWC framework.
- Experience on developing identity management entities like WorkFlow, WorkFlow
=INDEX($B$3:$CP$3,,MATCH($B10,DAY($B$1:$CP$1),0)+COLUMNS($C$9:C9)-1) with
CSE in C10
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: 06 September 2012 12:49
To:
Where you want to apply Password.
1) File Open ?
2) Worksheet Password ?
3) Workbook Password ?
4) VBA project Password ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran
6) Jobs posting is not allowed,
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Vinay Kumar
Sent: Thursday, September 06, 2012 8:58 AM
To: Vinay Kumar
Subject: $$Excel-Macros$$ Sun IDM Developer in NY
Req: Sun IDM Developer
Location: NY
Duration 12
4. vba protecion password
On 9/6/12, Rajan_Verma rajanverma1...@gmail.com wrote:
Where you want to apply Password.
1) File Open ?
2) Worksheet Password ?
3) Workbook Password ?
4) VBA project Password ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From:
=INDEX($C$13:$C$24,MATCH(1,N((N($A$13:$A$24=A3)*ROW($A$13:$A$24)*N($B$13:$B$
24=$B3))0),0))
With CSE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vikas Agarwal
Sent: 06 September 2012 12:21
Try this
Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.AutoFilterMode = False
If Target.Address Sheet1.Range(a2).Address Then Exit Sub
Sheet1.Range(A4).AutoFilter 1, * Target.Value *
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
Would be useful
Just follow the steps
http://www.mudraa.com/trading/81631/0/learn-to-use-excel-to-get-real-time-da
ta-from-nse-site.html
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAGAR
Showing #N/A
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kuldeep Singh
Sent: 06 September 2012 2:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Require values from other cell
Same as don
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 06 September 2012 6:08
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please Help
I did NOT look at
Need JAVA Developers for Chicago, IL/ Bloomington, IL/ Raleigh, NC/ NYC, NY
Duration: 12 months
Thanks,
Vinay Kumar
Diverse Lynx LLC.
300 Alexander Park, Suite # 200
Princeton, NJ 08540
Phone: 732-452-1006 ext 208
Fax: 732-452-0684
Email:
Need to be ban..
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vinay Kumar
Sent: 06 September 2012 7:29
To: Vinay Kumar
Subject: $$Excel-Macros$$ Sun IDM Developer in NY
Req: Sun IDM
Although you can know VBA Project is lock or unlock but you can not lock or
unlock VBProject by Code
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kiran Kancharla
Sent: 06
Vinay pls follow forum rule
Sent from BlackBerry® on Airtel
-Original Message-
From: Vinay Kumar vi...@diverselynx.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Sep 2012 14:31:24
To: Vinay Kumarvi...@diverselynx.com
Reply-To: excel-macros@googlegroups.com
Subject:
Hi Rajan,
I m agree with you.
On Thursday, September 6, 2012 8:11:31 PM UTC+5:30, Rajan_Verma wrote:
Although you can know VBA Project is lock or unlock but you can not lock
or
unlock VBProject by Code
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
Dear vinay this is not the place where job posting can be done so pls
follow the rules of forum.
On Thursday, September 6, 2012 7:29:03 PM UTC+5:30, Vinay Kumar wrote:
*Req: Sun IDM Developer*
*Location: NY*
*Duration 12 months*
*Required Skills Include:*
-
Hi Jeet,
I did'nt get your query or the selection criteria for the desire
solution.So pls explain little more about the problem.
regards
prince
regards
prince
On Thursday, September 6, 2012 10:28:42 AM UTC+5:30, jeet singh wrote:
Dear All,
plz find the attachment and help
Thanks Prince. I have made it public. Though I don't know the basic difference
between the scope to be private or pubic.
So will send you the work sheet.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Prince Dubey prince141...@gmail.com
Sender:
Is your function in a Standard module? or a Sheet module?
Perhaps we need a discussion about scope.
---
First, let's talk about Declaring variables and Modules:
There are several different types of Modules:
Excellent description, we salute you Paul all group members are lucky because
you, Asa and Don are with us.
Sent from BlackBerry® on Airtel
-Original Message-
From: Paul Schreiner schreiner_p...@att.net
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Sep 2012 10:35:40
To:
Put in a workbook module to find another file to unlock vba
Option Explicit
'Your password goes here
Const gszProjPassword As String = hello
Public Sub UnlockMe()
Dim wbName As Variant
Dim wbBook As Workbook
Dim vbaProj As Object
Dim oWin As Object
Dim X As Integer
On Error GoTo
Hi Don,
Thanks for your macro. In my case I need a macro to add Password, Not
remove password.
Thanks,
Krian
On Thu, Sep 6, 2012 at 11:50 PM, dguillett1 dguille...@gmail.com wrote:
Put in a workbook module to find another file to unlock vba
Option Explicit
'Your password goes here
example attached. i have multiple columns and rows. Please advise a
formula to get the data in the attached format.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread
thx brother
On Fri, Sep 7, 2012 at 10:42 AM, Karan Singh karan1...@gmail.com wrote:
Hi Jeet,
I think you're not able to explain your problem. As all expert said at
least you should explain your queries in Subject then in your
workbook. Anyways I'v done something (with recording), hope
Dear Pravesh,
See i have changed the dropdown working .
pls do the color , as i'm busy with other work.
On Fri, Sep 7, 2012 at 9:48 AM, PRAVESH KUMAR wrote:
HI Team,
please help me to solve this queston it's very urgent.
solve asap.
--
Thanks Regards
Pravesh Kumar
--
Join
64 matches
Mail list logo