Hi Everyone.
Can someone explain I have data in sheet 1 The columns Name and Production
. Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name
and fetch the production . But I have a problem. In the Name Columns There
is Duplicate of A but production is different. So Can you
Hi,
Looking at the data, the easiest you can use is SUMIF, instead of VLOOKUP
Regards,
Aindril
On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna wrote:
> Hi Everyone.
>
> Can someone explain I have data in sheet 1 The columns Name and Production
> . Now I want to fetch data in sheet 2 . I use
hi use sum if function
On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna wrote:
> Hi Everyone.
>
> Can someone explain I have data in sheet 1 The columns Name and Production
> . Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name
> and fetch the production . But I have a pro
Hi Friends
I have written following Macro to Add worksheet if it is not Exists in the
work book , but it is not working as it is not recognized Sheet is exits and
it always add one more work sheet.
Please help
Regards
krupesh
Option Explicit
Private Function SheetExist(Sname As String, Optiona
Hi Bhavya,
Try usinf sumif function instead, it will help you get the sum.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: bhavya khanna
Sender: excel-macros@googlegroups.com
Date: Sun, 14 Nov 2010 12:55:47
To: ;
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-M
use SUMIF Formula
On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna wrote:
> Hi Everyone.
>
> Can someone explain I have data in sheet 1 The columns Name and Production
> . Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name
> and fetch the production . But I have a problem.
Please Help Me
How to create automatic code in the attachment
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gro
Can u explain logic of using ABC
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ratu elissa
Sender: excel-macros@googlegroups.com
Date: Sun, 14 Nov 2010 16:52:36
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ 3 last digit
Please Help Me
How to cr
try this code
Sub check()
Dim i As Long
Dim s, k As String
s = InputBox("enter the sheet name to be added")
For i = 1 To Worksheets.Count
k = Worksheets(i).Name
If UCase(k) = UCase(s) Then
MsgBox "Sheet Already Exists"
Exit Sub
End If
Next i
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(
Hi,
Write this formula in cell B5 and copy down wherever you require;
=if(value(left(right(E5,3),1))=6,"800"&right(E5,3),"ABC-"&right(E5,3))
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ratu elissa
Sender: excel-macros@googlegroups.com
Date: Sun, 14 Nov 2010 16:52:36
I've been seeking a solution to what would appear to be a simple
problem.
OK, I get my lotto tickets. And usually, on the site I can check the
history to see if my lotto numbers have come up.
That's fine if you have only one ticket you're checking, but what if
you play the same five tickets every
Hi Krupesh,
I have written below code for you. Its working fine, you can customize it as
per your need. Hope this will help you.
Sub Find_Sheet()
Dim sh As Worksheet
Dim sTemp As String
sTemp = InputBox("Please enter the sheet name to find:")
For Each sh In ActiveWorkbook.Sheets
If sh.Name =
Hi,
I will also suggest to use sumif function for this purpose.
Regards,
Deepak Rai
On Sun, Nov 14, 2010 at 2:51 PM, ratu elissa wrote:
> use SUMIF Formula
>
>
> On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna wrote:
>
>> Hi Everyone.
>>
>> Can someone explain I have data in sheet 1 The columns
hello to all !
I'm trying to make a shape in an userform,
and, to make longuer longuer this shape
like a progress bar for a time duration.
for exemple, my duration is 45 minutes.
the max shape longuest side represent 45 minutes.
Every 1 minute i want to increment this shape inside my userform.
Hi,
I have 20 ppl that i need to put in 4 groups with 5 each:
First time
Group 1: 1,2,3,4,5
Group 2: 6,7,8,9,10
Group 3: 11,12,13,14,15
Group 4: 16,17,18,19,20
The next week i want to form 4 new groups. However aiming to have as
few ppl working together with ppl that they were in group with
prev
Excellent one,,,its working
Is it possbile , the result should be 0 , if i give same dates for both.
On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> =IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") &
> IF(MONTH(A1) - MO
16 matches
Mail list logo
