RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

your point! All the best, Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Wednesday, October 05, 2011 5:32 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Thank

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

ula like this one.** > ** > > ** ** > > Asa > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ChilExcel > *Sent:* Tuesday, October 04, 2011 6:33 PM > *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Jai another excellent solution provided by Rajan Berma Try this : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Dim lngValueAs Long Dim intICounter As Integer Dim strMsg As String Dim lngValue2 As Long lngValue = Target.Value lng

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

excellent solution, launching the message showing the repeat value thank you very much for your time and attention Rajan Chilexcel 2011/10/5 rajan verma > Try this : > > Private Sub Worksheet_Change(ByVal Target As Range) > On Error GoTo Err: > Dim lngValueAs Long > Dim i

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Try this : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Dim lngValueAs Long Dim intICounter As Integer Dim strMsg As String Dim lngValue2 As Long lngValue = Target.Value lngValue2 = Target.Offset(0, -1).Value If Intersect(Target

RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Or (slaps head) -- Just use: =countifs($B$2:$B$1000,$B2,$C$2:$C$1000,$C2)=1 Asa From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Tuesday, October 04, 2011 9:40 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate en

RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

e this one. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Tuesday, October 04, 2011 6:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Thanks Rajan I

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Please see Mathai solution proposed by Sam Chacko Excellent! Private Sub Worksheet_Change(ByVal Target As Range) Dim lngCount As Long Dim lngLoop As Long Dim strMsg As String lngCount = Evaluate("=SUMPRODUCT((Hoja1!$B$2:$B$57&Hoja1!$C$2:$C$57<>)*(Hoja1!$B$2:$B$57=Hoja1!B" & Ta

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Thanks Rajan I need is to columns B and C (together) containing the mirrored pair in same row good solution you propose, but only in column B duplicate Thanks Rajan 2011/10/4 rajan verma > Try this Code : > this Code enable you to check the duplicate entry at the time of Data Entry > .. > >

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Try this Code : this Code enable you to check the duplicate entry at the time of Data Entry .. Private Sub Worksheet_Change(ByVal Target As Range) Dim lngValueAs Long Dim intICounter As Integer Dim strMsg As String lngValue = Target.Value If Intersect(Target, Range("

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

I need also this VB Code On Mon, Oct 3, 2011 at 4:41 AM, ChilExcel wrote: > Urgent !! > i Need VB lines codes for > > 2011/10/1 ChilExcel > >> hi >> >> i Need VB lines codes for >> Alert MsgBox Pair duplicate entry in row >> >> Column D function account and duplicates alerts (NO Problem!

RE: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Monday, October 03, 2011 12:16 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row Chil, Paste this code in the sheet

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Excellent, exactly what I needed thank you very much Sam !!! 2011/10/3 Sam Mathai Chacko > Chil, > > Paste this code in the sheet code module of the respective sheet. Now once > any entry is made in any row of B & C, it will check and display a message > if any duplicate is found. > > Priva

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Chil, Paste this code in the sheet code module of the respective sheet. Now once any entry is made in any row of B & C, it will check and display a message if any duplicate is found. Private Sub Worksheet_Change(ByVal Target As Range) Dim lngCount As Long Dim lngLoop As Long Dim strM

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

Urgent !! i Need VB lines codes for 2011/10/1 ChilExcel > hi > > i Need VB lines codes for > Alert MsgBox Pair duplicate entry in row > > Column D function account and duplicates alerts (NO Problem!) > Attach File , thank you all > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Vi

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

el-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko > *Sent:* 02 October 2011 21:28 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help needed to find total & Unique count > from a range of moving dates > > ** ** > > Hi Amit, > &

RE: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

t; range. And yes, thanks a lot for appreciating Meru's service Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: 02 October 2011 21:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ H

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

Hi Amit, Follow steps carefully in sequence Add 3 named ranges as below Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT("z",20),LOG!$E$2:$E$1,1)) EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1)) Data=IF((EntryDate>=Sheet2!$A1)*(EntryDate<=Sheet2!$B1)=1,Vehicl

Re: $$Excel-Macros$$ Help Needed.

Here is one I like to use for setting variables (Options) in a file that is used by other Macros. Using the Macro below; I can toggle between True and False on the Options and Colors for specific cells. Available Options Star Font Size =16 Label Fo

Re: $$Excel-Macros$$ Help Needed.

Thanks rajan babu, for that link.Can anybody quote some more examples in detail.I just got a little understanding of the function with arguments.But to enhance my knowledge i would like to study more examples...Pls provide me with any other examples. On Sat, Oct 1, 2011 at 12:18 PM, rajan verm

Re: $$Excel-Macros$$ Help Needed.

Please VIsit this Page.. http://www.cpearson.com/excel/Events.aspx On Sat, Oct 1, 2011 at 12:09 PM, XLS S wrote: > Hey Rajan Babu, > > which page? > > > > > > On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote: > >> HI, >> Please visit this Page to know more about Worksheet Events.. >> >> Regar

Re: $$Excel-Macros$$ Help Needed.

Hey Rajan Babu, which page? On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote: > HI, > Please visit this Page to know more about Worksheet Events.. > > Regards > Rajan > > On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote: > >> HI group, >> >> This is a Great & amazing group in learning exce

Re: $$Excel-Macros$$ Help Needed.

HI, Please visit this Page to know more about Worksheet Events.. Regards Rajan On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote: > HI group, > > This is a Great & amazing group in learning excel vba.. > > > *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean)* >

Re: $$Excel-Macros$$ help

Dear naanu, you can also try *Prepare-Inspect Document-Check Hidden Rows and Columns-Press Inspect Button * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ help

Hidden Column Names http://www.excelvbamacros.com/2011/09/find-hidden-column-names-in-sheet.html Hidden Row Numbers http://www.excelvbamacros.com/2011/09/find-hidden-row-number-in-worksheet.html On Sat, Sep 24, 2011 at 4:41 PM, naanu v wrote: > Kindly let me know how to find the hidden rows

Re: $$Excel-Macros$$ Help.

Dear Vijay, Please check below link https://www.odesk.com/.../*Global*-*Reporting* -Analyst-with-strong-background -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Help required offset command

Thank you Daniel On Fri, Sep 9, 2011 at 2:56 PM, Daniel wrote: > Hi, > > ** ** > > See attached file. > > ** ** > > Regards. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Kal xcel > *Envoyé :* ve

Re: $$Excel-Macros$$ Help in IF Function

Thanks a lot pawel Regards Anu On Wed, Sep 7, 2011 at 12:41 AM, pawel lupinski wrote: > result by IF function > > regards, > Pawel > > -- > *From:* anu gomathi > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, September 6, 2011 9:00 PM > *Subject:* $$Excel-

Re: $$Excel-Macros$$ Help on Indexing and Matching

I would adise you to do the following: 1. Concatenate the three cells I.e., region, province and barangay in both the Sheets. 2. Now use index and match. Let me know if this clear. Regards, Joe On Tuesday, September 6, 2011, John Alliage Tinio Morales < alliage.mora...@gmail.com> wrote: > Hi, I

Re: $$Excel-Macros$$ Help in IF Function

result by IF function regards, Pawel From: anu gomathi To: excel-macros@googlegroups.com Sent: Tuesday, September 6, 2011 9:00 PM Subject: $$Excel-Macros$$ Help in IF Function Hi All,   Please help me to put the IF function for the below table. If the table v

Re: $$Excel-Macros$$ Help to create summary table count unique

--- > *From: * ChilExcel > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 4 Sep 2011 12:36:39 -0400 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique > > I have solved

Re: $$Excel-Macros$$ Help to create summary table count unique

s? >>>> >>>> Sent on my BlackBerry® from Vodafone >>>> -- >>>> *From: *NOORAIN ANSARI >>>> *Sender: *excel-macros@googlegroups.com >>>> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >>>> *To:

Re: $$Excel-Macros$$ Help to create summary table count unique

//noorain-ansari.blogspot.com/> >>> >>> On Fri, Aug 26, 2011 at 10:51 AM, wrote: >>> >>>> **Dear excelguru, >>>> >>>> Can u pls elaborate what is unique count? >>>> And how it helps? >>>> >>>> Sent

Re: $$Excel-Macros$$ help

Dear Vijay, if your Word in one cell you can use... =PROPER(Trim(SUBSTITUTE(D4," ",""))) On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote: > Hi, > > i have four words and i need to combine using trim and proper functions. > > Please can you provide me formula > > Thank you > > -- >

RE: $$Excel-Macros$$ help

Use Concatenate =Concatenate(Proper(Trim(YourWord)), Proper(Trim(YourWord)) Or & Sign Proper(Trim(YourWord)) & " " & Proper(Trim(YourWord)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Tuesday, August 30, 2011 7:27

Re: $$Excel-Macros$$ help

Hi vijay, Please send some sample data...for your requirement.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote: > Hi, > > i have four words and i need to combine using trim and proper functions. > > Please can you provide me formula > > Thank you > >

Re: $$Excel-Macros$$ Help to create summary table count unique

t; -- >>> *From: *NOORAIN ANSARI >>> *Sender: *excel-macros@googlegroups.com >>> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >>> *To: * >>> *ReplyTo: *excel-macros@googlegroups.com >>> *Subject: *Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Help to create summary table count unique

BlackBerry® from Vodafone >> -- >> *From: *NOORAIN ANSARI >> *Sender: *excel-macros@googlegroups.com >> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >> *To: * >> *ReplyTo: *excel-macros@googlegroups.com >> *Subject: *Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Help to create summary table count unique

ue count? > And how it helps? > > Sent on my BlackBerry® from Vodafone > -- > *From: *NOORAIN ANSARI > *Sender: *excel-macros@googlegroups.com > *Date: *Fri, 26 Aug 2011 10:49:39 +0530 > *To: * > *ReplyTo: *excel-macros@googlegroups.com &g

Re: $$Excel-Macros$$ Help to create summary table count unique

: $$Excel-Macros$$ Help to create summary table count unique Dear ChilExcel, For Unique Count... Use below function..with Ctrl+shift+Enter.. *=SUM(1/COUNTIF(I1:I28,I1:I28))* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogs

Re: $$Excel-Macros$$ Help to create summary table count unique

Dear ChilExcel, For Unique Count... Use below function..with Ctrl+shift+Enter.. *=SUM(1/COUNTIF(I1:I28,I1:I28))* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel wrote: > h

Re: $$Excel-Macros$$ Help ASAP

Thanks Daniel for your kind and prompt help. But unfortunately I am not familiar to using Macros. Can you please guide me in using this Macro. Thanks again. Regards, Bhargava Raju On Aug 22, 4:16 pm, "Daniel" wrote: > Try : > > Sub FromTable1() > > Dim Rg As Range, Tabl, lgRow As Long > > Set

RE: $$Excel-Macros$$ Help ASAP

Try : Sub FromTable1() Dim Rg As Range, Tabl, lgRow As Long Set Rg = Range([B6], Cells(6, 2).End(xlDown)).Resize(, 5) Tabl = Rg lgRow = 5 For i = 1 To UBound(Tabl) lgRow = lgRow + 1 Cells(lgRow, 10).Resize(3) = Tabl(i, 1) Cells(lgRow, 11).Resize(3) = Tabl(i, 2) Cells(lg

Re: $$Excel-Macros$$ Help with Formula

A simple vlookup formula such as this to lookup the item in the IS sheet when you know the column should do it. You can then use edit/replace to change the formulas. A one click macro could do it all. =VLOOKUP(J9,'2011 Actual'!B2:AG331,10,0) From: Steve Weaver Sent: Friday, August 19,

Re: $$Excel-Macros$$ help table percentage

very good help!! . thank you very much to all excellent 2011/8/19 dguillett1 > I would put the table to create to the side and retain the top row of > formulas and just fire this. See attached > Sub DoPercentageTableNextToTable1() > Dim slr As Long > > slr = Cells(Rows.Count, "b").End(xlUp

RE: $$Excel-Macros$$ Help for to get the detail from the word document

Please attached Your Word document: From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rengaraj mohan Sent: Thursday, August 18, 2011 11:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help for to get the detail from the word document H

RE: $$Excel-Macros$$ help required 4

This Procedure Should be Like This : Sub InsertRow() For x = 1 To Range("A65536").End(xlUp).Row * 2 If Range("A" & Trim(Str(x))).Value <> "" And Range("A" & Trim(Str(x))).Offset(1, 0).Value <> "" Then Application.StatusBar = "Inserting Rows on Row : " & Trim(Str(x + 1)) Range("A" &

RE: $$Excel-Macros$$ help required 4

This Procedure Should be Like This : Sub InsertRow() For x = 1 To Range("A65536").End(xlUp).Row * 2 If Range("A" & Trim(Str(x))).Value <> "" And Range("A" & Trim(Str(x))).Offset(1, 0).Value <> "" Then Application.StatusBar = "Inserting Rows on Row : " & Trim(Str(x + 1)) Range("A" & Tri

RE: $$Excel-Macros$$ Help needed. compare two wxcel files

See if it helps , but Scop of this macro is only only Worksheet. Sub matchValue() ' Short CUt Key Shift + CTRL + M Application.ScreenUpdating = False Dim F_range As Range Dim S_range As Range On Error Resume Next Set F_range = Application.InputBox("Please Select 1st Range", , , , , , ,

Re: $$Excel-Macros$$ Help needed. compare two wxcel files

You need to post examples, etc. From: Rajendra prasad yadav Sent: Monday, August 08, 2011 1:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed. compare two wxcel files Hi friends, I am not good at excel. I have a requirement now, Can some one please give the macro t

Re: $$Excel-Macros$$ help 4

Thank you raj for your help On Sun, Aug 7, 2011 at 8:04 PM, Rajan_Verma wrote: > *See this Function :* > > * * > > *if sum of any Two cell in selected Range is Equal to Given Value in > Second Parameter of Function then Function will Return the Address of that > Two Cells, here Flag will be T

Re: $$Excel-Macros$$ Help with =now()

mmm- > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Venkat CV > Sent: Friday, August 05, 2011 5:05 PM > To: excel-macros@googlegroups.com > Cc: ashlyprad...@gmail.com > Subject: Re: $$Excel-Macros$$ Help with =now() > >

Re: $$Excel-Macros$$ Help with =now()

-macros@googlegroups.com *Cc:* ashlyprad...@gmail.com *Subject:* Re: $$Excel-Macros$$ Help with =now() *Hi Ashish,* *Yes you can Just Type in Custom "As on" mmm you will get output as a "As on August 2011"* *Best Regards,* *Venkat * *Chennai* On Fri, Aug 5, 201

RE: $$Excel-Macros$$ Help with =now()

Use this Format : - From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Friday, August 05, 2011 5:05 PM To: excel-macros@googlegroups.com Cc: ashlyprad...@gmail.com Subject: Re: $$Excel-Macros$$ Help with =now() Hi Ashish

Re: $$Excel-Macros$$ Help with =now()

*Hi Ashish,* * * *Yes you can Just Type in Custom "As on" mmm you will get output as a "As on August 2011"* * * *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 5, 2011 at 4:53 PM, Ashish Pradhan wrote: > Hello Venkat > > Amazing :-) > > Wonder why I couldn't think of it earlier :-) > >

Re: $$Excel-Macros$$ Help with =now()

Hello Venkat Amazing :-) Wonder why I couldn't think of it earlier :-) Is the second part possible. For eg. In the same cell, I want the cell to display as "As on August 2011" (Where August 2011 will be obtained using the now() formula as described earlier and as you have suggested.. Thanks

Re: $$Excel-Macros$$ Help required on Importing Data

Hey Kaushik, can you attach the worksheet and also..easy way to make link file..just create workbook shortcut and use On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA wrote: > Query on paste link - Should i select each worksheet of workbook and > do the paste specia

Re: $$Excel-Macros$$ Help required on Importing Data

Hi Kaushik You Have to Select Entire Page on Copying time as well Paste special and use As told Mr XLS S Steps *Best Regards,* *Venkat * *Chennai* On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA wrote: > Query on paste link - Should i select each worksheet of workbook and > do the paste spec

Re: $$Excel-Macros$$ Help required on Importing Data

Query on paste link - Should i select each worksheet of workbook and do the paste special value paste link? If so then is there any shortcut to link whole workbook to another workvook. Regards, Kaushik On 8/4/11, XLS S wrote: > Use paste special with paste link.. > > On Wed, Aug 3, 2011

Re: $$Excel-Macros$$ Help required on Importing Data

Use paste special with paste link.. On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA wrote: > Hi All, > How to import only selected data from another workbook? > Please help. > > Regards, > Kaushik > > -- > Sent from Gmail for mobile | mobile.google.com > > Kaushik Savla > > -- > ---

Re: $$Excel-Macros$$ Help required on Importing Data

if your data format doesn´t change i recomend using links, i use links for a database which doesn´t change the format, but i have another database i have to add new data every month which is always changing values and cells, for that i use a copy paste macro which copies all the data by selecting c

Re: $$Excel-Macros$$ Help required on Importing Data

Hi Kaushik, We can Copy Paste Else Link the Cells as Required data by using data linking...workbook 1 to Workbook 2 *Best Regards,* *Venkat * *Chennai* On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA wrote: > Hi All, > How to import only selected data from another workbook? > Please help. > > Reg

RE: $$Excel-Macros$$ Help required on Importing Data

Hi kaushik, I think copy and paste is the best option for this Regards Rajan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Wednesday, August 03, 2011 4:47 PM To: excel-macros@googlegroups.com Subject: $$Exce

Re: $$Excel-Macros$$ Help in Training room booking system

Hi You can download sample workbook here http://exceltemplate.net/calendar/hotel-reservations/ http://office.microsoft.com/en-us/templates/conference-room-reservation-request-form-TC03617.aspx http://www.myexceltemplates.com/conference-room-scheduler-excel-template/ Thanks Mahesh On Mon, Aug

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

31, 2011 at 1:57 PM Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules To: excel-macros@googlegroups.com It will be very difficult to move the code to the personal.xlsb workbook without the initial file retaining some code. Can you explain why you want to do so ? Maybe there should be a

Re: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

Hey Thanks people.. never knew that the Refresh All option eixsted !..appreciate the help. Regards, Ruchi On Tue, Jul 26, 2011 at 8:13 AM, NOORAIN ANSARI wrote: > Sub allpivotsofworkbook() > activeworkbook.Refreshall > end sub > > On Mon, Jul 25, 2011 at 11:55 PM, XLS S wrote: > >> Easy way i

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

> Target.ShowDetail = True > > ActiveSheet.Name = Target.Offset(, -1).Value > > End If > > End Sub -- Forwarded message -- From: Daniel Date: Sun, Jul 31, 2011 at 12:53 AM Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules To:

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

À : excel macro forum Objet : Re: $$Excel-Macros$$ Help needed to comine VBA modules Dear daniel, Thanks. Now it is working fine.But the sub 'Worksheet_BeforeDoubleClick' is included as worksheet level event routine of w.sheet analysis.How can i incorporat

RE: $$Excel-Macros$$ help

If 10 Rows Consist in Range rng then loop will Run 9 Time From 9 TO 1 Every time R value will decrease 1 because of Step -1 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Saturday, July 30, 2011 8:06 PM To: excel-macros@googlegrou

RE: $$Excel-Macros$$ help

HI, Let’s suppose you have a certain range of cells (let’say A1 :B20) You define “rng” as this range : Set rng = Range(“A1:B10”) « rng.Rows.Count » is the number of rows of rng (10) So : « rng.Rows.Count » - 1 = 9 Now : For r = rng.Rows.Count - 1 To 1 Step -1 Means

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

> > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Daniel > Sent: Saturday, July 30, 2011 6:12 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Help needed to comine VBA mo

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

macros@googlegroups.com] > On Behalf Of Daniel > Sent: Saturday, July 30, 2011 6:12 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules > > Here is my test file. > > -Message d'origine- > De : excel-macros@goog

RE: $$Excel-Macros$$ Help

Download the Excel Function Dictionary http://www.xlfdic.com/ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of XLS S Sent: Friday, July 29, 2011 10:38 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Hey Vijay, Please

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

… each tim you double click on a value of the pivot, the worksheet will be created with the desired name. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : vendredi 29 juillet 2011 16:25 À : excel macro forum Objet : Fwd: $$Ex

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

Paste the macro below in the ANALYSIS module : Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim rg As Range Set rg = Sheets("ANALYSIS").PivotTables(1).DataBodyRange If Intersect(Target, rg) Is Nothing Then Exit Sub Cancel = True If T

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

HI, Can you explain a bit more ? Thanks. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : vendredi 29 juillet 2011 00:37 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Help needed to comine VBA

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$$ 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$$ Help for combo box

Please update... Subhash Yadav On Mon, Jul 25, 2011 at 7:00 PM, Subhash Yadav wrote: > Dear friends > > I require some help regarding Vlookup function conunction with Combo Box. > > I want vlookup in the combobox with respect to selected value in another > combo box. Also want to put value in

Re: RE: $$Excel-Macros$$ help required

Hello Vijay, See the attached. HTH Haseeb For tips visit; http://www.excelfox.com/forum/forum.php -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

RE: $$Excel-Macros$$ help required

Put this in B Column =TEXT(DATE(LEFT(A4,4),MID(A4,FIND(".",A4,1)-2,2),MID(A4,FIND(".",A4,1)-2,2)) ,"mm/dd/yy") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Tuesday, July 26, 2011 6:17 PM To: excel-macros@googlegroups.com Subject

Re: $$Excel-Macros$$ help required

Dear Vijay, Please clear the q4 and q5.. please find the solution. On Tue, Jul 26, 2011 at 6:17 PM, vijayajith VA wrote: > Hi, > > > I have two excel questions.can you help me to solve those questions? > > Thank you > > -- > > -

Re: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Thanks all. Formula works but counts one less, so i am adding one manually. Regards, Kaushik ---

RE: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Hi, =LEN(A1)-LEN(SUBSTITUTE(A1," ","")) Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de KAUSHIK SAVLA Envoyé : mardi 26 juillet 2011 06:07 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Help Required (Excel Function or

Re: $$Excel-Macros$$ Help with find date.

I tested it with dates that exist but still got the same error message. You can try it. Tom On Jul 26, 3:42 pm, "Rajan_Verma" wrote: > If error is coming it means yourdatenot found in that sheet.. > ' On the Top on Module > On Error Goto Err: > > 'Before End sub Statement > Err: > If err.number<

RE: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

Attached Your file.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Monday, July 25, 2011 8:47 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error Doing that

RE: $$Excel-Macros$$ Help with find date.

If error is coming it means your date not found in that sheet.. ' On the Top on Module On Error Goto Err: 'Before End sub Statement Err: If err.number<>0 then Msgbox " Date Not Found",vbinformation endif -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegro

Re: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Dear Kaushik, In Excel Try it *=LEN(SUBSTITUTE(B2," ",""))* in VBA... Try it. *Function cell_length(s as range)* *cell_length=application.worksheetfunction.* *Function cell_length(s As Range) cell_length = Len(Application.WorksheetFunction.Substitute(s, " ", "")

Re: $$Excel-Macros$$ Help with find date.

Try using Cdate(Mydate) in Find On Tue, Jul 26, 2011 at 9:44 AM, Tom wrote: > I want the macro below to accept any date that I enter in its input > box, e.g. 17/06/2011, and go and find it in the active worksheet. I > got an error message saying, "Object variable or With block variable > not set

RE: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Try this =LEN(B1)-LEN(SUBSTITUTE(B1," ","")) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Tuesday, July 26, 2011 9:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Re: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)

Hi, Use this formula =LEN(A1)-LEN(SUBSTITUTE(A1," ","")) where A1 contains "9 7 5 6" On Tue, Jul 26, 2011 at 9:36 AM, KAUSHIK SAVLA wrote: > Hi All, > > I want to count the number of spaces in a cell:- > Eg In Cell A1 data is "9 7 5 6" I want function which returns answer as 4 > count. > >

Re: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

Sub allpivotsofworkbook() activeworkbook.Refreshall end sub On Mon, Jul 25, 2011 at 11:55 PM, XLS S wrote: > Easy way if you are using excel 2007,2010 then > > just press ctrl+alt+F5 > > On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B wrote: > >> All, >> >> Have a excel workbook with around 15 tabs

Re: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

Easy way if you are using excel 2007,2010 then just press ctrl+alt+F5 On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B wrote: > All, > > Have a excel workbook with around 15 tabs ..each of tab has multiple > pivots referring to different sets of data. All the pivots refer to 4 > data sets in all .What

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

Doing that, it doesn´t return the error anymore, but the macro still doesn´t copy the information :s, is it any complication with excel 2010? 2011/7/22 Rajan_Verma > *Set Wb=ActiveWorkbook* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of

RE: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

See if it Helps Sub UpdateAll() Dim sh As Worksheet Dim pt As PivotTable For each sh in ActiveWorkbook.sheets For Each pt In sh.PivotTables pt.PivotCache.Refresh Next next End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups

Re: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

do you want to change the source data or just refresh change calculations to automatic and then click on refresh all On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B wrote: > All, > > Have a excel workbook with around 15 tabs ..each of tab has multiple > pivots referring to different sets of data.

RE: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

Set Wb=ActiveWorkbook From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Thursday, July 21, 2011 10:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error Hi guys, i

Re: $$Excel-Macros$$ help requ

Hi, Is this possible using formula ? On Thu, Jul 21, 2011 at 7:38 PM, Anish Shrivastava wrote: > Hi Vijay, > > See the attached file. let me know if it works fine. > > On Thu, Jul 21, 2011 at 7:26 PM, vijayajith VA wrote: > >> Hi, >> >> I have names, order no and county names in two sheets.. nee

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

add this line before if condition see if it helps wb.Sheets("Pivot").select On Thu, Jul 21, 2011 at 11:56 PM, Anish Shrivastava wrote: > is it possible to attach the sheet? You can remove the data from it or > replace the values.. > > > On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote: > >>

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

is it possible to attach the sheet? You can remove the data from it or replace the values.. On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques wrote: > Yes, the names are all ok, i double checked it, even try to change names, > but doesn´t work :S > > 2011/7/21 Anish Shrivastava > >> Please check

<    3   4   5   6   7   8   9   10   11   12   >