Re: $$Excel-Macros$$ stock on hand report generate

On Fri, Sep 2, 2011 at 5:59 PM, dguillett1 wrote: > > I would suggest a different structure something like this with all on one > line and use filters and SUBTOTAL(109 > date > item > scheme > recd > issued > on hand > Thanks for your kind suggestion.I will try this. Thanks again -- -

Re: $$Excel-Macros$$ any short key to remove double add.

Hey Kannan, please find the below link http://office.microsoft.com/en-us/excel-help/delete-duplicate-rows-from-a-list-in-excel-HA001034626.aspx On Tue, Aug 30, 2011 at 5:57 PM, kannan excel wrote: > Hi NOORAIN ANSARI, > > Pls tell wat is this.?? > if you feel free explain me. > > Regards > V.

Re: $$Excel-Macros$$ Re: Sumproduct using VBA

Hey Chandra, try this Function xxx(x, y) Dim a, b, c As Range a = Range("a4:a14") ' contains text b = Range("b4:b14") ' contains text c = Range("c4:c14") ' contains values Range("a20") = Application.SumProduct((a = x) * (b = y) * c) End Function On Tue, Aug 30, 2011 at 11:56 AM

$$Excel-Macros$$ Counter in a Cell

Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is of times up arrow and down arrow are pressed. To set speed from, 0 to 16 for model railroad project. Your advice appreciated. Thanks Charlie Harris -- ---

Re: $$Excel-Macros$$ Vlookup with more than one condition

I am tired... --- Ms.Exl.Learner --- On Fri, Sep 2, 2011 at 11:48 PM, NOORAIN ANSARI wrote: > Dear MS.EXL.Learner, > > Please see attached sheet... > ** > Dear i better understand work and Concept of below mentio

$$Excel-Macros$$ Re: Pivot Table data extract

You could also set the Default Table Style for the workbook containing the pivot table as one which contains no formatting, then double clicking on an item in the pivot table would still create a table, but it would have no formatting. On Sep 2, 12:14 pm, Anil Bhange wrote: > Hi Expert, > > In Pi

$$Excel-Macros$$

-- == Haeruddin, S.Pd == -- -- 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://www.linkedin.com/

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear MS.EXL.Learner, Please see attached sheet... ** Dear i better understand work and Concept of below mentioned functionsi never denied to differencition between each functions. but at a time we can use a function for multiple purpose. * *

Re: $$Excel-Macros$$ Vlookup with more than one condition

Hi Noorain Ansari, Case-1 I have attached the same file for your reference and I have not changed anything on it just created a duplicate data. Now look at the excel file and see what are all the results your formula is deriving. Whether all the results are same? Take my previous mail and read

Re: $$Excel-Macros$$ difference time calculation

Yes MS. EXL Leaner, You can also use same format *[H]:mm:ss* in Custom Format. On Fri, Sep 2, 2011 at 10:16 PM, Ms-Exl-Learner . wrote: > Hi Noorain Ansari, > > But the text function will result text value instead of real value. It's > better to format the cell as per your desired format by us

Re: $$Excel-Macros$$ Date in VBA

Dear Brian, See attached sheet if it help.. On Fri, Sep 2, 2011 at 10:29 PM, Brian wrote: > I am using a form to enter data and then from the textbox complete > data in an excel spreadsheet. This is my code >ActiveCell.Value = Date >ActiveCell.Offset(0, 1).Select >ActiveCell.Value

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Ms-Exl-Learner, Thanks for your valuable suggestion.. Case -I, In case of duplicay all formulas are successfull working except vlookup(vlookup) example. You can see fresh attachement.. Case -II, You can't compare Sumproduct with If function both are different.. Correct Syntex of Formula Sho

Re: $$Excel-Macros$$ Freeze panes in an Excelsheet Control on a userform

thanks for your kind assistance, JH On 2 sep, 10:53, "Daniel" wrote: > Try : > > Private Sub Spreadsheet1_Click() >     Me.Spreadsheet1.Windows(1).FreezePanes = True > End Sub > > HTH > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups

$$Excel-Macros$$ Date in VBA

I am using a form to enter data and then from the textbox complete data in an excel spreadsheet. This is my code ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select ActiveCell.Value = FrmApplications.TextBox1.Value ActiveCell.Offset(0, 1).Select The first entry enters the date

$$Excel-Macros$$ Re: Freeze panes in an Excelsheet Control on a userform

thanks for your kind assistance, works just fine On 1 sep, 17:22, GoldenLance wrote: > Try this > > http://www.excelfox.com/forum/showthread.php?125-FreezePane-In-A-User... > > Regards, > Sam Mathai Chacko > > On Sep 1, 2:29 pm, John Holland wrote: > > > > > Would there be possibility to  f

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

Hi Prabhu it would be great if you send workbook which u r using & path of workbook. that code is working fine for me. Thanks Mahesh On Fri, Sep 2, 2011 at 12:33 PM, Rajan_Verma wrote: > *Try this Also..* > > * * > > *Option Explicit* > > *Sub Mtest()* > > *On Error GoTo Err:* > > *Applicatio

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Not yet..could you please explain me in detail? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, September 02, 2011 6:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countif

Re: $$Excel-Macros$$ Pivot Table data extract

Hi Anil copy below code in thisworkbook model Private Sub Workbook_NewSheet(ByVal Sh As Object) Dim sht As Worksheet Dim oLo As ListObject Set sht = ActiveSheet For Each oLo In sht.ListObjects sht.ListObjects(oLo.Name).TableStyle = "" Next End Sub Thanks Mahesh On Fri, Sep

Re: $$Excel-Macros$$ difference time calculation

Hi Noorain Ansari, But the text function will result text value instead of real value. It's better to format the cell as per your desired format by using custom format. --- Ms.Exl.Learner --- On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI wrote: > Dear W

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Shaik, When i Uncheck- "Enable Show Details, Pivot table is not expanding with the details. Normally if i double click the value of the Pivot table automaticly separate sheet will appear but after unclick the Enable Show Details details not appearing. Can you plz help. Prabhu -- ---

Re: $$Excel-Macros$$ Vlookup with more than one condition

Hi Noorain Ansari, It might be better if you might have constructed your example data with some duplicates, since the questioner can able to understand the difference between the *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs, Dsum]*. The *First set of formula's / Functions* just

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, Please try below formula : *=VLOOKUP(J3&K3,$E$3:$H$3,4,0)* *=VLOOKUP(VLOOKUP($J$3,$F$3:$G$8,2,0),$G$3:$H$8,2,0)* other Alternative... *=SUMPRODUCT((F3=J3)*(G3=K3)*H3)* *{=INDEX($H$3:$H$8,MATCH(1,($F$3:$F$8=$J$3)*($G$3:$G$8=$K$3),0))}* *{=OFFSET($H$2,MATCH(1,($F$3:$F$8=$J$3)*($G

Re: $$Excel-Macros$$ Vlookup with more than one condition

Thank you Venkat for your help. But the formula make the same what sumifs do. And that idea for me to use sumifs instead of vlookup. BRegards, Haytham Zoromba -Original Message- From: Venkat CV Sender: excel-macros@googlegroups.com Date: Fri, 2 Sep 2011 19:09:15 To: Reply-To: excel-

Re: $$Excel-Macros$$ write and read cookies through vba.

Hi , Look Below links... http://www.java2s.com/Code/ASP/Session-Cookie/WriteCookieandreadCookieVBnet.htm http://www.bigresource.com/VB-Read-Cookie-in-VBA-from-Word-QVYNPHx6U0.html -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile *

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, See sample...If Helps.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Sep 2, 2011 at 7:07 PM, Venkat CV wrote: > Dear Haytham, > > Try SUMPRODUCT... > > > *Best Regards,* > *Venkat * > *Chennai* > *My Li

Re: $$Excel-Macros$$ Vlookup with more than one condition

Dear Haytham, Try SUMPRODUCT... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Sep 2, 2011 at 5:02 PM, Haytham Zoromba wrote: > Dear all, > > I have tried to search about using vlookup with more than one condition. > > Is

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Have you tried looking at the help index for countifs? From: Amit Desai (MERU) Sent: Friday, September 02, 2011 4:51 AM To: excel-macros@googlegroups.com Subject: FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003 Dear Rajan, Thanks for this..but I do want to edit

Re: $$Excel-Macros$$ Pivot Table data extract

Dear Anil. When u get the details in "Table Format", Goto 'Design Tab->Table Styles-->Select "Clear".dats it. U dont have any other easier option than this Regards, Waheed On Fri, Sep 2, 2011 at 5:00 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Sorry.. just to

Re: $$Excel-Macros$$ stock on hand report generate

I would suggest a different structure something like this with all on one line and use filters and SUBTOTAL(109 date item scheme recd issued on hand From: Satish Bandaru Sent: Friday, September 02, 2011 4:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ stock on han

$$Excel-Macros$$ Vlookup with more than one condition

Dear all, I have tried to search about using vlookup with more than one condition. Is their any one know a formula for that? BRegards, Haytham Zoromba -- -- Some important links for excel users: 1. Follow us on TW

Re: $$Excel-Macros$$ difference time calculation

Thnx On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI wrote: > Dear Waheed, > > Text Function are used to convert time differences as Hour:Minute:Second > Format. > > On Fri, Sep 2, 2011 at 5:02 PM, Shaik Waheed wrote: >> >> Hi Noorain, >> Can u plz tell me y we r using TExt Function here. >> >> O

Re: $$Excel-Macros$$ difference time calculation

Dear Waheed, Text Function are used to convert time differences as Hour:Minute:Second Format. On Fri, Sep 2, 2011 at 5:02 PM, Shaik Waheed wrote: > Hi Noorain, > Can u plz tell me y we r using TExt Function here. > > On Fri, Aug 19, 2011 at 2:45 PM, NOORAIN ANSARI > wrote: > > Dear Jayendra,

RE: $$Excel-Macros$$ Pivot Table data extract

Sorry.. just to reframe the question... I wanted all the details but not in "Table" format, because there I again need to convert the table to Range I want the information in normal format without any formatting. Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macr

Re: $$Excel-Macros$$ difference time calculation

Hi Noorain, Can u plz tell me y we r using TExt Function here. On Fri, Aug 19, 2011 at 2:45 PM, NOORAIN ANSARI wrote: > Dear Jayendra, > > Please use below formula & see attached sheet.. > > =TEXT((C2+D2)-(A2+B2),"[H]:mm:ss") > > -- > Thanks & regards, > Noorain Ansari > http://noorain-ansari.blo

Re: $$Excel-Macros$$ Pivot Table data extract

Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- "Enable Show Details". On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi Expert, > > ** ** > > In Pivot table data details, when we double click on any

$$Excel-Macros$$ Pivot Table data extract

Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in "Table Format" and everytime we have to do "Convert

$$Excel-Macros$$ write and read cookies through vba.

Hi Expert. Is there any way to write and read cookies through vba. Thanks in advance. Divaker -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce

Re: FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Dear Amit, You can use Sumproduct instead of Countifs for Multiple Criteria.. See example.. =*SUMPRODUCT(--(A2:A30=F24)*(B2:B30=G24)*(C2:C30=H24))* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Sep 2, 2011 at 3:21

Re: $$Excel-Macros$$ Macro to remove repeats and merge

Dear Gaetan, Please see attached sheet if it help to u... ** *Sub Remove_Duplcate_and_Merge() **Dim i, j As Integer Application.ScreenUpdating = False Application.DisplayAlerts = False For i = 1 To Sheet1.UsedRange.Rows.Count If Sheet1.Cells(i, 1).Value = Sheet1.Cells(i, 2).Value Then Sheet1.Range

FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Dear Rajan, Thanks for this..but I do want to edit the attached formula, please explain the same how to do ? Also I want to have the formula with criteria of either or (in countifs we used to add 2 count ifs) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf

$$Excel-Macros$$ Creating shapes from lists of co-ordinates

I have a set of data which haas co-ordinates for different geographic areas (e.g. counties). This data takes the form: County: Shropshire Shropshire Point #: 1 2 X: 43.543.5 Y: 5.6 5.65 And s

$$Excel-Macros$$ simple vba code to run word up and down

Hi experts excel 2007 Enter Your Name: abcede Press enter after pressing enter a should run down wards up to certain destination. then B,C,D,E each should go seperate and after completion of letters again run towards up with blinking. Please do it. Thanks in advance -- ---

$$Excel-Macros$$ Job

*Experience:* 2 - 6 Years *Location:* Gurgaon *Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization,Post Graduation Not Required *Industry Type:* Banking/Financial Services/Broking *Role:* Other *Functional Area:* Other Job Description Data colle

Re: $$Excel-Macros$$ stock on hand report generate

hi venkat sure see attached copy help on user form to enter reciepts and issues. thanks in advance. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

RE: $$Excel-Macros$$ Freeze panes in an Excelsheet Control on a userform

Erratum : Private Sub Spreadsheet1_Click() Me.Spreadsheet1.Windows(1).FreezePanes = True End Sub Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de John Holland Envoyé : jeudi 1 septembre 2011 11:30 À : MS EXCEL AND VBA

RE: $$Excel-Macros$$ Freeze panes in an Excelsheet Control on a userform

Try : Private Sub Spreadsheet1_Click() Me.Spreadsheet1.Windows(1).FreezePanes = True End Sub HTH Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de John Holland Envoyé : jeudi 1 septembre 2011 11:30 À : MS EXCEL AND VBA

Re: $$Excel-Macros$$ Vlookup with 2 criteria

Dear All Rally thanks for Kind help Shrinivas On Wed, Aug 31, 2011 at 9:20 PM, NOORAIN ANSARI wrote: > Dear Shrinivas, > > Please see attached sheet.. > > *=VLOOKUP(H6&I6,A4:D8,4,0)* > Alternative solutions... > > *{=INDEX(D4:D8,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0))} > {=OFFSET(D3,MATCH(1,(B4:B8=H6)*

RE: $$Excel-Macros$$ ***VBA code to copy and save as new book***

Try this Also.. Option Explicit Sub Mtest() On Error GoTo Err: Application.DisplayAlerts = False Application.ScreenUpdating = False Dim sPath As String, sFname As String Application.FileDialog(msoFileDialogFolderPicker).Title = "Choose Location to save" Application.FileDialog(msoFileD

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- "Enable Show Details". For the date format i think its working fine in both rows n columns. On Thu, Sep 1, 2011 at 10:18 PM, Prabhu wrote: > Hi Friends, > I think topic got changed. Actually i have a

RE: $$Excel-Macros$$ Macro to remove repeats and merge

I think Remove duplicate is the Best option : -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Gaetan M Sent: Wednesday, August 31, 2011 6:00 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Macro to remove repeats and m

Re: $$Excel-Macros$$ Guru's Pls reply me

Thanks:) On Wed, Aug 31, 2011 at 10:36 PM, NOORAIN ANSARI wrote: > Dear Kanan, > > Please see attached sheet.. > > On Tue, Aug 30, 2011 at 6:25 PM, kannan excel wrote: > >> Hi Excel Guru's, >> >> PFA >> >> pls help me. i want to report for daily actions. like Activation how much, >> rejectio