date:20110225

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

2011-02-25 Thread Mukesh Kumar Jha

Hi Puttu,

Please find attached solved sheet.

Thanks
Mukesh
  - Original Message - 
  From: Puttu * 
  To: excel-macros@googlegroups.com 
  Cc: Rohan Young 
  Sent: Friday, February 25, 2011 5:37 PM
  Subject: Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula


  Attached is the question with attachment. Please help me out


  On Fri, Feb 25, 2011 at 5:22 PM, Puttu *  wrote:

No Still not working

  2678
 
 YES
 This is fine
 
  2558
 
 #N/A
 This one I want as blank (if the data doesn't match then it should 
show blank cell)
 
  
 
 #N/A
 This one I want as blank (if the data doesn't match then it should 
show blank cell)
 



On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young  wrote:

  Hi Puttu, 


  it is working well see the attachment, r u sure you are putting right 
criteria in your data, pls. send the sample sheet for understanding,


  Thanks & Regd


  ROHAN 



  On Thu, Feb 24, 2011 at 8:16 PM, Puttu *  wrote:

Team, Please help me on this


On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:

  Hi Experts,

  I have two questions

  1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") 
in this if any error it shows as #N/A, insted of this i want it show as balnk, 
how to do this? 

  2. In Vlookup formula if the result is found in different excel, i 
want that sheet name to be visibled in the result

  XXX is foun d in Sheet 1, in vlookup result it should show as "Found 
in Sheet 1

  Your help will be greatly appriciated.
  -- 
  Putta


  -- 
  
--
  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=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel




-- 
Putta


-- 

--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




  -- 
  
--
  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=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel





-- 
Putta




  -- 
  Putta


  -- 
  
--
  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=1871310
  3. Excel tutorials at http://www.excel-macros.blogspot.com
  4. Learn VBA Macros at http://www.quickvba.blogspot.com
  5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com
   
  <><><><><><><><><><><><><><><><><><><><><><>
  Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://tw

Re: $$Excel-Macros$$ consolidating multiple sheets to one sheet

2011-02-25 Thread ashish koul

see if it helps

On Sat, Feb 26, 2011 at 4:43 AM, Steve  wrote:

> I am trying to write something that will consolidate about 5 sheets
> into 1 final sheet.  The hitch is, there will be a different number of
> lines in each sheet each time. And, I don't want to copy the first 6
> lines of each sheet (headers).
>
> Anybody that can help me with this?
>
> I'd like to just put on page 6 the address for the cells in the other
> sheets, but I'm not sure if that'll work.  Sounds like a macro is in
> order, but I'm open to suggestion.
>
> Example.
>
> Sheet 1 has 30 lines (including 6 lines of headers)
> Sheet 2 has 40 lines (including 6 lines of headers)
> Sheet 3 has 10 lines (including 6 lines of headers)
> Sheet 4 has 15 lines (including 6 lines of headers)
> Sheet 5 has 80 lines (including 6 lines of headers)
>
> The remaning lines in all the sheets will be blank.
>
> I would like to have Sheet 6 be...
>
> Sheet 1 lines 7-30 followed by (24 lines)
> Sheet 2 lines 7-40 followed by (34 lines)
> Sheet 3 lines 7-10 followed by (4 lines)
> Sheet 4 lines 7-15 followed by (9 lines)
> Sheet 5 lines 7-80 (74 lines)
>
> Sheet 6 would have 1 line of header (which would be unique to that
> sheet, which I can enter manually and have the rest of the process
> start on line 2, or copy from sheet 5) followed by 145 lines of data.
>
> I'm new to thisw stuff, but you guys have always been very helpful to
> me before (and you make it look so easy)
>
> If more explanation is needed you can send questions through my gmail
> acc't to scasko.
>
> Thanks,
> Steve
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


merge sheets.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

2011-02-25 Thread ashish koul

Try this
IF(VLOOKUP(A3,$C$5:$C$9,1,0),"YES", " ")

On Fri, Feb 25, 2011 at 6:32 PM, Puttu *  wrote:

> Thanks a lot it worked out me. Cold you please help on my second question
> in Attached is the sheet
>
>
> On Fri, Feb 25, 2011 at 5:42 PM, Vikas Chouhan wrote:
>
>> Hi Puttu,
>>
>>
>> if you are using Excel 2007 then
>>
>> use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),"
>> YES", " "),"")
>>
>> AND 2003 then
>>
>> =ISERROR((IF(VLOOKUP(C12,Ukey,1,0),"
>> YES", " "),"",(IF(VLOOKUP(C12,Ukey,1,0),"
>> YES", " "))
>>
>>
>>
>>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I have two questions
>>>
>>> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
>>> this if any error it shows as #N/A, insted of this i want it show as balnk,
>>> how to do this?
>>>
>>> 2. In Vlookup formula if the result is found in different excel, i want
>>> that sheet name to be visibled in the result
>>>
>>> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
>>> Sheet 1
>>> Your help will be greatly appriciated.
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> 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=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> One Team One Dream One Goal
>>
>> Warm Regards,
>> *Vikas Chauhan*
>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
>> 9911868518,
>> "We can't Spell S_*ccess *without U"
>>
>> Life is Very beautiful !!!
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>> `•.¸.•´.
>>
>
>
>
> --
> Putta
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ consolidating multiple sheets to one sheet

2011-02-25 Thread Steve

I am trying to write something that will consolidate about 5 sheets
into 1 final sheet.  The hitch is, there will be a different number of
lines in each sheet each time. And, I don't want to copy the first 6
lines of each sheet (headers).

Anybody that can help me with this?

I'd like to just put on page 6 the address for the cells in the other
sheets, but I'm not sure if that'll work.  Sounds like a macro is in
order, but I'm open to suggestion.

Example.

Sheet 1 has 30 lines (including 6 lines of headers)
Sheet 2 has 40 lines (including 6 lines of headers)
Sheet 3 has 10 lines (including 6 lines of headers)
Sheet 4 has 15 lines (including 6 lines of headers)
Sheet 5 has 80 lines (including 6 lines of headers)

The remaning lines in all the sheets will be blank.

I would like to have Sheet 6 be...

Sheet 1 lines 7-30 followed by (24 lines)
Sheet 2 lines 7-40 followed by (34 lines)
Sheet 3 lines 7-10 followed by (4 lines)
Sheet 4 lines 7-15 followed by (9 lines)
Sheet 5 lines 7-80 (74 lines)

Sheet 6 would have 1 line of header (which would be unique to that
sheet, which I can enter manually and have the rest of the process
start on line 2, or copy from sheet 5) followed by 145 lines of data.

I'm new to thisw stuff, but you guys have always been very helpful to
me before (and you make it look so easy)

If more explanation is needed you can send questions through my gmail
acc't to scasko.

Thanks,
Steve

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Cannot remove rows

2011-02-25 Thread SteveO

MS Excel 2007,  Office 7:  I consider myself to be power user.  I have
a spreadsheet with roughly, 12,000 rows.
I went to delete 120 rows at about row 10,000 and they will not go
away, e.g. move up the non-empty rows below.  This was working fine
but now it wont.  Any ideas?

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ errors in my code

2011-02-25 Thread Paul Schreiner

If you indent your code for each if segment and loop section, you'll find
that the Endif is WITHIN your For loop
Simply reverse the order of the Next and EndIf statements:


Do Until wks.Cells(i, 1).Value = ""
    If wks.Cells(i, 1).Value <> "" Then
   For y = 1 To 1
 wks.Cells(i, y).Value = Left(sFilename, 5).Value
   Next
    End If
Loop

Paul





From: wkeanebaker 
To: MS EXCEL AND VBA MACROS 
Sent: Fri, February 25, 2011 1:06:17 PM
Subject: $$Excel-Macros$$ errors in my code

Do Until wks.Cells(i, 1).Value = ""

    If wks.Cells(i, 1).Value <> "" Then

    For y = 1 To 1
    wks.Cells(i, y).Value = Left(sFilename, 5).Value

    End If

    Next

Loop

Im catching a end if without block if and then a loop without do error
but im lost, help

-- 
--

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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to use sumproduct Formula in Macro

2011-02-25 Thread maulik desai

Thanks Daniel for a great help but

i appriciate if you can able to give me the complete macro code for my file
so i have no need to modify any code

hope you understood it is easy for you to update the complete code rather
then me

thanks once again.

On Wed, Feb 23, 2011 at 10:29 PM, Daniel  wrote:

>  Here is an example to replace sheet Batch column K with a macro:
>
>
>
> Sub test()
>
> 'sheet Batch column K
>
> With Sheets("Batch")
>
> For Each c In .Range(.[A7], .[A65536].End(xlUp))
>
> .Cells(c.Row, 11) = Evaluate("sumproduct((DB!$A$2:$A$46803=Batch!$A" &
> c.Row & ")*(DB!$AP$2:$AP$46803=""Yes""))")
>
> Next c
>
> End With
>
> End Sub
>
>
>
> You should run the macro each time you change, add or delete a value in
> column A; place the following macro in the sheet module :
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> If Target.Column = 1 And Target.Row > 6 Then
>
> Cells(Target.Row, 11) =
> Evaluate("sumproduct((DB!$A$2:$A$46803=Batch!$A" _
>
> & Target.Row & ")*(DB!$AP$2:$AP$46803=""Yes""))")
>
> End If
>
> End Sub
>
>
>
> You’ll have to do the same for others formulas.
>
> Regards.
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* maulik desai
> *Envoyé :* mardi 22 février 2011 18:55
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ How to use sumproduct Formula in Macro
>
>
>
> I having Database with 4Sheets and i have used Sumproduct Formula in many
> Columns in my database. i have apply the formulas on every columns but the
> prolem is the file becomes very heavy & it take to much time to give the
> output
>
> is there any way to use the samproduct function with the help of macro
>
>
>
> sample file attached i am having large database
>
>
>
> Request you to kindly provide the solution for the same
>
> --
> Thanks & Regards,
> Maulik Desai
> 9967363926
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & Regards,
Maulik Desai
9967363926

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Value Required based on status updation in column

2011-02-25 Thread maulik desai

Thanks

Actually data which i have provided is a part of my database atually in my
database we have details of all candidates who joines on that basis we have
some unique status (given in Current status column") which we have to update
during his trianing but the problem is that we have to update all the staus
manually becusae of this some time error accured so that is why i want it
that

1) when ever any status (out of 31 status only ) updated in A Column in
Sheet1 rest details ( from B to S column) should automatically updated in
that area

For eg:If i am updating "Induction Dropout or Core " in Current status
column rest details (From "Induction In" column to "Production In " column )
should come automatically

For all staus details kindly look into Attachement


   *Current Status* *Induction In* *Induction Dropout* *Core In* *Core
Addition* *MIT Core In* *Total Core In* *Core Out* *Process In* *Process
Addition* *MIT Process In* *Total Process In* *Process Out* *OJT In* *OJT
Addition* *MIT OJT In* *Total OJT in* *OJT Out* *Production In* Induction
Dropout Yes Yes No No No No No No No No No No No No No No No No Core Yes No
Yes No No Yes Core Core Core Core Core Core Core Core Core Core Core Core

Request you to provide me the solution.

On Thu, Feb 24, 2011 at 11:20 PM, Ms-Exl-Learner .  wrote:

> Hi Maulik,
>
> I am sure you will get it resolved if you explain your expectation with
> some more brief about the way of pulling the data with cell reference and
> how it can be derived.
>
> Because you know very well about your data and the way your expected
> result.  But for us the data is a new one and we will be having some more
> interpretations about your actual query and we wont come to know your exact
> requirement until unless you explain it in a better and clear way.
>
> Hope that makes sense :)
>
> ---
> Ms.Exl.Learner
> ---
>
>
> On Wed, Feb 23, 2011 at 10:44 PM, maulik desai wrote:
>
>> Hi ashish sir,
>>
>> thanks u for this ,but can u pls tell me how to use this because when
>> i del any status and enter other in same cell it gives some error and
>> basically i want that when ever any status updated in that column in
>> database rest values should come automatically
>>
>> On 2/23/11, ashish koul  wrote:
>> > see if that helps
>> > On Tue, Feb 22, 2011 at 11:07 PM, maulik desai
>> > wrote:
>> >
>> >>
>> >> In My excel database there are Huge database availble
>> >> for this eg I have given the unique current status (which can be
>> repeted
>> >> many times )
>> >> what I want is when ever Below status updated in "Current status "
>> Column
>> >> Rest colums should give me the value based on status provided In that
>> >>
>> >> This the just small part of the database.
>> >>
>> >> For more infomation kindly ref the attachment
>> >> --
>> >> Thanks & Regards,
>> >> Maulik Desai
>> >> 9967363926
>> >>
>> >> --
>> >>
>> >>
>> --
>> >> 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=1871310
>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >>
>> >> To post to this group, send email to excel-macros@googlegroups.com
>> >>
>> >> <><><><><><><><><><><><><><><><><><><><><><>
>> >> Like our page on facebook , Just follow below link
>> >> http://www.facebook.com/discussexcel
>> >>
>> >
>> >
>> >
>> > --
>> > *Regards*
>> > * *
>> > *Ashish Koul*
>> > *akoul*.*blogspot*.com 
>> > *akoul*.wordpress.com 
>> > My Linkedin Profile 
>> >
>> >
>> > P Before printing, think about the environment.
>> >
>> > --
>> >
>> --
>> > 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=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> > http://www.facebook.com/discussexcel
>> >
>>
>> --
>> Sent from my mobile device
>>
>> Thanks & Regards,
>> Maulik Desai
>> 9967363926
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for

$$Excel-Macros$$ errors in my code

2011-02-25 Thread wkeanebaker

Do Until wks.Cells(i, 1).Value = ""

If wks.Cells(i, 1).Value <> "" Then

For y = 1 To 1
wks.Cells(i, y).Value = Left(sFilename, 5).Value

End If

Next

Loop

Im catching a end if without block if and then a loop without do error
but im lost, help

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Urgent required help in excel

2011-02-25 Thread Jitender kumar

Dear Excel Guru Please help

Regards'

Jitender

On 24 February 2011 19:16, Jitender kumar  wrote:

> Dear Excel Guru/Ashish,
>
> Thanks for your valuable solution.But the problem is still here, Because I
> want to print it according to MRP & Dcode wise on different sheet of paper,
> I know page break works but doing page break on every dcode and MRP is very
> tough task wwhen data is too large.Pivot table has ability to do it, so that
> is why i want it in Pivot table. Only drawback that i told in sheet that I
> want MRP against each item and qty, but PIVOT only summarizes the data so I
> cannot repeat MRP on each row of PIVOT.Plz help .How it possible using
> PIVOT/VBA
>
> Regards
>
> Jitender
>
>
>
>
> On 24 February 2011 08:34, ashish koul  wrote:
>
>> see if it helps
>>
>>
>> On Wed, Feb 23, 2011 at 10:34 PM, Jitender kumar 
>> wrote:
>>
>>> Dear ExcelGurus
>>>
>>> I  need help in attached file, problem told in excel sheet.Please help me
>>> in pivot /VBA only
>>>
>>> Thanks
>>>
>>> Jitender
>>>
>>> --
>>>
>>> --
>>> 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=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>>
>> --
>> 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=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need named range or named range book Pivot Table

2011-02-25 Thread ChilExcel

Hi


macro I need to double click PivotTable
 I need to get sheet named range or named range book
 something very similar to "drilldown" but named range in sheet or book

 "contribution"
 If someone needs to shoot macro "drill down" on a sheet of Pivot table,
 or on another sheet  I send a file

-- 
thx



Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro Help - Please!

2011-02-25 Thread kamal shah

Thanks a ton Rohan!

Long Live, Excel-Macro group.


Cheers
Kamal

On Wed, Feb 23, 2011 at 5:15 AM, Rohan Young  wrote:

> HI Kamal,
>
> Please see the attachment if it helps,
>
>
> Regards
>
> ROHAN
>
>
> On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Kamal,
>>
>> Please see attached sheet..if it help..
>>
>> On Mon, Feb 21, 2011 at 11:25 PM, kamal shah  wrote:
>>
>>> Hello Excel Gurus,
>>>
>>> Need small favour from experts,
>>> I have two columns in Excel, I need a macro, where if Column A contains
>>> value as "Step", column B should populate "Complete".
>>> If column A contains VP, Column B should populate "Pass".
>>>
>>>
>>>Step
>>>   Complete
>>>  VP
>>>  Pass
>>>  Step
>>>  Complete
>>>  VP
>>>  Pass
>>>  VP
>>>  Pass
>>>  Step
>>>  Complete
>>>  VP
>>>  Not Run
>>>  Step
>>>  Not Run
>>>  VP
>>>  Not Run
>>>  VP
>>>  Not Run
>>>  Step
>>>  Not Run
>>>  VP
>>>  Not Run
>>>
>>>
>>> Your help is highy appreciated.
>>>
>>>
>>> cheers
>>> Kamal
>>>
>>> --
>>>
>>> --
>>> 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=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>
>> --
>>
>> --
>> 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=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>   --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Insert row based on criteria

2011-02-25 Thread Jason Henke

Hello,

In the attached file I have provided an example of what I am trying to
accomplish via macros.

I import a report into excel that changes each time it's ran. I'm trying to
put a space after each 'group' is ran. As an example we have locations set
up as
A-A-0
A-A-1 ect..to A-C-3

B-A-0 to B-F-3

more data in sheet to show. I would like to insert a row after each area. So
A-A-0 to A-C-3 would be one group. B-A-0 - B-F-3 is another. Not all these
locations will show when the report runs. If needed I can provide a list of
every location that I need this data to sort by (and I can provide groups).

Once the rows are inserted I will be running a macro to place page breaks
after each blank row.. this I already have though.

Regards,
Jason

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


insert_rows.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ regd: drop down button

2011-02-25 Thread naresh v

Hi Experts,

I need some help regarding drop downs.

   Please find the attached sheet for your reference.

   Please help me in this regard.



Thanks and Regards,
Naresh V

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Book3.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

2011-02-25 Thread Puttu *

Thanks a lot it worked out me. Cold you please help on my second question
in Attached is the sheet

On Fri, Feb 25, 2011 at 5:42 PM, Vikas Chouhan  wrote:

> Hi Puttu,
>
>
> if you are using Excel 2007 then
>
> use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),"
> YES", " "),"")
>
> AND 2003 then
>
> =ISERROR((IF(VLOOKUP(C12,Ukey,1,0),"
> YES", " "),"",(IF(VLOOKUP(C12,Ukey,1,0),"
> YES", " "))
>
>
>
>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I have two questions
>>
>> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
>> this if any error it shows as #N/A, insted of this i want it show as balnk,
>> how to do this?
>>
>> 2. In Vlookup formula if the result is found in different excel, i want
>> that sheet name to be visibled in the result
>>
>> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
>> Sheet 1
>> Your help will be greatly appriciated.
>> --
>> Putta
>>
>> --
>>
>> --
>> 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=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> *Vikas Chauhan*
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_*ccess *without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>



-- 
Putta

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Vlookup_SOLVED_ROHAN.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

2011-02-25 Thread Vikas Chouhan

Hi Puttu,


if you are using Excel 2007 then

use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),"
YES", " "),"")

AND 2003 then

=ISERROR((IF(VLOOKUP(C12,Ukey,1,0),"
YES", " "),"",(IF(VLOOKUP(C12,Ukey,1,0),"
YES", " "))



On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:

> Hi Experts,
>
> I have two questions
>
> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
> if any error it shows as #N/A, insted of this i want it show as balnk, how
> to do this?
>
> 2. In Vlookup formula if the result is found in different excel, i want
> that sheet name to be visibled in the result
>
> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
> Sheet 1
> Your help will be greatly appriciated.
> --
> Putta
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
One Team One Dream One Goal

Warm Regards,
*Vikas Chauhan*
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_*ccess *without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

2011-02-25 Thread Puttu *

Attached is the question with attachment. Please help me out

On Fri, Feb 25, 2011 at 5:22 PM, Puttu *  wrote:

> No Still not working
>
>
> 2678
>
>  YES
>
> This is fine
>
> 2558
>
>  #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
> 
>
>  #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
>
>   On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young wrote:
>
>> Hi Puttu,
>>
>> it is working well see the attachment, r u sure you are putting right
>> criteria in your data, pls. send the sample sheet for understanding,
>>
>> Thanks & Regd
>>
>> ROHAN
>>
>>
>> On Thu, Feb 24, 2011 at 8:16 PM, Puttu *  wrote:
>>
>>> Team, Please help me on this
>>>
>>>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>>>
 Hi Experts,

 I have two questions

 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
 this if any error it shows as #N/A, insted of this i want it show as balnk,
 how to do this?

 2. In Vlookup formula if the result is found in different excel, i want
 that sheet name to be visibled in the result

 XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
 Sheet 1
 Your help will be greatly appriciated.
 --
 Putta

 --

 --
 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=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> 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=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>   --
>>
>> --
>> 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=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Vlookup_SOLVED_ROHAN.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

2011-02-25 Thread NOORAIN ANSARI

Dear Puttu,

Try it..

=IFERROR(IF(VLOOKUP(A2,C5:C9,1,0),"YES", " "),"")

On Fri, Feb 25, 2011 at 5:22 PM, Puttu *  wrote:

> No Still not working
>
>
> 2678
>
>  YES
>
> This is fine
>
> 2558
>
>  #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
> 
>
>  #N/A
>
> This one I want as blank (if the data doesn't match then it should show
> blank cell)
>
>
>   On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young wrote:
>
>> Hi Puttu,
>>
>> it is working well see the attachment, r u sure you are putting right
>> criteria in your data, pls. send the sample sheet for understanding,
>>
>> Thanks & Regd
>>
>> ROHAN
>>
>>
>> On Thu, Feb 24, 2011 at 8:16 PM, Puttu *  wrote:
>>
>>> Team, Please help me on this
>>>
>>>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>>>
 Hi Experts,

 I have two questions

 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
 this if any error it shows as #N/A, insted of this i want it show as balnk,
 how to do this?

 2. In Vlookup formula if the result is found in different excel, i want
 that sheet name to be visibled in the result

 XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
 Sheet 1
 Your help will be greatly appriciated.
 --
 Putta

 --

 --
 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=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> 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=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>   --
>>
>> --
>> 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=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Putta
>
> --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

2011-02-25 Thread Puttu *

No Still not working


2678

 YES

This is fine

2558

 #N/A

This one I want as blank (if the data doesn't match then it should show
blank cell)



 #N/A

This one I want as blank (if the data doesn't match then it should show
blank cell)


On Fri, Feb 25, 2011 at 9:48 AM, Rohan Young  wrote:

> Hi Puttu,
>
> it is working well see the attachment, r u sure you are putting right
> criteria in your data, pls. send the sample sheet for understanding,
>
> Thanks & Regd
>
> ROHAN
>
>
> On Thu, Feb 24, 2011 at 8:16 PM, Puttu *  wrote:
>
>> Team, Please help me on this
>>
>>  On Thu, Feb 24, 2011 at 6:13 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I have two questions
>>>
>>> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in
>>> this if any error it shows as #N/A, insted of this i want it show as balnk,
>>> how to do this?
>>>
>>> 2. In Vlookup formula if the result is found in different excel, i want
>>> that sheet name to be visibled in the result
>>>
>>> XXX is foun d in Sheet 1, in vlookup result it should show as "Found in
>>> Sheet 1
>>> Your help will be greatly appriciated.
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> 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=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>>
>> --
>> 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=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>   --
>
> --
> 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=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Putta

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

Re: $$Excel-Macros$$ consolidating multiple sheets to one sheet

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

$$Excel-Macros$$ consolidating multiple sheets to one sheet

$$Excel-Macros$$ Cannot remove rows

Re: $$Excel-Macros$$ errors in my code

Re: $$Excel-Macros$$ How to use sumproduct Formula in Macro

Re: $$Excel-Macros$$ Value Required based on status updation in column

$$Excel-Macros$$ errors in my code

Re: $$Excel-Macros$$ Urgent required help in excel

$$Excel-Macros$$ Need named range or named range book Pivot Table

Re: $$Excel-Macros$$ Macro Help - Please!

$$Excel-Macros$$ Insert row based on criteria

$$Excel-Macros$$ regd: drop down button

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

19 matches

Site Navigation

Mail list logo

Footer information