Re: $$Excel-Macros$$ Re: If excel is your friend, Then what feature will you gift to excel :)

Hi Bhushan, Try the Below... *=vlookup((Left(A1,2)&*"),* *Best Regards,* *Venkat * *Chennai* On Fri, Aug 12, 2011 at 10:54 AM, Bhushan Sabbani wrote: > Everybody in excel use vlookup, sometime what happened the lookup is little > bit different i.e spelling mistake is there instead of bhushan

RE: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Try this Sub INputDate() Range("A1").Value = Application.InputBox("Please Enter YOur date", , , , , , , 1) Range("A1").NumberFormat = "mm/dd/yy" End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Erick C Sent: Friday, August 1

Re: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Hi Erick, Look attached..see if helps... *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 12, 2011 at 12:34 AM, Erick C wrote: > Hi everybody - > > I am hoping someone can help me out. I have a spreadsheet that I am > currently making a macro in VBA. I would like to have an imput box

Re: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Hi Erick, Please see attached sheet... -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 12, 2011 at 12:34 AM, Erick C wrote: > Hi everybody - > > I am hoping someone can help me out. I have a spreadshe

Re: $$Excel-Macros$$ pls help

Hi CC, Use this formula, {=IF(F5:J5<35,"Fail","Pass")} *Best Regards,* *Venkat * *Chennai* On Thu, Aug 11, 2011 at 5:49 PM, vijayexcel m wrote: > Dear All , > > Pls help how to evelate the student performance . > > I want to find below 35 marks consider as fail ,more then 35 its pass > > Pls

Re: $$Excel-Macros$$ pls help

Dear Vijay, See attached sheet if it help. On Thu, Aug 11, 2011 at 5:49 PM, vijayexcel m wrote: > Dear All , > > Pls help how to evelate the student performance . > > I want to find below 35 marks consider as fail ,more then 35 its pass > > Pls find the attached file > > Regards, > vijay

Re: $$Excel-Macros$$ Notes : Help

Thanks Ashish I will check it out. :-) On Fri, Aug 12, 2011 at 4:31 AM, ashish koul wrote: > try these > > > On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hi, >> >> In below code some times I could able to send attachments but some times >> its not

Re: $$Excel-Macros$$ Crime Band Calculation

i GOT IT ... THANKS but i will send the formulae later... its a countifs function... that i used... On Thu, Aug 11, 2011 at 4:28 PM, XLS S wrote: > Hey Henderson, > > Can you attach the worksheet.. > > On Thu, Aug 11, 2011 at 12:44 AM, Donovan Henderson > wrote: > > Good Day, Your Assista

$$Excel-Macros$$ Need Help With an Imput Box in VBA

Hi everybody - I am hoping someone can help me out. I have a spreadsheet that I am currently making a macro in VBA. I would like to have an imput box or text box that will pop up and ask the user to enter a date. This date is then going to be entered into a cell, and I also want to make them us

Re: $$Excel-Macros$$ Like pivot table function

Any special reason for not using "Sumif"/ like : =SUMIF(A:B,H2,B:B) On Thu, Aug 11, 2011 at 7:34 PM, Rajan_Verma wrote: > Can you please explain it more, Do you want to Extract three Record which > total is > ? > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac

Re: $$Excel-Macros$$ Crime Band Calculation

Can you send me the file. On Thu, Aug 11, 2011 at 4:28 PM, XLS S wrote: > Hey Henderson, > > Can you attach the worksheet.. > > On Thu, Aug 11, 2011 at 12:44 AM, Donovan Henderson > wrote: > > Good Day, Your Assistance needed:- > > I have a spreadsheet showing the time of day particular cat

$$Excel-Macros$$ pls help

Dear All , Pls help how to evelate the student performance . I want to find below 35 marks consider as fail ,more then 35 its pass Pls find the attached file Regards, vijay -- -- Some important links for excel use

RE: $$Excel-Macros$$ UNIQUE values in Array

Try this Function, it is storing unique values in Array Function GetUniqueList(rng As Range) As Variant > > On Error Resume Next > >Dim Arr() As Variant >Dim cell As Range >Dim r, c As Integer >Dim i, j As Integer >i = 0: j = 0 > >With Application.Caller >r = .Rows.C

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 25 Messages in 11 Topics

Hey Naidu, Please find the attachment. On Thu, Aug 11, 2011 at 1:47 PM, ck naidu wrote: >>  Pleae help me. >> >>   How to restrict the Special character (!@#$%^&*()_+{}:"<>?) on excel >> sheet with Macros or Data validation. >> >> Thanks >> Chaitu >> >> +91 880-1

Re: $$Excel-Macros$$ Like pivot table function

please see attachment On Thu, Aug 11, 2011 at 7:28 PM, naresh v wrote: > Hi friends, > > I have attached one excel, can you please help me .. > > Regards, > Naresh V > > -- > -- > Some important links for excel users:

$$Excel-Macros$$ Making Excel Project Unviewable

i dont know if this message was delivered or not. so resending it - Original Message > From: hanumant shinde > To: Excel Group > Sent: Tue, 9 August, 2011 3:30:36 AM > Subject: Making Excel Project Unviewable > > Hi how to make project unviewable i.e. when we do Alt+F11 and try to ex

Re: $$Excel-Macros$$ UNIQUE values in Array

Hi, i dont understand wat u mean by i skipped 1. below is my function which is working properly but wat i as thinking is. lets say thr is array with all the values not just unique. lets say it has values as 1,2,3,4,1,2,3,4. so if i pass this array to some array function (which is not developed b

Re: $$Excel-Macros$$ Crime Band Calculation

Hey Henderson, Can you attach the worksheet.. On Thu, Aug 11, 2011 at 12:44 AM, Donovan Henderson wrote: > Good Day, Your Assistance needed:- > I have a spreadsheet showing the time of day particular categories of crime > takes place over a month. I need to now show a crime band chart (ie. t

$$Excel-Macros$$ JOB - Gurgaon

The sender of this email is registered with Naukri.com as Future Focus Infotech Pvt. Ltd. *Dear Candidate,* Dear candidates, We have Urgent openings of VBA for our CMM L5 client for Contract to Hire positions thru Future Focus. we need candidates to join in max of 10 days Req Details VBA Job l

Re: $$Excel-Macros$$ Add 1 to a cell every time the file is opened

Hi John One concern , what if i open the workbook n didnt save it, next time whn i open the workbook it will reflect same number try below code in Thisworkbook module Private Sub Workbook_Open() Sheets("Sheet1").Range("F2").Value = Sheets("Sheet1").Range("F2").Value + 1 End Sub Private Sub Work

$$Excel-Macros$$ Re: ***Macro Code Required to delete Zero value cell and its row***

Hello Prabhu, Also try this; Sub DelZeroRows() Dim LR As Long Dim Length As Long Application.ScreenUpdating = False LR = Range("P" & Rows.Count).End(xlUp).Row Count = Application.WorksheetFunction.CountIf(Range("P2:P" & LR), 0) For Length = LR To 2 Step -1 '<-

$$Excel-Macros$$ Re: ***Macro Code Required to delete Zero value cell and its row***

Hello Prabhu, Also try this; Sub DelZeroRows() Dim LR As Long Dim Length As Long Application.ScreenUpdating = False LR = Range("P" & Rows.Count).End(xlUp).Row Count = Application.WorksheetFunction.CountIf(Range("P2:P" & LR), 0) For Length = LR To 2 Step -1 '<

Re: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row***

or just a little bit neater Sub MtestSAS() Application.ScreenUpdating = False For i =cells(rows.count,”P”).end(xlup).row To 1 Step -1 If Cells(i, 16).Value = 0 Then rows(i).Delete Next i Application.ScreenUpdating = True End Sub From: Mahesh parab Sent: Thursday, August 11, 2011 1:15 PM To: exc

Re: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row***

Hi Prabhu Try Sub Mtest() Dim LR As Long, i As Long LR = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count 'LR = Range("P" & Rows.Count).End(xlUp).Row Application.ScreenUpdating = False For i = LR To 1 Step -1 If Cells(i, 16).Value = 0 Then Cells(i, 16).EntireRow.Delete Next i Applicat

RE: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row***

Hi Mahesh, Find below coding to delete the contains "0" value from 13th row of column "P". Sub Zero_data() Dim Firstrow As Long Dim Lastrow As Long Dim Lrow As Long Dim CalcMode As Long Dim ViewMode As Long Dim rng As Range With Application CalcMode = .Calcul

Re: $$Excel-Macros$$ UNIQUE values in Array

If I recall properly, your function skipped 1. How do you want it presented??? -Original Message- From: hanumant shinde Sent: Thursday, August 11, 2011 11:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ UNIQUE values in Array Thanks but this will not work for me.

Re: $$Excel-Macros$$ UNIQUE values in Array

Thanks but this will not work for me. i have already developed a function but i was thinking there must be some array function which will store just unique values in ARRAY but i guess now there's none. anyways thank for your help. --- On Tue, 9/8/11, dguillett1 wrote: > From: dguillett1 > Sub

$$Excel-Macros$$ Re: Like pivot table function

Hello Naresh, Use SUMIF with SUMPRODUCT, =SUMPRODUCT(SUMIF(A:A,H2:H4,B:B)) HTH Haseeb For fre help visit; http://www.excelfox.com/forum/forum.php -- -- Some important links for excel users: 1. Follow us on TWI

Re: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row***

Hi Mahesh, It is deleting entire row wherever zero appearing. But i required in a partiuclar column if Zero value found we need to delete entire row. Ex. If we use base as "P" column, In 13th row of "P" column contains "0" value it has to delete entire 13th Row. It should not search other colu

RE: $$Excel-Macros$$ VB Code Require for Data Compilation

Have a look at the attached workbook. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de vickey Envoyé : mercredi 10 août 2011 18:53 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ VB Code Require for Data Compilation H

RE: $$Excel-Macros$$ copy selected range to target with params

See if it helps After select the Range which need to be Copies Press Alt+F8 and Run the Macro Show, -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Seba Sent: Wednesday, August 10, 2011 8:07 PM To: MS EXCEL AND VBA MACROS Subject:

Re: $$Excel-Macros$$ Like pivot table function

=SUMPRODUCT((A2:A22={"a","c","g"})*B2:B22) -Original Message- From: naresh v Sent: Thursday, August 11, 2011 8:58 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Like pivot table function Hi friends, I have attached one excel, can you please help me .. Regards, Naresh

RE: $$Excel-Macros$$ VB Code Require for Data Compilation

Hello, Try : Sub Test() Dim c As Range, Ctr As Long, Fam As Long With Sheets("Sheet1") Tabl = .Range(.[A1], .Cells(.Rows.Count, 6).End(xlUp)) End With With Sheets("Sheet3") .[A1] = "Srno" .[B1] = "Name" .[C1] = "Address" .[D1] = "DOB" .[E1] = "EMPID" .

RE: $$Excel-Macros$$ Like pivot table function

Can you please explain it more, Do you want to Extract three Record which total is ? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naresh v Sent: Thursday, August 11, 2011 7:28 PM To: excel-macros@googlegroups.com Subject: $$Exce

$$Excel-Macros$$ Like pivot table function

Hi friends, I have attached one excel, can you please help me .. Regards, Naresh V -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ Split data order wise New Excel workbook

Put this macro into a regular module in the Bif file to get the number from the data file Option Explicit Sub GetID_SAS() Dim lr As Long Dim myid As String Application.ScreenUpdating = False Application.DisplayAlerts = False myid = InputBox("ID to get, ie 103") Workbooks.Open Filename:="Tota

RE: $$Excel-Macros$$ Split data order wise New Excel workbook

Try : Sub Parse() Dim Rg As Range, c As Range, Dict As Object, Rg1 As Range Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Set Dict = CreateObject("Scripting.Dictionary") With S

RE: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

Thanks this one helped me Can you please also reply on below request; I have created several pivot tables & want to update the data source range for all the pivot tables all together. (We do have option as refresh all for applying the preset pivot criteria in all pivots.) Best Regards, Amit

Re: $$Excel-Macros$$ Email : Paste Object

Hi Ashsih, Any help regarding this. Thank you in advance. On Wed, Aug 10, 2011 at 8:14 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi Ashish, > > Thanks for the reply. If u don't mind can u pls help me with the code which > has in attached excel file, because I am little bit conf

Re: $$Excel-Macros$$ Run-time error 1004 when no file selected

after u declare variables use on error goto abc and before end sub abc: exit sub use error handlers http://www.xlpert.com/partG.htm http://www.functionx.com/vbaexcel/Lesson26.htm On Thu, Auon errg 11, 2011 at 1:16 PM, Andy McGooner < andrew_mcni...@yahoo.co.uk> wrote: > Hi All, > > I hav

Re: $$Excel-Macros$$ Split data order wise New Excel workbook

Hi Danial, You can see 14 order names in file of ‘Total order data’ then I want to order wise split data. For example output file of “BIIF_0811_0911_D_ShLead_1”. Similarly I want to 14 files just click in macro. Because I have spent lot time copy paste. -- -- One Team One Dream One Goal Wa

RE: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

See if it helps, I use conditional Formatting From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mrinal saha Sent: Thursday, August 11, 2011 11:46 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Update Data source range & converting "0" t

$$Excel-Macros$$ Run-time error 1004 when no file selected

Hi All, I have a spreadsheet that stores data from a text file, the idea being that it opens the file dialog and i select the relevant text file. The problem is that when i do the file open and press cancel i get the folowing message: Run-time error '1004' false.xls could not be found How do i

RE: $$Excel-Macros$$ Add 1 to a cell every time the file is opened

You can use this : Private Sub Workbook_Open() Range("F2").Value = Range("F2").Value + 1 End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of John A. Smith Sent: Thursday, August 11, 2011 1:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Ma

Re: $$Excel-Macros$$ Import data from notepad to excel

Hi , Go to---> Data tab --->>From text-->Open file and you may get it... You can try Notepad file to open with option and use open with ms Excel... *Best Regards,* *Venkat * *Chennai* * * On Thu, Aug 11, 2011 at 2:40 PM, Rajan_Verma wrote: > Goto Data - Import - From Text > Select your text fil

RE: $$Excel-Macros$$ Import data from notepad to excel

Goto Data - Import - From Text Select your text file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raghavendra Sent: Wednesday, August 10, 2011 11:39 PM To: MS EXCEL AND VBA MACROS Cc: raghavendra@gmail.com Subject: $$Excel-

RE: $$Excel-Macros$$ Macro copy filter data in a new sheet

Replace that code with this code as mention in trailmail From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Simran Singh Sent: Thursday, August 11, 2011 7:30 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro copy filter data in a new s

RE: $$Excel-Macros$$ Split data order wise New Excel workbook

Hi, Can you explain a bit more ? there are 2 workbooks in your archive. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Brajesh Kumar Porwal Envoyé : jeudi 11 août 2011 08:50 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Sp

Re: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

Dear Amit, try it =SUBSTITUTE(E3,"-","0") =Sum(- Range) On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) wrote: > Dear All, > > Please help me on the following; > > 1) I have created several pivot tables & want to update the data source > range for all the pivot tables all together. (We do