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
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 shee
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
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 o
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?
--
--
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).Va
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 wrot
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 a
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
--
--
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 br
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
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 a
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
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 impo
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
>
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 t
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
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)
>
> 22
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:
19 matches
Mail list logo
