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

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

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

Dear Puttu, Try it.. =IFERROR(IF(VLOOKUP(A2,C5:C9,1,0),YES, ),) On Fri, Feb 25, 2011 at 5:22 PM, Puttu * puttu...@gmail.com 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)

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 * puttu...@gmail.com 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

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

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 * puttu...@gmail.com wrote: Hi Experts, I have

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

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 vikask...@gmail.com wrote: Hi Puttu, if you are using Excel 2007 then use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0), YES, ),) AND 2003

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

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

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

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

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

Thanks a ton Rohan! Long Live, Excel-Macro group. Cheers Kamal On Wed, Feb 23, 2011 at 5:15 AM, Rohan Young rohan.j...@gmail.com wrote: HI Kamal, Please see the attachment if it helps, Regards ROHAN On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

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

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 --

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

Dear Excel Guru Please help Regards' Jitender On 24 February 2011 19:16, Jitender kumar jk9779771...@gmail.com 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

$$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 --

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

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

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

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

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

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 =

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

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

$$Excel-Macros$$ Cannot remove rows

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? --

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

Try this IF(VLOOKUP(A3,$C$5:$C$9,1,0),YES, ) On Fri, Feb 25, 2011 at 6:32 PM, Puttu * puttu...@gmail.com 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 vikask...@gmail.comwrote: Hi