$$Excel-Macros$$ Navigate worksheet from Dropdown list

Hi Friends I have more than 100 worksheets in workbook. I used to open these worksheets by using input box. But there is problems to remember many worksheets. That is why I'm trying to navigate worksheet from drop down list. Please help me how we can navigate worksheet from drop down list. Ananta

Re: $$Excel-Macros$$ datediff problem

Not sure if you can. But you can use this Private Sub ComboBox9_Change() Dim dtmStart As Date Dim dtmEnd As Date If Day(CDate(TextBox1.Text)) > 12 Then dtmStart = CDate(TextBox1.Text) Else dtmStart = DateSerial(Year(CDate(TextBox1.Text)), Day(CDate(TextBox1.Text))

Re: $$Excel-Macros$$ List of text files with data to Excel.

Hi Noorain, The following are two examples of the text files that would be encountered. I have only shown the first and last 4 rows of the files. The over all length of the files is very variable but hold to the same format. Some files may end in *.out, *.txt or just *.. The files should all begin

Re: $$Excel-Macros$$ INTERVIEW Quetions

Hi Noorain, Thanks a lot... This looks very good and very helpful. Guys: Request you to please share some more knowledge if you have any these kind of Handy's Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: NOORAIN ANSARI Sender: excel-macros@g

Re: $$Excel-Macros$$ INTERVIEW Quetions

Thanks Noorain > >From: NOORAIN ANSARI >To: excel-macros@googlegroups.com >Sent: Wed, 14 September, 2011 8:36:57 AM >Subject: Re: $$Excel-Macros$$ INTERVIEW Quetions > > >Dear Hanumant, > >Please find attached EXCEL VBA Interview questions. > > >On Wed, Sep 14, 2011 at 1:25 AM, hanumant shinde

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

Thanks Kris > >From: Kris >To: excel-macros@googlegroups.com >Sent: Wed, 14 September, 2011 10:58:10 PM >Subject: Re: $$Excel-Macros$$ UNIQUE values in Array > >Hi, > > >I'm not sure you found a solution for this. This >link >http://www.excelfox.com/forum/showthread.php?31-Data-Validation-Depe

Re: $$Excel-Macros$$ Two columns and three criteria

Hi ArtySin, Refer the attachment file for details. Hope That Helps! --- Ms.Exl.Learner --- On Thu, Sep 15, 2011 at 9:39 PM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (unfortunately, corporate > no spend policy): These columns ha

Re: $$Excel-Macros$$ List of text files with data to Excel.

Dear John, Please share sample sheet with us On Thu, Sep 15, 2011 at 9:39 PM, johnofeasttex wrote: > Hello, > I need to look in individual directories of text files and create a > list in Excel showing all files in that directory in one column with > data from the first row starting with the le

Re: $$Excel-Macros$$ Two columns and three criteria

Dear Arty, Please try it and see attached sheet.. =SUMPRODUCT(--($A$4:$A$13={"Passed","Failed"})*(B4:B13=H6)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Two columns and three criteria

Dear Arty, Run a pivot table and make the count of Passed, Failed on the specific date by removing the N/A from the filters. I hope you know how to run the pivot table. Regards Ahmed Bawazir On Thu, Sep 15, 2011 at 7:09 PM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (un

$$Excel-Macros$$ Two columns and three criteria

Hi I have two columns as below using Excel 2000 (unfortunately, corporate no spend policy): These columns have been exported from a database and appear as the example below. A B Status Date Run Passed 22/08/2011 Failed 22/08/2011 Failed 23/08/2011 Passed

$$Excel-Macros$$ List of text files with data to Excel.

Hello, I need to look in individual directories of text files and create a list in Excel showing all files in that directory in one column with data from the first row starting with the letter "N" parsed into the adjacent 2 columns. The data will be of various lengths but the format will look like

Re: $$Excel-Macros$$ datediff problem

cant we change it for indian format ? On Thu, Sep 15, 2011 at 8:43 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > > Please try it..and see attached sheet.. > ** > *Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) > TextBox17.Text = VBA.DatePart("m", CDate(TextBox2.Text)) - >

Re: $$Excel-Macros$$ about dateserial

MS Excel: DateSerial Function (VBA only) -- In Excel, the *DateSerial* function returns a date given a year, month, and day value. The syntax for the *DateSerial* function is: DateSerial( year, month, day ) *year* is a numeric value between 100 and that repres

Re: $$Excel-Macros$$ datediff problem

Dear Bheema, Please try it..and see attached sheet.. ** *Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox17.Text = VBA.DatePart("m", CDate(TextBox2.Text)) - VBA.DatePart("m", CDate(TextBox1.Text)) End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacrowo

Re: $$Excel-Macros$$ datediff problem

On 15/09/2011, Sam Mathai Chacko wrote: > Shankar, > > The problem with date conversions of text formats to date formats in visual > basic 6 and VBA is that by default, it considers date as mm/dd/, and not > like the Indian version dd/mm/. In your case, 01-02-2011 is converted or > seen as

Re: $$Excel-Macros$$ datediff problem

Shankar, The problem with date conversions of text formats to date formats in visual basic 6 and VBA is that by default, it considers date as mm/dd/, and not like the Indian version dd/mm/. In your case, 01-02-2011 is converted or seen as 2nd January 2011. To avoid this, use dd-mmm- fo

$$Excel-Macros$$ about dateserial

Pls explain the usage of Dateserial function ? if possible provide me example -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

$$Excel-Macros$$ datediff problem

hai all, I am attaching my excel sheet userform. I am getting wrong result of months in different way. for example : Actual months difference between 01-02-2011 and 30-06-2011 are 5 months but the result coming as 4 pls provide solution -- -

Re: $$Excel-Macros$$ extract figure from one userform to other userform

its working and thank you so much for the solution. On Thu, Sep 15, 2011 at 6:29 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > Please see attached sheet..if it help to u.. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* >

Re: $$Excel-Macros$$ opening a particular record from the userform

Dear Bheema, Please share your workbook with us. On Thu, Sep 15, 2011 at 6:20 PM, Shankar Bheema wrote: > I am having excel data and designed a form using EXCEL VBA. each record of > the excel is represented with a number. I will call the data onto the > userform using the particular number. W

$$Excel-Macros$$ opening a particular record from the userform

I am having excel data and designed a form using EXCEL VBA. each record of the excel is represented with a number. I will call the data onto the userform using the particular number. When I connected the excel data to my crystal reports 9, all the records are coming onto the report form. But I w

$$Excel-Macros$$ code to link report form to the userform

I am using crystal report 9 to make reports from excel data. How to access the report from the userform command button ? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ extract figure from one userform to other userform

I am attaching the example file. userform1 contains A and B textboxes. B value should get from the other form. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://

Re: $$Excel-Macros$$ Fwd: Finding Merged cells in excel

Or, if you just want to remove, try Sub unmergecells() Cells.MergeCells = False End Sub From: NOORAIN ANSARI Sent: Thursday, September 15, 2011 6:12 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Finding Merged cells in excel Dear Amit, Please try it. Sub f

Re: $$Excel-Macros$$ Finding Merged cells in excel

To find a merged cell in Excel 2003. 1. Open a Find and Replace Menu. 2. Next to the Find What Field is a Format Box, Click it. 3. This opens the Find Format Menu screen which looks very similar to the Cell Format Tabs and screens 4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrin

$$Excel-Macros$$ Finding Merged cells in excel

Hi Folks I am finding some problem in excel data. Pls help me here. I have a excel data in 10 columns and 2 rows. There are some MERGED CELLS in this data. I am applying filters and its not working due to merged data. Is there any way in Excel to find merged cells automatically. Pls help me h

Re: $$Excel-Macros$$

Dear Nannu, See attached Sheet if it help to u... -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Sep 15, 2011 at 4:43 PM, naanu v wrote: > I h

Re: $$Excel-Macros$$

Dear Expert, Will you please explain why to mutiply date value with 100? Regards, Zafar Iqbal On Thu, Sep 15, 2011 at 2:53 PM, §»VIPER«§ wrote: > hi > > pfa > > > -- > *Great day,* > *viper* > -- -- Some impo

Re: $$Excel-Macros$$

Hi Viper, you have viped away the attachment lol, there is no attachment attached. *Great day, Bawazir * On Thu, Sep 15, 2011 at 2:52 PM, §»VIPER«§ wrote: > hi > > pfa > > > -- > *Great day,* > *viper > > * > On Thu, Sep 15, 2011 at 5:05 PM, Abhishek Jain wrote: > >> Dear Naanu, >> >> P

Re: $$Excel-Macros$$

hi pfa -- *Great day,* *viper * On Thu, Sep 15, 2011 at 5:05 PM, Abhishek Jain wrote: > Dear Naanu, > > Please check the attached sheet. > > Cheers! > > AJ > > > On Thu, Sep 15, 2011 at 4:43 PM, naanu v wrote: > >> I have a database of some persons with their birth dates. Now I want to >

Re: $$Excel-Macros$$

Dear Naanu, Please check the attached sheet. Cheers! AJ On Thu, Sep 15, 2011 at 4:43 PM, naanu v wrote: > I have a database of some persons with their birth dates. Now I want to > sort the birthdates with a formula in another sheet. Kindly let me know how > to do. > > > > Record in main sheet

$$Excel-Macros$$ Fwd: Finding Merged cells in excel

Dear Amit, Please try it. *Sub findmerged_cell() Dim str As String Dim stri As String For Each c In Selection If c.MergeCells Then str = c.Address stri = stri & "," & str End If Next stri = "(" & Mid(stri, 2, 1000) & ")" Range(stri).Select End Sub * Thanks & regards, Noorain Ansa

Re: $$Excel-Macros$$ TDL PROGRAMMING

Dear Sudhir, Please see below link.if it help to u.. http://www.tallydeveloper.com/ On Thu, Sep 15, 2011 at 1:08 PM, Sudhir Kumar wrote: > DEAR ALL, > > ** ** > > ** ** > > ANY ONE HELP IN CODDING OF TDL IN TALLY FOR ATTACHING SALES VOUCHER CLASS > WITH LEDGER > > * * > > *

$$Excel-Macros$$ TDL PROGRAMMING

DEAR ALL, ANY ONE HELP IN CODDING OF TDL IN TALLY FOR ATTACHING SALES VOUCHER CLASS WITH LEDGER Sudhir Verma Asstt. Mngr. A/c's QUALITY HOME APPLIANCES 47, RAJASTHANI UDYOG NAGAR DELHI - 1

Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer

Hello Mahess, I haven't changed the logo of the file but it's format. If you check the file extention of the file it is .xlsb Thank you Steve. On Thu, Sep 15, 2011 at 11:10 AM, Mahess Desai wrote: > Hi! Steve, > > When I down loaded your attachment, found that the Excel file has a stand > alone lo

$$Excel-Macros$$ Bingo Card Spreadsheet

This is kind of cool, thought I would share. It randomly places the 25 possible choices in the bingo spaces without any duplicates. I'm sure you can use the VBA logic for something else. -- -- Some important links f