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

2018-01-06 Thread Mangesh Vimay
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? It’s > =TIME(2,DO:IT,N:O

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

2015-10-08 Thread Mangesh Vimay
he may not recognize 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

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

2015-10-08 Thread Mangesh Vimay
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 difficult. > > First of all, by "

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

2013-08-20 Thread Mangesh Vimay
gt; Target = TextBox1.Text > End Sub > > 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

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

2013-08-19 Thread Mangesh Vimay
Hi Friends, Please suggest me vba code to enter the text in A1, A2, A3..likewise by using VBA Userform textbox. I have attached sample file for you reference. Double click on cell A1, A2 will open the useform for which I need the code. Thanks in advance. -- With regards, *MaNgEsH* -- Are you

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

2013-07-28 Thread Mangesh Vimay
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 wrote: > Hi, > > I want to set particular date and* time* also for expire is this > possible.??? > > Or i want to set date and time for passw

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

2013-07-07 Thread Mangesh Vimay
Thank you very much !!! On 7/7/13, vba 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 > wrote: > >> Hi, >&g

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

2013-07-06 Thread Mangesh Vimay
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 wrote: > Thanks for Acknowledgement.. Cheers!! > > > On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay > wrote: > >> Thanks

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

2013-07-06 Thread Mangesh Vimay
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 wrot

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

2013-07-06 Thread Mangesh Vimay
me is created by this Macro: > > 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 > w

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

2013-07-06 Thread Mangesh Vimay
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 wrote: > Hey > > PFA. > > HTH > > > On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay > wrote: >

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

2013-07-05 Thread Mangesh Vimay
3, Bé Trần Văn 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 > >> Hi Frien

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

2013-07-05 Thread Mangesh Vimay
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 lis

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

2013-02-11 Thread Mangesh Vimay
; like to do , > > > On Mon, Feb 11, 2013 at 2:04 PM, Mangesh Vimay wrote: > >> Friends, >> >> Please help me to get this issue resolved. >> >> Thanks in advance !!! >> >> On 2/10/13, Mangesh Vimay wrote: >> > Hi Friends, >> &g

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

2013-02-11 Thread Mangesh Vimay
Friends, Please help me to get this issue resolved. Thanks in advance !!! On 2/10/13, Mangesh Vimay 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 !!! > > -- &

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

2013-02-10 Thread Mangesh Vimay
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 o

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

2012-11-20 Thread Mangesh Vimay
Thank you so much Natron. You have made my work very easy. Thanks again. On Tue, Nov 20, 2012 at 6:35 PM, Natron 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 > Private Sub cmdExp

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

2012-11-20 Thread Mangesh Vimay
Hi Friends, Please help me by providing the solution. Thanks in advance. -- Forwarded message -- From: Mangesh Vimay 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. To: excel-macros

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

2012-11-19 Thread Mangesh Vimay
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 officia

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

2012-11-09 Thread Mangesh Vimay
but how? Can you help me please. On 11/9/12, Anoop K Sharma wrote: > Use Clean function > > > > On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay > wrote: > >> Hi Friends, >> >> I need your help. >> I have Excel file containing some data. I have impor

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

2012-11-08 Thread Mangesh Vimay
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 cha

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

2012-10-23 Thread Mangesh Vimay
uot; >> rs.Close >> cn.Close >> Exit Sub >> End If >> >> >> Set xla = New Excel.Application >> Set wk = xla.Workbooks.Add >> >> For i = 0 To rs.Fields.Count - 1 >> wk.Sheets(1).Cells(1, i + 1).Value = rs.Fields(i).Name >> Next

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

2012-10-19 Thread Mangesh Vimay
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 r

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

2012-10-10 Thread Mangesh Vimay
Awesome !!! Aisa bhi hota hai Excel mein ...??? Surprise !!! On 10/10/12, Ahmed Honest 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, so that we becom

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

2012-10-03 Thread Mangesh Vimay
t; > *+91 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 -

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

2012-10-03 Thread Mangesh Vimay
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. Tha

Re: $$Excel-Macros$$ Excel vba

2012-09-12 Thread Mangesh Vimay
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 wrote: > I don't mean to be difficult, or unhelpful, or snotty, or seem to be any > other bad description, > but this group is designed to help people that a

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

2012-09-11 Thread Mangesh Vimay
Thanks Rajan. On Tue, Sep 11, 2012 at 8:46 PM, Rajan_Verma wrote: > *Is it?* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroup

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

2012-09-11 Thread Mangesh Vimay
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:*

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

2012-09-11 Thread Mangesh Vimay
Where is the file ? On Sun, Sep 9, 2012 at 7:49 PM, Sara Lee 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 run this

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

2012-09-11 Thread Mangesh Vimay
> **·**Then hit *F2* (edit cell) and *Ctrl-Shift-Enter* (confirm > array formula). This confirms a multi-cell array formula over the selected > cells. > > **·**Copy the array-entered range from row 2 (e.g. B2:D2) to > every other row in your table. > > *

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

2012-09-10 Thread Mangesh Vimay
; *End Function* > > * * > > *See the attached file.* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Beh

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

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

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

2012-09-10 Thread Mangesh Vimay
Thanks ALL for the Great Help !!! On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon 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(B2&C2)+3,99) > > > On 10 September

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

2012-09-10 Thread Mangesh Vimay
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 wrote: > Dear Mangesh, > > you can use text to colum > > Regard > Manoj > > > On Mon, Sep 10, 2012 at 4

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

2012-09-10 Thread Mangesh Vimay
Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM R

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

2012-09-07 Thread Mangesh Vimay
Thats Great !!! On 9/8/12, dguillett1 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$$ Urgent... Pl

Re: $$Excel-Macros$$ show only last four digit of the number

2012-09-07 Thread Mangesh Vimay
Hi, Use =LEFT(SUBSTITUTE(A17,LEN(A17)-LEN(RIGHT(A17,4))-2,"*"),7)&RIGHT(A17,4) Where, A17 is the Address of the cell containing string "555-55-5505". On 9/7/12, Sam Mathai Chacko wrote: > Would this help? > > Regards, > Sam Mathai Chacko > > On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786maks.

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

2012-09-04 Thread Mangesh Vimay
Hi Prince, Thanks. But please let me know if this is vba code or something else. On 9/4/12, Prince Dubey wrote: > > Hi Mangesh > > You can use an sddin to simplify your task for example you can use SQLodbc > ( > *http://sqlodbc.t35.com* ) > =sql.execute("CONNECTION STRI

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

2012-09-03 Thread Mangesh Vimay
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 wrote: > Hi Noorain, > > You have sent very good file for learning PT with all options in terms

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

2012-09-03 Thread Mangesh Vimay
Thanks you Ashish On 9/3/12, ashish koul 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:0

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

2012-09-03 Thread Mangesh Vimay
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 wrote: > Dear Kaushik, > > Please find attached VBA Pivot Table Template, Hope it will help to you. > > --

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

2012-09-03 Thread Mangesh Vimay
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 this

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

2012-09-03 Thread Mangesh Vimay
Congratulations Noorain for your great support. On 9/3/12, rameshwari shyam wrote: > Hi Noorain sir, > > Congratulation to help people > > thanks & regards, > Rameshwari > > On Sun, Sep 2, 2012 at 9:02 AM, Ayush Jain wrote: > >> Dear members, >> >> Once again, Noorain Ansari has been selected as

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

2012-08-27 Thread Mangesh Vimay
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 > *To:* excel-macros@googlegroups.com > *Sent:*

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

2012-08-27 Thread Mangesh Vimay
Simply Awesome !!! On Sat, Aug 25, 2012 at 1:51 PM, amar takale 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, wrote: > >> ** >> Hi Amar >> >> I built the dashboard in 2007 a

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

2012-08-24 Thread Mangesh Vimay
Mind blowing Rajan !!! On Fri, Aug 24, 2012 at 7:40 PM, Hilary Lomotey 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, 2012 at 1:47 P

Re: $$Excel-Macros$$ Hook Chart

2012-08-23 Thread Mangesh Vimay
Nice !!! On Thu, Aug 23, 2012 at 10:12 AM, अनिल नारायण गवली wrote: > Gr8 work rajan .:) > > Regards, > Gawli Anil > > On Wed, Aug 22, 2012 at 9:34 PM, Hilary Lomotey wrote: > >> i love the chart, nice work bro >> >> >> On Wed, Aug 22, 2012 at 3:35 PM, Kuldeep Singh >> wrote: >> >>> >>> Hi S

Re: $$Excel-Macros$$ Business analyst

2012-08-22 Thread Mangesh Vimay
Hi Friends, Can you provide me same kind of Books on "Data Analysis by using Excel 2007/2010". Thanks On Sun, Aug 19, 2012 at 2:50 PM, Amit Desai (MERU) wrote: > Check the below link, the same covers latest book BABOK version 2 > (Business Analyst Body of Knowledge) by IIBA. > > ** ** > > h

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

2012-08-13 Thread Mangesh Vimay
at Windows Login and Logout >> that will make entries to a log file. >> >> >> *Paul* >> >> - >> *“Do all the good you can, >> By all the means you can, >> In all the ways you can, >> In all the places

$$Excel-Macros$$ Need your help

2012-08-13 Thread Mangesh Vimay
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 *1

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

2012-08-09 Thread Mangesh Vimay
sh, >> >> see attached workbook without protection. >> >> >> On Thu, Aug 9, 2012 at 8:28 PM, Mangesh Vimay wrote: >> >>> Dear Noorain, >>> >>> The attendance tracker is locked. If it is possible, can u provide >>> password so t

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

2012-08-09 Thread Mangesh Vimay
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 wrote: > Thanks bro > > > On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay wrote: >

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

2012-08-09 Thread Mangesh Vimay
So Awesome Noorain Bhai !!! On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI wrote: > Dear Ashish, > > Please find attached updated attendance tracker. > > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com > http://

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

2012-08-07 Thread Mangesh Vimay
> > > *Paul* > > - > *“Do all the good you can, > By all the means 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.” -

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

2012-08-07 Thread Mangesh Vimay
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 @ https://www.facebook.com/discussexcel

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

2012-07-31 Thread Mangesh Vimay
acko >> >> >> On Tue, Jul 31, 2012 at 12:10 AM, dguillett1 wrote: >> >>> I did not look at your file because you subject line did not have a >>> meaningful question and you did not ask your question in the body of the >>> email. It is good that you did pr

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

2012-07-30 Thread Mangesh Vimay
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, For

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

2012-07-19 Thread Mangesh Vimay
l > 3. Consolidate > > > > > > On Thu, Jul 19, 2012 at 3:25 PM, Mangesh Vimay wrote: > >> Hi Friends, >> >> Please help me on "HOW TO CREATE REPORTS IN EXCEL" by providing suitable >> examples so that I could learn it. >> Thanks. >> &

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

2012-07-19 Thread Mangesh Vimay
ts are looking for? > > > > On Thu, Jul 19, 2012 at 1:55 PM, Mangesh Vimay wrote: > >> Hi Friends, >> >> Please help me on "HOW TO CREATE REPORTS IN EXCEL" by providing suitable >> examples so that I could learn it. >> Thanks. >> >> -- >&

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

2012-07-19 Thread Mangesh Vimay
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$$ Please help me.

2012-07-17 Thread Mangesh Vimay
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 Vimay wrote: > >> Please tell us so that we can edit and learn it. How to mak

Re: $$Excel-Macros$$ Vlookup Problem

2012-07-17 Thread Mangesh Vimay
>> >> >> Thanks, >> Venkatesh. >> >> >> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay >> wrote: >> > Hi Friends, >> > >> > Please solve my VLookup Query. >> > Description is given in attached file. >> > Thanks.

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

2012-07-17 Thread Mangesh Vimay
Thank you much for kind support. !!! On Tue, Jul 17, 2012 at 11:17 AM, NOORAIN ANSARI wrote: > Dear Mangesh, > > See attached Screen shot. > > > On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay wrote: > >> Please help me on below problem. >> Thanks >>

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

2012-07-16 Thread Mangesh Vimay
Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay wrote: > 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] > > &

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

2012-07-16 Thread Mangesh Vimay
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, Jul 16, 2012 at 6:24 PM, Mangesh Vimay wrote: > Thanks a ton !!! > > > On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANS

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

2012-07-16 Thread Mangesh Vimay
w.excelmacroworld.blogspot.com > > On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay wrote: > >> Hi Noorain. >> Thanks but I do not understand how did you calculated the Average Salary >> ($) by using *calculated field*. Please provide me documentation so that >>

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

2012-07-16 Thread Mangesh Vimay
hed sheet ...Like this u want? >> >> >> Regards, >> Gawli Anil >> >> On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay >> wrote: >> >>> Hi Friends, >>> >>> I need your help to solve my PT Problem. >>> The descri

Re: $$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread Mangesh Vimay
B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))* > > or > > *=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)* > > with ctrl+shift+Enter > > See attached sheet. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworl

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

2012-07-16 Thread Mangesh Vimay
Attached sheet ...Like this u want? > > > Regards, > Gawli Anil > > On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote: > >> Hi Friends, >> >> I need your help to solve my PT Problem. >> The description is given in sheet itself. Please FA. >> >>

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

2012-07-16 Thread Mangesh Vimay
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 wrote: > Dear Manoj, > > Please find attached simple Calender. > > You can create it simply. > > On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar > wrote: > >> De

Re: $$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread Mangesh Vimay
so much On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay wrote: > Thank you much Suman > > > On Mon, Jul 16, 2012 at 4:48 PM, Suman wrote: > >> Dear Mangesh, >> Please find the attached file as I have learnt this one form Noorain sir >> in this group. >

Re: $$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread Mangesh Vimay
Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman 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 wrote: > >> Hi Friends, >> &g

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

2012-07-16 Thread Mangesh Vimay
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 H

$$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread Mangesh Vimay
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, Cod

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

2012-07-11 Thread Mangesh Vimay
Please send new sheet as previous sheet is protected or provide the password. On Wed, Jul 11, 2012 at 4:36 PM, Abdulgani Shaikh wrote: > 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 > wrote: > >> Dear Abdul, >> >> In att

Re: $$Excel-Macros$$ PLease Help

2012-07-04 Thread Mangesh Vimay
Thanks Noorain On 7/4/12, NOORAIN ANSARI wrote: > Dear Mangesh, > > Please use it.. > > =TEXT(B2-A2,"[H]:mm:ss") > > On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay > wrote: > >> I need diff in between these two dates in Hours >> Start Da

$$Excel-Macros$$ PLease Help

2012-07-04 Thread Mangesh Vimay
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, accurat

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

2012-07-04 Thread Mangesh Vimay
lt;> "" 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, 20

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

2012-07-04 Thread Mangesh Vimay
Hi Friends/Ashish, How will you put this formula in vba code. please tell. On 7/4/12, Mangesh Vimay wrote: > Thank you so much mere bhai u saved my job > > On 7/4/12, ashish koul wrote: >> = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Ho

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

2012-07-04 Thread Mangesh Vimay
Thank you so much mere bhai u saved my job On 7/4/12, ashish koul wrote: > = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours")) > > > > On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay > wrote: > >> Hi Friends, >> &g

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

2012-07-04 Thread Mangesh Vimay
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, Code

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

2012-07-02 Thread Mangesh Vimay
Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. Rule # 05 On 7/2/12, harshita desu wrote: > Medha Information research Offering In House, Online and Corporate > training on Excel VBA > > Course Highlights > > Fully handson Sessions. > > Realtime exa

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

2012-07-02 Thread Mangesh Vimay
If Sachin Tendulkar is God of Cricket then Definitely Noorain Ansari is God of Excel. On 7/2/12, NOORAIN ANSARI wrote: > Most Welcome bro.. > > I am not god, i m a simple Excel Lover like you. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com >

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

2012-06-28 Thread Mangesh Vimay
Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest 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 being in a sheet when

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

2012-06-28 Thread Mangesh Vimay
> displayed so being in a sheet when you click on that Icon you will get > another sheet. > > > > Revert if you failed to understand the above. I think this option should > meet your requirement 100%. > > > > Hi Rajan, > > > > Try to read of what I have

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

2012-06-27 Thread Mangesh Vimay
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

2012-06-26 Thread Mangesh Vimay
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 thre

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

2012-06-24 Thread Mangesh Vimay
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 wrote: > Dear Ashutosh, > > Please find attach

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

2012-06-21 Thread Mangesh Vimay
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 wrote: > Hi All, > > Please find the attached PPT consists of few useful excel functions > explained. I have prepared this document f

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

2012-06-20 Thread Mangesh Vimay
Thanks lot !!! On Wed, Jun 20, 2012 at 6:50 PM, Krishnaraddi 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. > > > > Dear *excel-

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

2012-06-19 Thread Mangesh Vimay
:$E$10,0),MATCH(I$8,$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 >>

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

2012-06-19 Thread Mangesh Vimay
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$$ Re: share Dashboard Examples/Templates

2012-06-19 Thread Mangesh Vimay
Thanks Noorain for sharing such nice examples..!!! On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI wrote: > PFA > > > On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay wrote: > >> Many many thanks for this >> >> >> >> >> On Tue, Jun 19

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

2012-06-19 Thread Mangesh Vimay
Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe 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 18, 2012 8:3

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

2012-06-18 Thread Mangesh Vimay
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, access

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

2012-06-12 Thread Mangesh Vimay
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 wrote: > > > Hi Mr. Rajan, > > Please also send Excel Power progra

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

2012-06-12 Thread Mangesh Vimay
It's really good to learn VBA Fundamentals. Thanks Rajan. mANgeSH. On Tue, Jun 12, 2012 at 7:23 PM, Rajan_Verma wrote: > Hi Guys > > ** ** > > Download from this Link for excel 2007 > > ** ** > > > http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pd

Re: $$Excel-Macros$$ Sheet Requirements

2012-06-12 Thread Mangesh Vimay
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 wrote: > Thanks. >i love excel very much, Actually i keep on trying the

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

2012-06-11 Thread Mangesh Vimay
Simply AwesomeUltimate Use of Excel Features !!! MAnGesh On Fri, Jun 8, 2012 at 6:36 PM, Deba Ranjan wrote: > Thanks Bhai. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Fri, Jun 8, 2012 at 6:32 PM, NOORAIN ANSARI > wrote: > >> See attachment >> >> >> On Fri, Jun 8, 201

  1   2   >