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 [mailto:prince141...@gmail.com]
Sent: 05 March 2013 11:04
To: excel-macros@googlegroups.com
Cc: 'Prince'; Manjunath Narayanappa
Subject: Re: $$Excel-Macros$$Extract information
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 calculated for entire week in sheet 2( total no
of Resolution , Logging & Q.C performed & time spend for it)
Can we use macros for this.
Thanks
Manjunath
From: Prince [mailto:prince...@gmail.com]
Sent: 05 March 2013 10:39
To: excel-...@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: $$Excel-Macros$$Extract information
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,
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
For Aon’s standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
Aon UK Limited
Registered Office: 8 Devonshire Square, London EC2M 4PL
Registered in London No. 210725 . VAT Registration No. 480 8401 48
Aon UK Limited is authorised and regulated by the Financial Services Authority
in respect of insurance mediation activities only.
________________________________
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon’s standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
Aon UK Limited
Registered Office: 8 Devonshire Square, London EC2M 4PL
Registered in London No. 210725 . VAT Registration No. 480 8401 48
Aon UK Limited is authorised and regulated by the Financial Services Authority
in respect of insurance mediation activities only.
________________________________
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon’s standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
Aon UK Limited
Registered Office: 8 Devonshire Square, London EC2M 4PL
Registered in London No. 210725 . VAT Registration No. 480 8401 48
Aon UK Limited is authorised and regulated by the Financial Services Authority
in respect of insurance mediation activities only.
--
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 titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
