Hi,
thank you for your effort. This kind of macro would help, I would just
like to improve on the pasting part. I will try and build on your
code. Right now I have to select target sheet and target range for
pasting manually.
I need to upgrade this so that macro will also select the target
apropri
B8
=IF(AND(COUNTIF(B2:B5,1)>=1,COUNTIF(B2:B5,0)=0),5,IF(AND(COUNTIF(B2:B5,1)=0,COUNTIF(B2:B5,0)>=1),1,5-COUNTIF(B2:B5,0)))
=IF(COUNTIF(B2:B5,"NA")=COUNTA(B2:B5),"No
Rating",IF(AND(COUNTIF(B2:B5,1)>=1,COUNTIF(B2:B5,0)=0),5,IF(AND(COUNTIF(B2:B5,1)=0,COUNTIF(B2:B5,0)>=1),1,5-COUNTIF(B2:B5,0
O
May you please explain more how did you calculate rating,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Simran Singh
Sent: Saturday, August 13, 2011 10:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Required Formula to calculate ratin
Right Click on Project , Goto Property VBProject Property , GOto Protection
tab Check the Lock Project For Viewing and enter the Password ,
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hanumant shinde
Sent: Saturday, August 13,
Please retype your e-mail in English or Arabic, becasue this the only languge I
can read. Thanks a lot.
Dr. Atef Gobran
Alexandria Univ.
Faculty of Engineering
Civil Dept.
Alexandria , Egypt.
Tel: 0020166007357
http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif";>@@ Dr.
Atef Gobran @@http
Hi,
I need a formula to calculate the final rating in the attached sheet. There
are possible 14 cases which can happen to calculate the final rating.
Request you to look at those cases and then make the formula.
Thanks in advance.
Regards,
Simran Singh
--
--
sorry, just an exercise I have no questions
all good
thx
2011/8/11 ChilExcel
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
> --
>
> --
> Some
I am sorry, I can not read any language except english.
http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif";>@@ Dr.
Atef Gobran @@http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif";>
From: Abhishek Jain
To: excel-macros@googlegroups.com
Cc: noorain.ans...@gmail.com
Sent: Tuesday
Please my frind, I do not no any languages except english, so please write
your e-mails in english, Thanks alot.
http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif";>@@ Dr.
Atef Gobran @@http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif";>
From: seraj alam
To: "]}eep@ (/)@lik
can u send the file..
On Sat, Aug 13, 2011 at 2:50 AM, hanumant shinde wrote:
> nobody has any idea abt it?
>
>
>
>
> - Original Message
>> From: hanumant shinde
>> To: Excel Group
>> Sent: Fri, 12 August, 2011 3:30:08 AM
>> Subject: $$Excel-Macros$$ Making Excel Project Unvie
nobody has any idea abt it?
- Original Message
> From: hanumant shinde
> To: Excel Group
> Sent: Fri, 12 August, 2011 3:30:08 AM
> Subject: $$Excel-Macros$$ Making Excel Project Unviewable
>
> i dont know if this message was delivered or not. so resending it
>
>
>
> - Or
Received .. THanks
DH
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid
great !!...thnx
On Thu, Aug 11, 2011 at 11:29 PM, ChilExcel wrote:
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
> --
> --
> Some important lin
Also use sumproduct, and count with array
On Fri, Aug 12, 2011 at 2:30 PM, Donovan Henderson
wrote:
> Good Morning,
> Attached please see time range example using the countifs function.
> Regards
> DH
>
> --
> -
I can do this. Please email me at excelvba...@gmail.com
On Fri, Aug 12, 2011 at 9:08 AM, JsinSk wrote:
> Hello, I would like to see about some assistance with the following
> problem, due to some re-arranging in our warehouse I need to have a
> report separate locations on different sheets.
>
>
Hello, I would like to see about some assistance with the following
problem, due to some re-arranging in our warehouse I need to have a
report separate locations on different sheets.
Locations are listed as
AA-A-0
AA-A-1
AA-A-2
AA-A-3
AA-A-4
AA-B-0
AA-B-1
AA-B-2
AA-B-3
AA-B-4
AA-C-0 ... and so on
**
*Experience:* 6 - 10 Years
*Location:* Mumbai
*Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any
Specialization
*Industry Type:* Banking/Financial Services/Broking
*Role:* Business/EDP Analyst
*Functional Area:* ITES/BPO/KPO, Customer Service, Ops.
*Posted Date:* 09 Aug
Pls ignore previous post. I sent the wrong file
Change to vertical>remove all merged cells>use autofilter with SUBTOTAL(109
function
From: Dominic Sundar
Sent: Thursday, August 11, 2011 7:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Forms
Hey there
attach is a copy of an i
Use the following formula.
=SUMIF($A$3:$A$322,$F$3:$F$16,$C$3:$C$322)
On Fri, Aug 12, 2011 at 4:49 PM, naresh v wrote:
> I Have mentioned my problem clearlyplease find attached sheet
>
>
> Regards,
> Naresh V
>
> --
>
> ---
Try this :
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Fso As New Scripting.FileSystemObject
Dim Path As String
Application.FileDialog(msoFileDialogFolderPicker).Title = "Select Folder to
Pick Downloaded Bills"
Applic
This is excellent work. Would you please explain how you have done it.
Your Formula Bar is showing nothing.
Sanjib
On Thu, Aug 11, 2011 at 12:58 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Naresh,
>
> See the attached. You can Add/Delete New/Old entries.
>
> HTH
> Haseeb
Hello Ashish,
I got solution for this issue but I am getting one more error in code as
type mismatch
*Set rnbody1 = Sheets("Details").UsedRange.Copy
rnbody1.Copy
*
On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi Ashsh,
>
> I used ur code but getting
Try this :
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Fso As New Scripting.FileSystemObject
Dim Path As String
Application.FileDialog(msoFileDialogFolderPicker).Title = "Select Folder to
Pick Downloaded Bills"
App
Dear Vikas,
Please try through below link..
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook
On Fri, Aug 12, 2011 at 1:54 PM, vikas gupta wrote:
> Dear All
>
> Please give me the vba code or any other solution
So what ?
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de ChilExcel
Envoyé : jeudi 11 août 2011 20:00
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$
--
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.
Good Morning,
Attached please see time range example using the countifs function.
Regards
DH
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
- Original message
From:"Objectwin Technology India Pvt Ltd"< sumi.kal...@objectwin.com >
Date: 12 Aug 11 12:34:06
Subject: Immd_Wipro Technology_MS Access_Chennai
To:
The sender of this email is registered with Naukri.com as Objectwin
Technology India Pvt Ltd Dear Candidate,This i
Hi Ashsh,
I used ur code but getting error in below lines. I think I need to enable
some reference. Please let me know about this.
*Set Data = New DataObject
Data.GetFromClipboard
*
Thanks,
Chandra Shekar B
On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
>
Please post the same in the link mentioned above.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://w
29 matches
Mail list logo
