Re: $$Excel-Macros$$ excel help me

You can use left or right function by converting number to text.. On Jan 6, 2018 21:26, "Deepu Raj" wrote: > how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing > using excel > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Select all excel files in computer

Paul, I have been reading your codes since 2011. How do you manage to write these codes in so simple manner? Is there any logic? Please guide. Mangesh On Oct 8, 2015 6:45 PM, "Paul Schreiner" wrote: > The answer is "yes", you CAN. > How it's DONE is a bit more

Re: $$Excel-Macros$$ Select all excel files in computer

cognize when the assumption isn't correct. > So I try to explain WHY I selected a specific approach. > > Speaking of which... back to work! > > > > *Paul* > - > > > > > > > > *“Do all the good you can,By

Re: $$Excel-Macros$$ Need help - How to enter the text in the cells of column by using textbox in userform

Private Sub UserForm_Activate() Set Target = Selection TextBox1.Text = Target End Sub '-- Pada 19/08/2013 23:36, Mangesh Vimay menulis: Hi Friends, Please suggest me vba code to enter the text in A1, A2, A3..likewise by using VBA Userform textbox. I have attached

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

Thanks for asking this query. Appreciate your mind !!! And also thanks De Pemor for the solution. Have a great day all !!! On 7/29/13, Kannan Excel kannan.ex...@gmail.com wrote: Hi, I want to set particular date and* time* also for expire is this possible.??? Or i want to set date

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Thank you very much !!! On 7/7/13, vba v...@vabs.in wrote: Hi PFA... Reason for error: cell was referring to NA. Make sure cell is referred correctly. Thanks On Sun, Jul 7, 2013 at 10:04 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi, When I am trying to run the macro, I am

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi, Thanks for the help. But, how to create data validations in the first sheet based on the list which you have retrieved by using code. Please help. On 7/6/13, vba v...@vabs.in wrote: Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

: First Data sheet is sort on the basis of ID; then unique ID is pasted in range J2 downwards. Then Name is defined for each ID beginning with _ Cheers!! On Sat, Jul 6, 2013 at 2:45 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi, Thanks for the help. But, how to create data

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

paste formula in validation rng selection box and it will automatically create range from the second sheet and in second sheet you can add more data and those will be also add in list...but your second sheet data should formated as given by you. --- On Sat, 7/6/13, Mangesh Vimay mangesh.da

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

This group becomes special and the popular in a very small span of timebecause of the members like you and others. Thanks a lot !!! On 7/6/13, vba v...@vabs.in wrote: Thanks for Acknowledgement.. Cheers!! On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay mangesh.da...@gmail.comwrote

$$Excel-Macros$$ To create drop down list for many IDs as per many lists

Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down

Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists

Trần Văn betnmtdongna...@gmail.com wrote: You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting Name3. B2 Validation with Source = Name1 B3 Validation with Source = Name2 B4 Validation with Source = Name3 2013/7/6 Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have

Re: $$Excel-Macros$$ vba code to insert chart from another excel file

Friends, Please help me to get this issue resolved. Thanks in advance !!! On 2/10/13, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need vba code to insert a chart from another Excel file. I have attached sample sheet. Please do the needful. Thanks !!! -- With regards

Re: $$Excel-Macros$$ vba code to insert chart from another excel file

what would u like to do , On Mon, Feb 11, 2013 at 2:04 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Friends, Please help me to get this issue resolved. Thanks in advance !!! On 2/10/13, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need vba code to insert a chart

$$Excel-Macros$$ vba code to insert chart from another excel file

Hi Friends, I need vba code to insert a chart from another Excel file. I have attached sample sheet. Please do the needful. Thanks !!! -- With regards, *MaNgEsH* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

Fwd: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Hi Friends, Please help me by providing the solution. Thanks in advance. -- Forwarded message -- From: Mangesh Vimay mangesh.da...@gmail.com Date: Tue, Nov 20, 2012 at 12:24 AM Subject: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Thank you so much Natron. You have made my work very easy. Thanks again. On Tue, Nov 20, 2012 at 6:35 PM, Natron protoc...@gmail.com wrote: See attached, with the code I used below...there are many other ways to do this. 'This is hooked to your Export Specific Data Button on your form

$$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Hi Friends, I have attached the file where I need to export specific range to another excel file which to be save on C: drive. I have created userform for this as well. Need vba code to perform this task. Waiting for the solution. Please help !!! -- With regards, *MaNgEsH* -- Join

Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

but how? Can you help me please. On 11/9/12, Anoop K Sharma aks.sharm...@gmail.com wrote: Use Clean function On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS

$$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like question mark in square i.e. [image: Inline image 1], etc. I want to remove these

Re: $$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

).UsedRange.EntireColumn.AutoFit xla.Visible = True End Sub On Sun, Oct 21, 2012 at 9:24 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Deal ALL, Please help me on above issue. Please !!! With regards, Mangesh On Sat, Oct 20, 2012 at 11:08 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Ashish

$$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

Hi Friends, I am using MS Access 2007. I have table called City. The table City contains the information of the different cities of INDIA with their details. For example, CityDetails Mumbai It is the Financial capital of India Delhi Capital of India I have also form for

Re: $$Excel-Macros$$ Fun with Chart

Awesome !!! Aisa bhi hota hai Excel mein ...??? Surprise !!! On 10/10/12, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Rajan, Salute for your Support and Talent. Will it not be better to enlight us with your skills by having a list of topic to educate the group from that list one by one,

$$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA

Hi Friends, I need to create a chart based on the chart type selected from the drop down list (created by data validation). The sample data is being provided in the sheet. Every time when we create the chart previous chart should get deleted. [Find the attachment]. Please do it by using VBA.

Re: $$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA

7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 03 October 2012 6:39 *To:* excel-macros@googlegroups.com; Mangesh Vimay *Subject:* $$Excel-Macros$$ Help - To create chart based on the chart type select

Re: $$Excel-Macros$$ Excel vba

I am agree with Paul. This group is the main source of information on Excel and its basics. On Wed, Sep 12, 2012 at 7:40 PM, Paul Schreiner schreiner_p...@att.netwrote: I don't mean to be difficult, or unhelpful, or snotty, or seem to be any other bad description, but this group is designed

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

. **·**Copy the array-entered range from row 2 (e.g. B2:D2) to every other row in your table. ** ** Hope this is of interest, Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* Monday

Re: $$Excel-Macros$$ FW: macro for pivot

Where is the file ? On Sun, Sep 9, 2012 at 7:49 PM, Sara Lee lee.sar...@gmail.com wrote: --- ** *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 7:41 *To:* Rajan_Verma *Subject:* Re: macro for pivot ** ** once i copy and paste into a new module, how to

Re: $$Excel-Macros$$ FW: macro for pivot

Click on Sheet3 in VBE And paste that code* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 11 September 2012 8:40 *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ FW: macro for pivot

Thanks Rajan. On Tue, Sep 11, 2012 at 8:46 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Is it?* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

Thanks ALL for the Great Help !!! On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon da...@grugeon.com.au wrote: In B2 put =LEFT(A2,FIND(,,A2)-1) In C2 put =MID(A2,LEN(B2)+2,FIND(,,A2,LEN(B2)+2)-LEN(B2)-2) In d2 put =MID(A2,LEN(B2C2)+3,99) On 10 September 2012 21:04, Mangesh Vimay mangesh.da

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mangesh Vimay mangesh.da...@gmail.com *Sent:* Monday, September 10, 2012 6:11 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

* * * *See the attached file.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 10 September 2012 7:55 *To:* excel-macros@googlegroups.com *Subject:* Re

Re: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here)

Thats Great !!! On 9/8/12, dguillett1 dguille...@gmail.com wrote: me too.. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Friday, September 07, 2012 11:16 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ Re: How to import data from Oracle SQL to MS Excel ?

Hi Prince, Thanks. But please let me know if this is vba code or something else. On 9/4/12, Prince Dubey prince141...@gmail.com wrote: Hi Mangesh You can use an sddin to simplify your task for example you can use SQLodbc ( *http://sqlodbc.t35.com* http://sqlodbc.t35.com/)

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congratulations Noorain for your great support. On 9/3/12, rameshwari shyam rameshwarish...@gmail.com wrote: Hi Noorain sir, Congratulation to help people thanks regards, Rameshwari On Sun, Sep 2, 2012 at 9:02 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Once again,

$$Excel-Macros$$ How to import data from Oracle SQL to MS Excel ?

Hi Friends, I would like to import the data/query result of Oracle SQL to Excel. Can you please help me by providing suitable solution over my problem. You can also suggest VBA code/guidelines to solve the issue. Thanks lot !!! -- With regards, *MaNgEsH* -- Join official facebook page of

Re: $$Excel-Macros$$ Pivot Table Vba Help needed

Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 8/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kaushik, Please find attached VBA Pivot Table Template, Hope it

Re: $$Excel-Macros$$ How to import data from Oracle SQL to MS Excel ?

Thanks you Ashish On 9/3/12, ashish koul koul.ash...@gmail.com wrote: http://www.connectionstrings.com/Forum/excel/how-to-export-excel-worksheet-to-mysql-db-with-vba http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm On Mon, Sep 3, 2012 at 6:03 PM, Mangesh Vimay

Re: $$Excel-Macros$$ Pivot Table Vba Help needed

Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 9/3/12, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Noorain, You have sent very good file for learning PT with all options

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Simply Awesome !!! On Sat, Aug 25, 2012 at 1:51 PM, amar takale amartak...@gmail.com wrote: Hi Hilary I used Excel 2003 So I tell you it is possible to see excel 2003. No problem I will see it 2007. Thanks On Sat, Aug 25, 2012 at 1:40 PM, resp...@gmail.com wrote: ** Hi Amar I built

Re: $$Excel-Macros$$ You are gonna like it !!

Hi Rajan, Can you provide me link for the book EXCEL Charts.and.Graphs Please. Thanks. On Fri, Aug 24, 2012 at 11:28 PM, shashank bhosle catchshashankbho...@yahoo.co.in wrote: Mind Freaking Rajan !!! Awesome!!! *From:* Rajan_Verma rajanverma1...@gmail.com *To:*

Re: $$Excel-Macros$$ You are gonna like it !!

Mind blowing Rajan !!! On Fri, Aug 24, 2012 at 7:40 PM, Hilary Lomotey resp...@gmail.com wrote: I dont get it, can u xplain more, did u name the macro KK, i tried it nothing happened, however if i click outside the range its goes round. can u xplain how it works?. thansk On Fri, Aug 24,

$$Excel-Macros$$ Need your help

Hi Friends, Please help me on issue below. *Issue :-* I need such excel file which can automatically stored login time with date and logout time so that I could able to analysis for how much time my computer was switched on/in use. For example, If I login by the time *7:00:00 AM* and logout on

Re: $$Excel-Macros$$ Need your help

*- -- *From:* Mangesh Vimay mangesh.da...@gmail.com *To:* excel-macros@googlegroups.com; NOORAIN ANSARI noorain.ans...@gmail.com; rajan verma rajanverma1...@gmail.com *Sent:* Mon, August 13, 2012 8:48:16 AM *Subject:* $$Excel-Macros$$ Need your help Hi Friends, Please help me

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

So Awesome Noorain Bhai !!! On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ashish, Please find attached updated attendance tracker. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

Dear Noorain, The attendance tracker is locked. If it is possible, can u provide password so that I can learn how to develop such forms. Thanks. On Thu, Aug 9, 2012 at 7:55 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Thanks bro On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

, see attached workbook without protection. On Thu, Aug 9, 2012 at 8:28 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Dear Noorain, The attendance tracker is locked. If it is possible, can u provide password so that I can learn how to develop such forms. Thanks. On Thu, Aug 9, 2012

$$Excel-Macros$$ Need Help - To create the folder by the names which mentioned in the excel sheet.

Hi Friends. Please tell me how to create the folder by the names which I have entered in the sheet. For more information, please refer the attached sheet. Please provide me solution. -- With regards, MaNgEsH -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ Need Help - To create the folder by the names which mentioned in the excel sheet.

you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Mangesh Vimay mangesh.da...@gmail.com *To:* excel

Re: $$Excel-Macros$$ Need Help !!!!

a meaningful question and you did not ask your question in the body of the email. It is good that you did provide a file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mangesh Vimay mangesh.da...@gmail.com *Sent:* Monday, July 30, 2012 12:40 PM

$$Excel-Macros$$ Need Help !!!!

Hi Friends, Please help me on the sheet provided as an attachment. Waiting for your reply !!! Thanks ! -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL

Hi Friends, Please help me on HOW TO CREATE REPORTS IN EXCEL by providing suitable examples so that I could learn it. Thanks. -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL

for? On Thu, Jul 19, 2012 at 1:55 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please help me on HOW TO CREATE REPORTS IN EXCEL by providing suitable examples so that I could learn it. Thanks. -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL

. Consolidate On Thu, Jul 19, 2012 at 3:25 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please help me on HOW TO CREATE REPORTS IN EXCEL by providing suitable examples so that I could learn it. Thanks. -- With regards, MaNgEsH -- -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

Thank you much for kind support. !!! On Tue, Jul 17, 2012 at 11:17 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mangesh, See attached Screen shot. On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Please help me on below problem. Thanks On Mon

Re: $$Excel-Macros$$ Vlookup Problem

.. Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation

Re: $$Excel-Macros$$ Please help me.

and format the cells as you like. 7. Change the month and year in cell B2. The calendar updates automatically. After creating this calendar, you can copy the range to any other worksheet or workbook. Thanks Regards, *Deba Ranjan P* On Mon, Jul 16, 2012 at 4:56 PM, Mangesh

$$Excel-Macros$$ Vlookup Problem

Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ Please solve my Pivot Table Problem

Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Vlookup Problem

Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote: Dear Mangesh, Please find the attached file as I have learnt this one form Noorain sir in this group. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please

Re: $$Excel-Macros$$ Vlookup Problem

so much On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote: Dear Mangesh, Please find the attached file as I have learnt this one form Noorain sir in this group. On Mon, Jul

Re: $$Excel-Macros$$ Please help me.

Please tell us so that we can edit and learn it. How to make ? calender_Simple.xls file On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, Please find attached simple Calender. You can create it simply. On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

: Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Noorain, If I have to delete some fields as below then How could I do this? Like Salary in Dollar, Field1, Avg Sal in $ Please help. [image: Inline image 1] On Mon

Re: $$Excel-Macros$$ Numbers into Words

Please send new sheet as previous sheet is protected or provide the password. On Wed, Jul 11, 2012 at 4:36 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: Row no.28 Number marked in Yellow Row no.32 Words marked in Red On Wed, Jul 11, 2012 at 2:41 PM, NOORAIN ANSARI

$$Excel-Macros$$ Need Urgent Help on If statement

Hi Friends, Please find the attached sheet for if statement. Please help me dear all !!! -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Need Urgent Help on If statement

Thank you so much mere bhai u saved my job On 7/4/12, ashish koul koul.ash...@gmail.com wrote: = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours)) On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please find the attached sheet for if statement

Re: $$Excel-Macros$$ Need Urgent Help on If statement

Hi Friends/Ashish, How will you put this formula in vba code. please tell. On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote: Thank you so much mere bhai u saved my job On 7/4/12, ashish koul koul.ash...@gmail.com wrote: = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours)) On Wed

Re: $$Excel-Macros$$ Need Urgent Help on If statement

And rng.Value = 24 Then Test = 24 Hours ElseIf rng.Value And rng.Value 24 Then Test = 24 Hours Else Test = End If End Function * On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends/Ashish, How will you put this formula in vba code. please tell

$$Excel-Macros$$ PLease Help

I need diff in between these two dates in Hours Start Date End Date 4/1/2012 5:01 4/3/2012 6:15 Whatever the diff in between these two dats in terms of hours (hh:mm) Please help -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ PLease Help

Thanks Noorain On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please use it.. =TEXT(B2-A2,[H]:mm:ss) On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: I need diff in between these two dates in Hours Start Date End Date 4/1/2012

Re: $$Excel-Macros$$ Re: regarding problem on vlookup function

If Sachin Tendulkar is God of Cricket then Definitely Noorain Ansari is God of Excel. On 7/2/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Most Welcome bro.. I am not god, i m a simple Excel Lover like you. -- Thanks regards, Noorain Ansari www.noorainansari.com

Re: $$Excel-Macros$$ Excel VBA Training By Subject matter Experts

Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. Rule # 05 On 7/2/12, harshita desu harshita4d...@gmail.com wrote: Medha Information research Offering In House, Online and Corporate training on Excel VBA Course Highlights Fully handson

Re: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet

this ?? :-) Thanks, Ahmed Bawazir On Wed, Jun 27, 2012 at 6:03 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet

Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so

$$Excel-Macros$$ Need Help !!! How to add sheet under another sheet

Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

$$Excel-Macros$$ Types of data analysis used in the company

Hi Friends, Please tell me the types of data analysis which are used in the company to perform data operations. Please provide the information. Thanks !!! -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?

Hi All, I even can't imagine my entire life without this Group.. Agar mai successful raha to The contribution of this excel group would be 99.99% to my success. 0.01% I would like to keep for myself. Thanks 2 All !!! On 6/24/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear

Re: $$Excel-Macros$$ Formula for Username in a cell

So Nice and also I never seen such a nice tutorial on Excel, Good user friendly, easy and simply superb Thanks dear. On Thu, Jun 21, 2012 at 8:27 PM, Krishnaraddi excelkris...@in.com wrote: Hi All, Please find the attached PPT consists of few useful excel functions explained. I have prepared

Re: $$Excel-Macros$$ Excel Q A

Thanks lot !!! On Wed, Jun 20, 2012 at 6:50 PM, Krishnaraddi excelkris...@in.com wrote: Hi Experts, I have collected few questions regarding excel and updated in single document. I have also attached answers in separate excel sheet. I hope this will help few who are learning Excel.

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.com wrote: Hello Pankaj, As far as i know chandoo has greate dashboard templates for free , Attached you can find out a few chandoo dashboards , maybe they skipped your eyes. On Monday, June

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

Thanks Noorain for sharing such nice examples..!!! On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: PFA On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe

$$Excel-Macros$$ Need your help !!!

Hi Friends, In above example, if we input the name like ABC then it should display it's apropriate values in the table from the above list. Please find the attached sheet. How can we find the solution by using Vlookup() function? . Thanks -- With regards, MaNgEsH -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Need your help !!!

,$B$1:$E$1,0),0) with ctrl+Shift+enter -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, In above example, if we input the name like ABC then it should

Re: $$Excel-Macros$$ Re: MIS executive

Hi Friends, I am agree with Yogananda because many people are spending their time here to learn excel concepts with the intention to get the job and hence if someone is providing such nice opportunities then I think it is good. Moreover, only related job posting should be there (with excel,

Re: $$Excel-Macros$$ Sheet Requirements

Hi Dear, It happens with everybody specially when someone tries to learn new concepts of IT or any other topic. So keep going and this group is good to help you. MangeSH On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan drdeva...@gmail.com wrote: Thanks. i love excel very much, Actually i

Re: $$Excel-Macros$$ I want to learn macro from basic level

It's really good to learn VBA Fundamentals. Thanks Rajan. mANgeSH. On Tue, Jun 12, 2012 at 7:23 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Guys ** ** Download from this Link for excel 2007 ** **

Re: $$Excel-Macros$$ I want to learn macro from basic level

Hi Gulzar, As Rajan has mentioned in trail mail, download the desired e-book from the link http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pdf On Tue, Jun 12, 2012 at 9:50 PM, Gulzar Naqvi sgna...@hotmail.com wrote: Hi Mr. Rajan, Please also send

Re: $$Excel-Macros$$ Clock Chart (Excellent)

Simply AwesomeUltimate Use of Excel Features !!! MAnGesh On Fri, Jun 8, 2012 at 6:36 PM, Deba Ranjan drdeva...@gmail.com wrote: Thanks Bhai. Thanks Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 6:32 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: See attachment

Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....

Thanks All for their genuine help !!! Mangesh. On Fri, Jun 8, 2012 at 7:53 PM, dguillett1 dguille...@gmail.com wrote: Create combobox1 in sheet1 and then put this code in the SHEET module Private Sub Worksheet_Activate() Sheet1.ComboBox1.Clear Dim sh As Worksheet For Each sh In

Re: $$Excel-Macros$$ RE: FW: hi there...

Yes, sure and please think on it how to protect this group from such spams. Mangesh On Fri, Jun 8, 2012 at 9:29 PM, Rajan_Verma rajanverma1...@gmail.comwrote: It’s a spam I think ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:*