Sorry, I don't really understand your point.
I realise VSTO will be the way to go, I don't really have many issues with
that. My point is that I pay MS a lot of money, as do my clients. Solutions
have been built in good faith that MS will maintain backwards
compatibility, and they are
PFA
Cheersss!
Rgds//Vabz
On Monday, September 10, 2012 10:26:32 AM UTC+5:30, amar takale wrote:
Hi All Experts
Pls suggestion for required formula
On Fri, Sep 7, 2012 at 7:18 PM, amar takale amart...@gmail.comjavascript:
wrote:
--
Join official facebook page of this forum @
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
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
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 Office
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
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:IV20,0))
Can you please share the formula in excel file, to understand
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//Vabz
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
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:
Hi
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$$
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 the
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
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
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
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 kumarmanoj.11...@gmail.comwrote:
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh
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
Wow!!! Thanks.
On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon da...@grugeon.com.au wrote:
See attached
On 10 September 2012 05:02, Dhananjay Pinjan dppin...@gmail.com wrote:
Dear Experts,
I need a solution as per my query in attached file.
Pl. revert in case of any clarification or
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) And
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:
Hi
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(B2C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay mangesh.da...@gmail.com wrote:
Hi Friends,
I need your help to divide the string into three parts.
The description and
Thanks ALL for the Great Help !!!
On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon da...@grugeon.com.au 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(B2C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay
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,
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:
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
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
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
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 dguille...@gmail.com wrote:
Why clutter it up by using UN necessary formulas to
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 shown in
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
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
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...
just so we're
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
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
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
Thanks all for their great support to solve this problem.
On Mon, Sep 10, 2012 at 8:27 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Would it be simple for you*
* *
*Function SplitString(rngRange As Range) As Variant*
*SplitString = Split(rngRange.Value, ,)*
*End Function*
* *
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 in.vaib...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, 10 September 2012 5:25 PM
Subject: $$Excel-Macros$$ Re:
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 catchshashankbho...@yahoo.co.in
Sender: excel-macros@googlegroups.com
Date:
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
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 sheet
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:
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
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
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, since
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 and
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
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 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
47 matches
Mail list logo