Re: $$Excel-Macros$$ Please solve my problem

Thanks once again Always SKM On Fri, Jul 29, 2011 at 9:53 AM, Rajan_Verma wrote: > *See if it helps* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *always online > *Sent:* Friday, July 29, 2011 9:31 AM > *To:* excel-macros@googlegroups

Re: $$Excel-Macros$$ Excel /Adobe

Thanks .Can I just Copy paste as a simple Flash game I dont want to use Excel or Word Is it possible On Tue, Jul 26, 2011 at 6:34 PM, XLS S wrote: > Hye.. > > just click Design mode then cut and paste ... > > for more information please find the attachment.. > > > > > On Tue, Jul 26,

Re: $$Excel-Macros$$ Please solve my problem

Hi, pfa. it may help -- *Great day,* *viper * On Fri, Jul 29, 2011 at 9:53 AM, Rajan_Verma wrote: > *See if it helps* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *always online > *Sent:* Friday, July 29, 2011 9:31 AM > *To:* ex

RE: $$Excel-Macros$$ Please solve my problem

See if it helps From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of always online Sent: Friday, July 29, 2011 9:31 AM To: excel-macros@googlegroups.com Cc: always...@gmail.com Subject: $$Excel-Macros$$ Please solve my problem Hi Friends I'm preparing sal

$$Excel-Macros$$ Please solve my problem

Hi Friends I'm preparing sales report and i find some problem in this attached file. Please give me solution. Thanks in advance Always SKM -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Help needed to comine VBA modules

Thank u very much Daniel,can u help me in naming the sheets created while pivot table being drill down aju On Thu, Jul 28, 2011 at 2:46 PM, Daniel wrote: > Hi, > > You should indicate the file name before the function : > Eg. Personal.xlsb! SpellNumber... > > Regards. >

Re: $$Excel-Macros$$ Restrict access to certain sheets

Please find the link http://www.excel-vba.com/vba-prog-1-1-editor.htm On Fri, Jul 29, 2011 at 5:25 AM, mahamadou lawali wrote: > > Thanks a lot for your help, but I am a beginner in VBA.So would you > guys please break it down for me? I've tried to paste the code and I > really don't know how

Re: $$Excel-Macros$$ Reverse Vlookup

Great Haseeb, Can you tell me something about CHOOSE,OFFST function On Fri, Jul 29, 2011 at 5:07 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Anil. > > You can use VLOOKUP for Reverse Lookup. Consider A1:B20 is the data. E2 is > the Lookup_Value from Col_B. So use this, > > =

Re: $$Excel-Macros$$ Restrict access to certain sheets

Thanks a lot for your help, but I am a beginner in VBA.So would you guys please break it down for me? I've tried to paste the code and I really don't know how to go about it. Thanks again. On Jul 25, 11:46 pm, XLS S wrote: > Hey, > > Try this > > run this macro and put the password in vba code

Re: $$Excel-Macros$$ Reverse Vlookup

Hello Anil. You can use VLOOKUP for Reverse Lookup. Consider A1:B20 is the data. E2 is the Lookup_Value from Col_B. So use this, =VLOOKUP(E2,CHOOSE({1,2},$B$2:$B$20,$A$2:$A$20),2,0) CHOOSE({1,2},$B$2:$B$20,$A$2:$A$20) will give the array of Col_B value first then Col_A. So VLOOKUP will work as

Re: $$Excel-Macros$$ VBA Needed to summarize employee data from raw data

This is great, but how can I add an additional criteria to filter the correct 'project/investment' that apply? On Thu, Jul 28, 2011 at 5:12 AM, Rajan_Verma wrote: > See the attached sheet with SUmifs Function > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macro

$$Excel-Macros$$ Floating Message Box

Is there a way to add a floating message box. Something that will stay within view as you scroll down or up a page. Thanks in Advance!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

Re: $$Excel-Macros$$ Reverse Vlookup

Hi Anil Find attach Try =LOOKUP(2,1/($A$2:$A$12=D3),$B$2:$B$12) Thanks Mahesh On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi All, > > ** ** > > Could you help me with VB code for Reverse Vlookup function command where > we can lookup value fro

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

Hi Try Sub Mtest() Dim LR As Long, r As Long LR = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For r = LR To 1 Step -1 If Application.WorksheetFunction.CountIf(Rows(r), "=0") = 1 Then Rows(r).Delete Next r Application.ScreenUpdating = True End Sub

Re: RE: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Hi Friends, It is taking too long to delete the Zero value cells ans its rows. Is there any way to select all the Zero value in a particular rows and remove(Delete) from sheet. Regards, Prabhu -- -- Some important

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

XLS S, I would tend to believe that progressing from small to large indices for a row will not solve the problem. A more conservative approach would be the classic reverse look that looks like this Sub DelRowWithZeroes() Dim lngLoop As Long With Worksheets("Sheet1").Range("P3:P13")

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

Sub Delete() On Error Resume Next With Range("A1:A5") .EntireRow.Hidden = False For i = 1 To .Rows.Count If WorksheetFunction.Sum(.Rows(i)) = 0 Then .Rows(i).EntireRow.Delete = True End If Next i End With End Sub On Thu, Jul 28, 2011 at 9:54 PM, Prabhu wrote: > Hi Friends, > > > I Required Mac

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

Hi Friends, I Required Macro code if we find zero(0) in a particular row then we need to delete entire row. Example: In"P' column P27,48,57 cells contain 0 then entire 27,48,57th row needs to delete from the sheet. Plz help Regards, Prabhu -- --

Re: $$Excel-Macros$$ Vba Code required

Thanks Rajan. It works perfectly Regards, Kaushik -- -- 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://

RE: $$Excel-Macros$$ Vba Code required

Attached Your File with that Codes thanks From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Thursday, July 28, 2011 6:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vba Code required Thanks Rajan, But Vba

RE: $$Excel-Macros$$ Reverse Vlookup

You can Use LooKUP Function if Your data is Sorted =LOOKUP(E3,$B$3:$B$21,$A$3:$A$21) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Thursday, July 28, 2011 5:06 PM To: excel-macros@googlegroups.com Cc: anil.bha...@tatacommunications.c

Re: $$Excel-Macros$$ Reverse Vlookup

Hey, Make Add-In http://support.microsoft.com/kb/285337 http://www.ozgrid.com/VBA/excel-add-in-create.htm On Thu, Jul 28, 2011 at 7:17 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Thanks Daniel, > > ** ** > > It’s amazing and Finance people on this group will be grateful

RE: $$Excel-Macros$$ Reverse Vlookup

Thanks Daniel, It's amazing and Finance people on this group will be grateful to you, just one more request to get this function inbuilt in excel, could you please share how and where to save the below macro. Because I tried but not getting answer and it shows Error. Regards,Anil Bhange IP

Re: $$Excel-Macros$$ Fwd: Query

HI hari for below Query you can just do as F1&G1&H1 as much as u can.. if you want to use anysyble between then just use as F1&"-"&H1. On Thu, Jul 28, 2011 at 6:49 PM, XLS S wrote: > Dear Hari, > > Use Concatenat Function or & operate..please find the attachment > > > > On Thu, Jul 28, 2011

Re: $$Excel-Macros$$ Query

Thanks a lot dear On 28 July 2011 18:32, ashish koul wrote: > SUBSTITUTE(F1&TEXT(G1,"ddmmyyy")," ","") > > > On Thu, Jul 28, 2011 at 5:13 PM, Hari wrote: > >> dear members, >> >> can any one solve my query with help of formula, i am very poor in MS >> excel. >> >> find the attachement, reply a

Re: $$Excel-Macros$$ Query

SUBSTITUTE(F1&TEXT(G1,"ddmmyyy")," ","") On Thu, Jul 28, 2011 at 5:13 PM, Hari wrote: > dear members, > > can any one solve my query with help of formula, i am very poor in MS > excel. > > find the attachement, reply at the earliest. > > Thanks in advance, > > have a nice day. > > -- > Yours, >

RE: $$Excel-Macros$$ need formula to summarize based on multiple crteria

=VLOOKUP(B35;B25:C31;2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anwar Mohd Sent: Thursday, July 28, 2011 6:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need formula to summarize based on multiple crteria Hi Experts,

RE: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Sub delRow() LastRow = Range("j" & Rows.Count).End(xlUp).Row For Each cl In Range("j2:j" & LastRow) If cl = 0 Then cl.EntireRow.Delete End If Next cl End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Thursd

RE: $$Excel-Macros$$ Reverse Vlookup

Just to precise that the « col » parameter should be a positive number, the rightmost column being column 1. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Anil Bhange Envoyé : jeudi 28 juillet 2011 14:23 À : excel-macros@googlegroups.com Obje

RE: $$Excel-Macros$$ Reverse Vlookup

HI, Try the below function ; the parameters are the same as those of the VLOOKUP function : Function RLookup(ToSearch, rg As Range, col As Long, Optional ProxVal) Dim RightRange As Range If IsError(ProxVal) Then ProxVal = 1 Set RightRange = rg.Resize(, 1).Offset(, rg.Columns.Cou

Re: $$Excel-Macros$$ Vba Code required

Thanks Rajan, But Vba is not ending. It is giving me debug required at End If in Vba Code, further the totals are also not tying after Vba Code applying. Please do the needful by looking it again. Regards, Kaushik -- -

RE: $$Excel-Macros$$ Vba Code required

Run this in Claims Paid File Sub DoSomething() Dim rng As Range Dim cell As Range Dim rng2 As Range Dim cell2 As Range Dim i As Integer i = 1 Set rng = Range("A:A") rng.Sort Key1:=Range("A2") rng.Copy Range("D1") Range("D:D").RemoveD

RE: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Select the Column which have 0 Value and Run this Macro Sub DeleteBySelection() On Error GoTo err: Application.ScreenUpdating = False Dim rng As Range Dim cell As Range Set rng = Selection For Each cell In rng If cell.Value = 0 Then cell.En

RE: $$Excel-Macros$$ Reverse Vlookup

Thanks XlS S, Venkat and other members, I have the solution for the query but I thought it would be great to create the VBA Function which help as a formula in excel. So could you please help me with VBA code where we all could just type something like "=RLOOKUP() and will get the resul

Re: $$Excel-Macros$$ Result not geting using "SUMIFS", Please help

Hey Kal xcel, please clear what you want On Thu, Jul 28, 2011 at 1:03 PM, Kal xcel wrote: > Dear Haseeb, > > Thanks for your reply. But result is not coming with this formula. > > Thanks once again. > > Kalyan Chattopadhyay > > On Thu, Jul 28, 2011 at 12:21 AM, Haseeb Avarakkan < > haseeb.a

Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole cell.but your solution color only first 3 letter ... On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma wrote: > Hope it will Help you > > Sub HighLight() > > Application.ScreenUpdating = False > On Error Resume N

Re: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Dear Arpit, please try below code..it will be help to delete all row of J column Sub delete_row() Dim i, j As Long Application.ScreenUpdating = False j = Application.WorksheetFunction.CountA(Sheet22.Range("J:J")) For i = j To 1 Step -1 If Sheet22.Cells(i, 10).Value = 0 Then Sheet22.Ra

Re: $$Excel-Macros$$ Custom function in Excel

Save you all UDF in madule in xlms file. you will get the help from excel editor. On Thu, Jul 28, 2011 at 5:09 PM, Venkat CV wrote: > Hi Sandeep, > > Save your UDF function as a .XLA (or)XLAM and you may open and use it... > > > > *Best Regards,* > *Venkat* > *Chennai* > On Thu, Jul 28, 2011

Re: $$Excel-Macros$$ Reverse Vlookup

Try this .. please find the attachment On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV wrote: > > Hi Anil, > > Look Attached it will help u... > > *Best Regards,* > *Venkat* > *Chennai* > > On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange < > anil.bha...@tatacommunications.com> wrote: > >> Hi

Re: $$Excel-Macros$$ Reverse Vlookup

Use Sumproduct function ti will help you. as manhy criteria you can put in brackets and get your desire result. *SUMPRODUCT(($B$3:$B$21=E3)*$A$3:$A$21)* On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV wrote: > > Hi Anil, > > Look Attached it will help u... > > *Best Regards,* > *Venkat* > *Chennai* >

RE: $$Excel-Macros$$ VBA Needed to summarize employee data from raw data

See the attached sheet with SUmifs Function -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Adam Hamilton Sent: Thursday, July 28, 2011 9:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Needed to summarize

Re: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

another way to delete simple just select the rows. simple macro to understand. *Sub deleterow() Application.ScreenUpdating = False Dim cell As Range Set cell = Selection For Each cell In Selection If cell.Value = 0 Then cell.EntireRow.Delete End If Next cell End Sub * On Thu, Jul 28, 2011 at 4:59

RE: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Hope it will Help you Sub HighLight() Application.ScreenUpdating = False On Error Resume Next Dim cell As Range Dim rng As Range Dim st As String Dim loc As Integer Dim n as string st = "" Set rng = ActiveSheet.UsedRange For Each cell In rng

Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

try sumproduct. SUMPRODUCT((A2:A31=A35)*(B2:B31=B35)*C2:C31) On Thu, Jul 28, 2011 at 11:57 AM, Venkat CV wrote: > Hi Mohan, > > If you want to get the data based on Multiple Criteria in 2007 You May Try > Countifs,Sumifs,Averageifs > > *Best Regards,* > *Venkat* > * > * > * > * > > On Thu, Jul

Re: $$Excel-Macros$$ Custom function in Excel

Hi Sandeep, Save your UDF function as a .XLA (or)XLAM and you may open and use it... *Best Regards,* *Venkat* *Chennai* On Thu, Jul 28, 2011 at 4:13 PM, wrote: > Hi excel gurus, > > I am using excel 2007.I want to give all my custom excel function (UDF) a > felling like real function can it

Re: $$Excel-Macros$$ Reverse Vlookup

Hi Anil, Look Attached it will help u... *Best Regards,* *Venkat* *Chennai* On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi All, > > ** ** > > Could you help me with VB code for Reverse Vlookup function command where > we can lookup value from

Re: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Thaks Daniel, your logic is super. On Thu, Jul 28, 2011 at 4:09 PM, Daniel wrote: > Hi, > > ** ** > > Another way to do it : > > ** ** > > Sub test() > > Dim rgRange As Range > > With Sheets("Report") > > Set rgRange = Range(.[A1], .Cells(.Rows.Count, 1).End(xlUp).Offs

Re: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Thanks Noorain for your quick respond. It will not delete all rows properly at one time, about 50% 0 values row penidng at the time of appling logic first time. i made some change but its going hang. can you please modify it. Sub delete_row() dim i,j as long application.screenupdating=false

Re: $$Excel-Macros$$ Extracting data from Website

Hi, In the below link I need to extract data by name i.e.*Chandra Shekar *in comments columns. Thank you in advance. http://chandoo.org/wp/2010/01/27/pivot-table-tricks/ On Thu, Jul 28, 2011 at 8:32 AM, ashish koul wrote: > can you send me link and text you want to extract > > > On Thu, Jul 28

$$Excel-Macros$$ Reverse Vlookup

Hi All, Could you help me with VB code for Reverse Vlookup function command where we can lookup value from Right to Left. Some similar to Vlookup but lookup from Right to Left. Please give me a function code so that I can able to save this in Personal workbook and use in all excel file. Anil

$$Excel-Macros$$ Custom function in Excel

Hi excel gurus, I am using excel 2007.I want to give all my custom excel function (UDF) a felling like real function can it possible? I want to show the user all help to be prompt when they select the UDF. Thanks in advance. Sandeep Kr. Chhajer. Sent on my BlackBerry® from Vodafone --

RE: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Hi, Another way to do it : Sub test() Dim rgRange As Range With Sheets("Report") Set rgRange = Range(.[A1], .Cells(.Rows.Count, 1).End(xlUp).Offset(, 9)) rgRange.AutoFilter 10, 0 Set rgRange = rgRange.Offset(1).Resize(rgRange.Rows.Count - 1) Set rgRange = rgRange.Speci

Re: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

Dear Arpit, Please try below code to delete row equal to 0 in J Column.. Sub delete_row() dim i,j as long application.screenupdating=false j=application.worksheetfunction.counta(sheet22.range("J:J")) for i=1 to j if sheet22.cells(i,10).value=0 then sheet22.range("J"&i).EntireRow.Delete end if

RE: $$Excel-Macros$$ Help needed to comine VBA modules

Hi, You should indicate the file name before the function : Eg. Personal.xlsb! SpellNumber... Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : jeudi 28 juillet 2011 06:10 À : excel-macros@googl

Re: $$Excel-Macros$$ Result not geting using "SUMIFS", Please help

Dear Haseeb, Thanks for your reply. But result is not coming with this formula. Thanks once again. Kalyan Chattopadhyay On Thu, Jul 28, 2011 at 12:21 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Kalyan, > > If you just have two customers, you can hard coded as array & use

Re: $$Excel-Macros$$ ABOUT EXCEL

Enjoy ... On Thu, Jul 28, 2011 at 9:16 AM, Muhammad Talal Akbar < sh.talal.ak...@gmail.com> wrote: > okay thanks dear > > > > On Wed, Jul 27, 2011 at 6:03 PM, XLS S wrote: > >> Dear Akabr, >> >> Coming soon Daily Doze VBA Classes Just wait. >> >> Just Download PDF for learn VB >> >

Re: $$Excel-Macros$$ Excel Test

On Thu, Jul 28, 2011 at 12:05 PM, NOORAIN ANSARI wrote: > Dear All, > > Please find attached Excel Test. > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* > > -- > > ---

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

Cheers. . Thanks, DILIPandey On 7/28/11, qcan wrote: > THANK YOU EVERYONE. I am in awe with the knowlege you guys have. WELL > DONE ! > > On Jul 27, 2:25 am, "Rajan_Verma" wrote: >> Try this.. >> >> Sub Reverse() >> >>  Dim fRng As Range >> >>  Dim Couter As Integer >> >>  Dim cell As Range >>