ya It will be helpful who needs job.
Thanks,
Anil
On Tue, Mar 5, 2013 at 1:24 PM, Surbhi Agarwal surbhi.agarwal0...@gmail.com
wrote:
Thanks Pankaj for this post. I think no one face any type of problem if
some one post job on a wall of this group. Because it would be help of some
one if
Dear Experts,
In the above attachment, I have a data in Sheet1 in which we update on daily
basis.
With the help of macros, can I extract same information in sheet2 with one click
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
Hi frends
can you pls tel me what is the difference between odbcconnection object and
adodb.connection object and oledbconnection object
Sent from Samsung Mobile
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of
Dear Export,
Please help me attached file.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Hi Shaikh,
something is missing in your data
what is the mean of Column D (% (On+Off Rte)) ... i thing Column A (Call
Pln) + Column B(Prod (On Rte))
if yes then put formula in column d = A2/C2
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 4:01 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
Hi Kunldeep,
Thanks ...good stuff
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 10:58 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
PFA..
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com ||
Hi Manjunath,
Do you want to get the same information to be pasted on the sheet2 with
same information as it is on sheet1 or somthing else is required. Please
explain bit more.
Regards
Prince
On Tuesday, 5 March 2013 14:19:02 UTC+5:30, Manjunath Narayanappa wrote:
Dear Experts,
if i m right you may be expecting this :
=IF(IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2)))=100%,IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2))),)
in D2 and drag
regards
prince
On Tuesday, 5 March 2013 16:01:30 UTC+5:30, Shaikh Iqbal wrote:
Dear Export,
Please help me attached file.
Share your workbook and some sample data.
Regards
Prince
On Tuesday, 5 March 2013 15:53:51 UTC+5:30, Bheema Shankar wrote:
Dear friends
I placed my data in worksheet1 of workbook1 pertaining to the employees
of an organisation by giving a unique ID no.in Column A.
I placed a textbox on
so you can use same formula with if condition
On Tue, Mar 5, 2013 at 4:16 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
Hi,
If may Prod (On+Off Rte) CallPlan then output in column only 100% not
goes to 126%
On 5 March 2013 16:06, xlstime xlst...@gmail.com wrote:
Hi Shaikh,
something
Hi Prince,
We update on daily basis on sheet1, for Monday to Friday of each individuals
I want same information to be calculated for entire week in sheet 2( total no
of Resolution , LoggingQ.C performed time spend for it)
Can we use macros for this.
Thanks
Manjunath
From: Prince
Prince
If Column *C* Prod (On+Off Rte) CallPlan then output in column D only
100% not goes to 126%
On 5 March 2013 16:15, Prince prince141...@gmail.com wrote:
if i m right you may be expecting this :
So how calculation on sheet2 has done please explain. With an example.
Regards
Prince
On Tuesday, 5 March 2013 16:25:15 UTC+5:30, Manjunath Narayanappa wrote:
Hi Prince,
We update on daily basis on sheet1, for Monday to Friday of each
individuals
I want same information to be
try this
=IF((C2/A2)100%,100%,(C2/A2))
On Tue, Mar 5, 2013 at 4:24 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote:
Please explain
On 5 March 2013 16:20, xlstime xlst...@gmail.com wrote:
so you can use same formula with if condition
On Tue, Mar 5, 2013 at 4:16 PM, Shaikh Iqbal
you mean to say sheet1 data every day or every click consolidate in sheet2
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 4:25 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
Hi Prince,
We update on daily basis on sheet1, for Monday to Friday of each
individuals
I want same
Example : Aijaz has done 81 resolution time spend 32:00:00 for entire week
Jino has done 50 resolution time spend 20:00:00 for
entire week
Same I want for entire team total time spend total no of Resolution , Logging
Q.C performed
Thanks
Manjunath
From: Prince
=IF(IF(ISERROR(C2/A2),,(C2/A2))=1,100%,)
Regards
Prince
On Tuesday, 5 March 2013 16:31:37 UTC+5:30, Shaikh Iqbal wrote:
Prince
If Column *C* Prod (On+Off Rte) CallPlan then output in column D only
100% not goes to 126%
On 5 March 2013 16:15, Prince prince...@gmail.com javascript:
Yes
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of xlstime
Sent: 05 March 2013 11:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$Extract information
you mean to say sheet1 data every day or every click consolidate in sheet2
Enjoy
Team
Yes
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 05 March 2013 11:18
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$Extract information
Yes
From: excel-macros@googlegroups.com
Prince,
But my column C Prod (On+Off Rte)Callpan then actual % should be showing.
On 5 March 2013 16:48, Prince prince141...@gmail.com wrote:
=IF(IF(ISERROR(C2/A2),,(C2/A2))=1,100%,)
Regards
Prince
On Tuesday, 5 March 2013 16:31:37 UTC+5:30, Shaikh Iqbal wrote:
Prince
If Column *C*
Dear Member's
Having one file which is properly showing Million value in my computer
but it is not showing the correctly in other two users system. We have
installed MS-Excel 2007. I have tried to Custom the formula as per my
system but it is failed L
Thanks in advance for your fast
Please share file if is it possible
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 6:49 PM, Virkar,Nilesh nil...@lechlerindia.comwrote:
Dear Member’s
** **
Having one file which is properly showing Million value in my computer but
it is not showing the correctly in other two users system. We
Can some one help me on the below
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 05 March 2013 11:20
To: 'xlstime'
Cc: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$Extract information
Yes
From:
Sorry Team file sharing is not possible.
Regards
Nilesh Virkar
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of xlstime
Sent: Tuesday, March 05, 2013 7:11 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Million value issue
Hi Team,
The problem has been solved. This was because of Regional settings.
Thanks Swapnil.
Best Regards
Nilesh
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Swapnil Palande
Sent: Tuesday, March 05, 2013 7:45 PM
To:
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
would like to BLANK or DELETE the numeric 0 , [Other cells may contain
any ALPHA-NUMERIC values. ] Pl Help.
=mangal ho
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
please share some example
.
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar khadilka...@gmail.comwrote:
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I
would like to BLANK or DELETE the numeric 0 , [Other cells may
Why don't you use the option
'Show zero in cells that have zero value', in the advanced tab of Excel
options (Excel 2007)
Sam Mathai Chacko
On Tue, Mar 5, 2013 at 9:48 PM, Somnath Khadilkar khadilka...@gmail.comwrote:
Dear Sir,
I have ANY excel sheet ,some cells have value ZERO [ numeric
have u tried using simple find and replace to replace all 0 with blank
[image: Inline image 1]
Regards
Ashish
On Tue, Mar 5, 2013 at 10:02 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Why don't you use the option
'Show zero in cells that have zero value', in the advanced tab of Excel
I have a download into Excel with start and stop cells which contain the
date/time. I need help making my formula work please to get the NET
minutes.
Please see my attached problem example.
Thank you for being here (again).
Very Grateful,
John
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Just remove starting space from the date
On Tue, Mar 5, 2013 at 9:54 AM, John A. Smith johnasmit...@gmail.comwrote:
I have a download into Excel with start and stop cells which contain the
date/time. I need help making my formula work please to get the NET
minutes.
Please see my attached
Thank you very much for your helpful swift reply...
John
On Tue, Mar 5, 2013 at 11:55 AM, rajan verma rajanverma1...@gmail.comwrote:
Just remove starting space from the date
On Tue, Mar 5, 2013 at 9:54 AM, John A. Smith johnasmit...@gmail.comwrote:
I have a download into Excel
Hi Guys,
is it possible to shuffle cell value
for example
cell a1 value is 1234
i want 4321,2134,4123 like
Thanks in advance
.
Enjoy
Team XLS
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
so you want all possible unique combination??
On Tue, Mar 5, 2013 at 10:11 AM, xlstime xlst...@gmail.com wrote:
Hi Guys,
is it possible to shuffle cell value
for example
cell a1 value is 1234
i want 4321,2134,4123 like
Thanks in advance
.
Enjoy
Team XLS
Excellent, that saves a step. Thank you very much.
John
On Tue, Mar 5, 2013 at 12:05 PM, xlstime xlst...@gmail.com wrote:
use your formula with value and trim formula
.
Enjoy
Team XLS
On Tue, Mar 5, 2013 at 10:24 PM, John A. Smith johnasmit...@gmail.comwrote:
Dear Experts
I have disable SAVEAS option from excel
Thanks
Manjunath
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Hi manjunath,
Use the following code.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI = True Then Cancel = True
End Sub
On Tue, Mar 5, 2013 at 11:53 PM, Manjunath Narayanappa
manjunath.n1...@gmail.com wrote:
Dear Experts
I
Dear Pravin,
Pl share the workbook .
Warm Regards,
Gawli Anil
On Tue, Mar 5, 2013 at 6:56 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hello Friends,
Pl note, I am using the following VB code to gather the data from
different sheets. Once it was worked fine. But now whenever I am trying
PLS HELP ME
-- Forwarded message --
From: kannan excel kannan.ex...@gmail.com
Date: Tue, Feb 26, 2013 at 11:59 AM
Subject: URGENT PLS HELP ME IN EXCEL WORK
To: Google excel-macros@googlegroups.com, nishant mendiratta
nishant.mendira...@gmail.com, amit.de...@merucabs.com
Hi,
Hi all
I need to change the color of a cell through Macro
using following code
===
Sub Main
End Sub
Function Change_Color()
ActiveCell.Interior.ColorIndex = 36
End Function
That throws run time error 'Object is not set'
Can any one suggest
40 matches
Mail list logo