Hi All,
Request the group to start a thread which teaches excel formulas..
- Explain the formula
- Difference ( if any) in 2003, 2007 2010 versions
- Examples
Your thoughts please
Thanks and Regards
Vinod
--
Join official facebook page of this forum @
Hi All;
Thanks a lot.
Paul Thanks for ur help to guide me through properly.
I can now go forward with this one..
Thanks Again;
regards Midhun
On Tue, Sep 11, 2012 at 7:29 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Midhun,
I like Paul's thorough response.
I thought I'd mention that
Due to restrict i will not able to use third party soft ware in my work
place.
Regards
CK
On Sep 11, 2012 11:08 AM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Dear Chethan,
You can use the Able to extract software
Best Regards,
Sagar
On Tue, Sep 11, 2012 at 10:22 AM,
Congratulations Noorain.
Regards,
Kaushik Savla
On Sep 2, 2012 10:44 AM, in.vaib...@gmail.com wrote:
**
Congrats Noorain..
Rgds
Vaibhav
--
*From: * Ayush Jain jainayus...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Sun, 2 Sep 2012 10:32:31
Its really Great Help Asa !!!
Thanks a ton !!!
On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Mangesh,
I've read your other replies, and as to why you haven't received a formula
method -- most people don't want to take the trouble on a volunteer basis
to
Homework done...
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Tuesday, September 11, 2012 4:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Its really Great Help
tried Google?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
You can try:
Option Explicit
Sub Unique_ID()
Dim Dict_Userid
Dim sht, SummarySht
Dim R, nRows, uArray
SummarySht = Sheet5
Set Dict_Userid = CreateObject(Scripting.Dictionary)
Dict_Userid.RemoveAll
'-
Since op did not indicate version your solution would not work prior to xl2007
and you have unnecessary and undesirable SELECTIONS.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Vabz
Sent: Tuesday, September 11, 2012 2:14 AM
To:
Hi Amar,
I think it can be useful, if you provide the dataseries name in mapping ,it
can be really helpful to color all series
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 11
Pleaes Explain more
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAGAR KASANGOTTUWAR
Sent: 11 September 2012 11:05
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Stock management
Nice, I will take this initiative :)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vinod Narayanan
Sent: 11 September 2012 11:39
To: Excel Group
Subject: $$Excel-Macros$$ Teach
I don't think if it can be done by Excel
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B.N.Chethan Kumar
Sent: 11 September 2012 12:40
To: excel-macros@googlegroups.com
Subject: Re:
I suggest NOT receiving in PDF format
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SAGAR KASANGOTTUWAR
Sent: Tuesday, September 11, 2012 12:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: PDF to excel table
Dear Chethan,
You
Not getting anything
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of loveufe2001
Sent: 11 September 2012 1:51
To: excel-macros
Subject: Re: Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful
This is not a function of Excel AFAIK but if you Google PDF to EXCEL
you will see that there are a number of options. Some of these
involve software, which you are not allowed. However your company may
have Adobe Acrobat X which can do this. Other sites offer, often free
of charge, a service
Loveufe2001
I suggest you post your question in its own thread and try to give a
bit more of an explanation of what you are doing Also use a suitable
heading.
On 11 September 2012 18:20, loveufe2001 loveufe2...@163.com wrote:
Dear friends:
My question is :when I closed Thisworkbook I
Don,
technically...
N.Sundarvelan (the originator) included a file in .xlsx format.
Which implies he has either xl2007 or xl2010...
But.. yes, this solution seems to have LOTS of selections.
and other jumping around that is a lot of wasted motion.
any time the display is updated, the run time is
Sub GetUnique()
Dim wksSheet As Worksheet
Dim VarArr
Dim lngCOunt As Long
With CreateObject(Scripting.Dictionary)
For Each wksSheet In ThisWorkbook.Worksheets
VarArr = wksSheet.Range(A1).CurrentRegion
For Each kk In VarArr
.Item(kk) = 0
Good thinking. My solution was simple and also took only 3-4 seconds AND it
changed to numbers. Try it.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Tuesday, September 11, 2012 9:04 AM
To: excel-macros@googlegroups.com
Subject: Re:
Looks like the best solution which also should sort
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Tuesday, September 11, 2012 9:14 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Unique from Multiple sheet
Thanks J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 11 September 2012 8:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Unique from Multiple sheet
Dear Rajan,
I want to make the excel base software for the managing Share stock.
where following purpose will be solve;
1. Entry of goods purchase
2. Maintain the avarage price with no of Stock
3. Sell the goods then that much stock will reduce from my account.
Kindly help me about the same.
Where is the file ?
On Sun, Sep 9, 2012 at 7:49 PM, Sara Lee lee.sar...@gmail.com wrote:
---
**
*From:* Sara Lee [mailto:lee.sar...@gmail.com]
*Sent:* 09 September 2012 7:41
*To:* Rajan_Verma
*Subject:* Re: macro for pivot
** **
once i copy and paste into a new module, how to
Paste that Code in Respective Sheet Code Module
e.g If your pivot sheet is Sheet3 then Double Click on Sheet3 in VBE And
paste that code
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mangesh
Hi Rajan,
I need that file for pivot code.
Can you provide same again as I am unable to see as an attachment.
Thanks.
On Tue, Sep 11, 2012 at 8:41 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Paste that Code in Respective Sheet Code Module *
*e.g If your pivot sheet is Sheet3 then Double
Hi Team,
Could you help me to make Flip Chart through VBA Coding.
--
Thanks Regards
Pravesh Kumar
--
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 titles. Poor
How this FLIP Chat looks like ?
Can you provide an example ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of PRAVESH KUMAR
Sent: 11 September 2012 9:30
To: excel-macros
Subject:
??
I think what we have here is a failure to communicate
In Excel, to flip a chart means to reverse the Axes.
You don't make a flip chart.
Therefore, I have to assume that you're using an old-school term for the type
of
chart projected for demonstration or teaching purposes.
Which is what
Hi Pravesh,
Can you plz express ur idea about flipiing the chart in more general trems,
I mean what do mean by flipping the chart.
regards
prince
On Tuesday, September 11, 2012 9:30:32 PM UTC+5:30, PRAVESH KUMAR wrote:
Hi Team,
Could you help me to make Flip Chart through VBA Coding.
Hi Sagar,
I think stock management criteria for several firms or companies could be
different so pleas explain requirements (functionality as u require) to be
in ur macro.
regards
prince
On Tuesday, September 11, 2012 11:04:42 AM UTC+5:30, ca_k...@yahoo.co.in
wrote:
Dear all,
Any
See the attached
Public blnFlag As Boolean
Sub FlipChart()
Dim ChtChart As Chart
Set ChtChart = Sheet1.ChartObjects(Chart 2).Chart
If blnFlag Then
ChtChart.ChartType = xlBarClustered
blnFlag = False
Else
ChtChart.ChartType = xlColumnClustered
hi Team,m
Can any one help me in creating a customized tab in excel ribbon, when i
share that excel file to others they, those button should be able to see
them.
Thanks
--
Regards,
Vinay. T
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Visit
www.rondebruin.nl/ribbon.htm
Sent on my BlackBerry® from Vodafone
-Original Message-
From: t vinay vinaytu...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 11 Sep 2012 22:48:24
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Hi Vinay.
Pls follow below mentioned steps.
1: download customUI editor And install it in ur system.
2: open ur workbook in ur UI editor.
3:Put XML from following Link(
http://msdn.microsoft.com/en-us/library/office/dd756403(v=office.12).aspx)
Code into ur Editor.
4:Click on Validate XML
Thanks Rajan.
On Tue, Sep 11, 2012 at 8:46 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Is it?*
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay
*Sent:*
The threads in this link talk a lot about Ribbon development in very simple
steps
http://www.excelfox.com/forum/f10/
Regards,
Sam Mathai Chacko
On Tue, Sep 11, 2012 at 10:50 PM, koul.ash...@gmail.com wrote:
**
Visit
www.rondebruin.nl/ribbon.htm
Sent on my BlackBerry® from Vodafone
Thanks a lot Rajan
For help and solved my Query.
On 9/11/12, Rajan_Verma rajanverma1...@gmail.com wrote:
See the attached
Public blnFlag As Boolean
Sub FlipChart()
Dim ChtChart As Chart
Set ChtChart = Sheet1.ChartObjects(Chart 2).Chart
If blnFlag Then
38 matches
Mail list logo