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 @
https://www.facebook.com/discusse
Dear all,
Any stock management macro in excel then Please give me the same.
Thanks & Regards,
Sagar Kasangottuwar
--
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 titl
Dear Expert.
Please tell me how can i re-size all slide in one time..
Regard
Manoj
--
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 thread titles, like
Dear Rajan,
Thanks for suggestion for formatting color Chart VBA but it is not useful
for me.I need VBA for separate criteria if change value color then change
in chart value color,If change bar color data then change bar color& so
on...
Pls help anybody for solution me
Thanks Amar
On Thu, Sep
Anil Narayan Gawli
Mb:-09769855615
gawli_anil8...@yahoo.co.in
gawlianil8...@gmail.com
On Mon, Sep 10, 2012 at 1:40 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi All,
>
> ** **
>
> First of all thanks to all experts who helping to the world with their
> expertise knowledge
Hi Midhun,
I like Paul's thorough response.
I thought I'd mention that there is a simpler / easier-to-remember way of
detecting the logged-in user's name from a macro:
Function ReturnUserName() As String
UserName = Environ("USERNAME")
End Function
It is slightly less secure, sinc
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
provide a more complex or difficult solution to a given problem when simple
solutions exist. Also in business, the simplest solution
Ok, Thanks you for make me clear about this
Your help is appreciate
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: Monday, September 10, 2012 8:55 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MMULT functions questio
I'm sorry gentlemen.
I was out of the office for a few days.
(Actually, I'm not sorry... I needed the time off!)
As Sam (I believed) surmised, the actual problem was that
I couldn't get the CSE to work properly.
It kept wanting to create the array function as:
={LOOKUP(A2,"0","1","2","3","4","5",
Here's something I threw together from macros I already had.
I didn't spend too much time on it.
I hope they have what you're looking for.
There are several things you MENTIONED that I tried to include.
Since you want the user to view ONLY his performance,
I added filters to the "YTD Output" shee
Hi,
You can try this.
=INDEX('YTD Output'!$F$2:$F$228,MATCH('YTD Performance'!C8,'YTD
Output'!$C$2:$C$228,0))
=INDEX('YTD Output'!$H$2:$H$228,MATCH('YTD Performance'!C9,'YTD
Output'!$F$2:$F$228,0))
Regards,
Kuldeep Singh
On Mon, Sep 10, 2012 at 10:34 PM, Midhun Thampan
wrote:
> Hi All;
>
> Thi
At present there is no such predefined function to give cumulative value as
desired by you. I'll try to tweak n find solution.
Good Night ...
Cheerz n Thanks
Rgds//Vabz
-Original Message-
From: shashank bhosle
Sender: excel-macros@googlegroups.com
Date: Tue, 11 Sep 2012 01:56:56
To: e
impressive Vaibhav .this will reduced my task, time drastically . just one more
why we cant the results for the % column feature from Pivot for the same.
From: Vabz
To: excel-macros@googlegroups.com
Sent: Monday, 10 September 2012 5:25 PM
Subject: $$Excel-Macros$$ Re: automatic update totals i
Thanks all for their great support to solve this problem.
On Mon, Sep 10, 2012 at 8:27 PM, Rajan_Verma wrote:
> *Would it be simple for you*
>
> * *
>
> *Function SplitString(rngRange As Range) As Variant*
>
> *SplitString = Split(rngRange.Value, ",")*
>
> *End Function*
>
> * *
>
> *See the
See the attached
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Bhange
Sent: 08 September 2012 2:03
To: excel-macros@googlegroups.com
Subject: FW: $$Excel-Macros$$ countdown mac
WHEW!
I was "incommunicado" for the last 3 days...
Just spent the last 40 minutes sorting through 246 unread emails.
Started by sorting by Subject and deleting anything with:
Re: $$Excel-Macros$$ Re:
Re: $$Excel-Macros$$ URGENT
Re: $$Excel-Macros$$ Please Help
THAT took care of 100+ ...
I MIGHT
Did you not like the solution I provided?
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
---
First of all,
Your statement of work and you program is backwards.
You SAID:
"... if matched update the value of Col B to Col. F and the value of Col D to
Col H"
but your program says:
Cells(r1, "f") = Cells(r, "b")
Cells(r1, "h") = Cells(r, "d")
which is setting "F" to "B", not "B" to "F"...
j
Can you attached sample data file?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Siraj Momin (BTG)
Sent: 10 September 2012 7:11
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MATCHING T
As I said, I would simply use TTC
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Monday, September 10, 2012 9:24 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Guil
On Sunday, September 9, 2012 11:50:05 PM UTC+4, prkhan56 wrote:
>
> Hello All,
>
> We have a group of employees having various Grades and Position.
>
> 1) A fixed target of sales to be achieved every month as shown in
> Col D (Target).
>
> 2) Each level has different Target Criteria as
Hi Guillett,
I would like to know all possible ways of cutting the string into three
parts. So please do needful by suggesting very simple formula for same.
Thanks !!!
On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 wrote:
> Why clutter it up by using UN necessary formulas to clutter up the
> fil
No
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of attapan_chainarongb...@ck-mail.com
Sent: 10 September 2012 8:51
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MMULT functions quest
See the attached
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rashid Khan
Sent: 10 September 2012 1:20
To: excel-macros
Subject: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per
Ta
Dear members
The following macro I am using to match the values of col A and Col C
with Col E and Col G and if matched update the value of Col B to Col. F
and the value of Col D to Col H. Its working fine on small data but on
large data its taking time can anyone suggest some correction or
impr
Why clutter it up by using UN necessary formulas to clutter up the file?
Unless, of course, this is HOMEWORK
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mangesh Vimay
Sent: Monday, September 10, 2012 6:11 AM
To: excel-macros@googlegroups.com
Subject: Re:
Send ME your file
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Anil Bhange
Sent: Monday, September 10, 2012 3:10 AM
To: excel-macros@googlegroups.com
Subject: FW: $$Excel-Macros$$ Required Revenue started from Date..
Hi Don,
Thanks for your post,
Thanks ALL for the Great Help !!!
On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon wrote:
> In B2 put =LEFT(A2,FIND(",",A2)-1)
> In C2 put =MID(A2,LEN(B2)+2,FIND(",",A2,LEN(B2)+2)-LEN(B2)-2)
> In d2 put =MID(A2,LEN(B2&C2)+3,99)
>
>
> On 10 September 2012 21:04, Mangesh Vimay wrote:
>
>> Hi Friend
In B2 put =LEFT(A2,FIND(",",A2)-1)
In C2 put =MID(A2,LEN(B2)+2,FIND(",",A2,LEN(B2)+2)-LEN(B2)-2)
In d2 put =MID(A2,LEN(B2&C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help to divide the string into three parts.
> The description and sample is given bel
Hi Mangesh,
Try this hope tghis will help you.
=TRIM(MID(SUBSTITUTE($A$1,",",REPT("
",LEN($A$1))),((COLUMNS($A$1:A1)-1)*LEN($A$1))+1,LEN($A$1)))
paste this in B2 then press f2 select B2 to D2 and CSE
regards
Prince
On Monday, September 10, 2012 4:34:33 PM UTC+5:30, Mangesh wrote:
>
>
Option Explicit
Sub checksyssystem1()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim r As Long
Dim r1 As Long
Dim c As Long
For r = 2 To Cells(Rows.Count, "a").End(xlUp).Row
For r1 = 2 To Cells(Rows.Count, "g").End(xlUp).Row
If Cells(r, "a") = Cells(r1, "e"
Wow!!! Thanks.
On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon wrote:
> See attached
>
> On 10 September 2012 05:02, Dhananjay Pinjan wrote:
> > Dear Experts,
> >
> > I need a solution as per my query in attached file.
> >
> > Pl. revert in case of any clarification or any confusion.
> >
> > Reg
Hi Mangesh..
PFA.. Cheers
Rgds//Vabz
On Monday, September 10, 2012 4:41:13 PM UTC+5:30, Mangesh wrote:
>
> Yes u r right.
> I did by using Text to Column option. Its works fine.
> But I need it by using formula.
> Thanks
>
>
> On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar
>
> > wrote:
>
>> Dear
Yes u r right.
I did by using Text to Column option. Its works fine.
But I need it by using formula.
Thanks
On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar wrote:
> Dear Mangesh,
>
> you can use text to colum
>
> Regard
> Manoj
>
>
> On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote:
>
>> Hi
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help to divide the string into three parts.
> The description and sample is given below :
> [image: Inline image 1]
> Waiting for your response.
>
> Thank
Dear members
The following macro I am using to match the values of col A and Col C
with Col E and Col G and if matched update the value of Col B to Col. F
and the value of Col D to Col H. Its working fine on small data but on
large data its taking time can anyone suggest some correction or
impr
Hi Friends,
I need your help to divide the string into three parts.
The description and sample is given below :
[image: Inline image 1]
Waiting for your response.
Thanks.
--
With regards,
*MaNgEsH*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM R
Dear Asa
Can u explain logic step by step.
Rgds//Vabz
On Monday, September 10, 2012 12:43:21 PM UTC+5:30, Asa R. wrote:
>
> Hi Amar,
>
> For the best response to your questions, please explain your question in
> your email message.
>
>
>
> In your follow-up message today, which had neither t
Great thanks.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 10 September 2012 14:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy paste of data from 1 sheet to all sheet at a
time
Dear Amit
Dear Noorain,
Can we also sort all sheet together as I have common column?
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 10 September 2012 14:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy
Dear Amit,
First you copy required data from X1 ti AA10 then group the all sheets
using ctrl+pgDn
then paste, it will applicable for all sheets of Activeworkbook.
On Mon, Sep 10, 2012 at 2:24 PM, Amit Desai (MERU)
wrote:
> If I want to copy paste say data from cell X1 to AA10 from 1 sheet t
Ok Dear..
PFA Cheerz..
Rgds\\Vabz
On Monday, September 10, 2012 1:58:09 PM UTC+5:30, prkhan56 wrote:
>
> Hello,
> Thanks for the solution.
> But I would prefer it to have in respective applicable columns please.
> Regards
> Rashid
> On Monday, September 10, 2012 8:57:27 AM UTC+4, Vabz wrote:
>
>
If I want to copy paste say data from cell X1 to AA10 from 1 sheet to all the
sheets in the same file, is there any shortcut available?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally
Hello,
Thanks for the solution.
But I would prefer it to have in respective applicable columns please.
Regards
Rashid
On Monday, September 10, 2012 8:57:27 AM UTC+4, Vabz wrote:
> Hi
>
> Do you want comm. to be shown in respective applicable col. only or pl
> check soln i have given.
>
> Rgds//V
Hi Don,
Thanks for your post,
I was trying to understand the formula, if we use array formula then below
highlighted cells also getting fixed and formula is not giving the proper
result,
=INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0))
Can you please share the formula in excel file, to understand be
Hi All,
First of all thanks to all experts who helping to the world with their
expertise knowledge and giving such a big opportunity to learn Excel and VBA so
closely.
I also wanted to learn similar kind of logics and participate in discussion for
gaining knowledge of SAP FI CO Module, if you
Here's Microsoft's policy spelled out in their words:
> Visual Basic 6.0 Runtime Usage Inside VBA and Office
>
> Visual Basic for Applications, or VBA, is a distinct technology commonly
used for
> application automation and macros inside of other applications, most
commonly inside
> Microsoft Offic
Hi James,
Microsoft gives warnings about running 64-Bit office, and notifies users in
advance that there will be compatibility issues. With 3rd party components,
those issues are pretty much unavoidable, but its true Microsoft could have
updated their own various components to 64-bit versions for
Hi Amar,
For the best response to your questions, please explain your question in
your email message.
In your follow-up message today, which had neither the question nor the
attachment, it was impossible to tell what you needed help with without
checking the list archives!
Here is a solut
49 matches
Mail list logo
