$$Excel-Macros$$ Re: Fwd: Need your Help on Priority

2017-03-13 Thread Mohd Sadiq
Team , Pls try to help on this. On Fri, Mar 10, 2017 at 10:47 PM, Mohd Sadiq wrote: > Pls help team on the same > > Regards, > > Mohd Sadiq > > On Feb 28, 2017 9:22 PM, "Mohd Sadiq" wrote: > >> Hello Team , >> >> >> >> >> Hope you are doing well, >> >> >> >> Here is attached a file where I nee

$$Excel-Macros$$ Re: Fwd: Need your Help on Priority

2017-03-10 Thread Mohd Sadiq
Pls help team on the same Regards, Mohd Sadiq On Feb 28, 2017 9:22 PM, "Mohd Sadiq" wrote: > Hello Team , > > > > > Hope you are doing well, > > > > Here is attached a file where I need Interval / Day wise staffing which is > mentioned in “H” Column, I am trying it multiple times to fixed Nigh

$$Excel-Macros$$ Re: Fwd: Vba Code for Outlook

2011-12-19 Thread Rohan
You can use a macro to send the emails, however you would have to a Excel sheet to store the name of the recipients and email address. Can write a macro if that works fine for you !! Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Re: Fwd: Need Formula or Macros

2011-07-20 Thread Anish Shrivastava
Hi Anwar, Please run the below code and see if it works fine.. -- Sub conc_test() Dim main_word As String 'cell_pointer = 0 lastrow = Sheets(1).Range("A2").End(xlDown).Row counter = 3 While counter <= lastrow Set present_cell = Range("E" & counter) Set present_cell1 =

$$Excel-Macros$$ Re: Fwd: Need Formula or Macros

2011-07-20 Thread cma.ankur
hi anwar, plz clarify ur query On Jul 19, 10:56 pm, john wrote: > I sorta see from the notes below the data what you are trying to do, > but the sample results do not seem to match the data.  ???  please > check it for correctness or explain further how you reached those > results > > On Jul 19,

$$Excel-Macros$$ Re: Fwd: Need Formula or Macros

2011-07-19 Thread Anwar Mohd
Hi Anish & John, Thanks for the reply. Attached the sample file. Please check Regards Shiek On Tue, Jul 19, 2011 at 11:45 PM, john wrote: > you answers in the notes a the bottom do not make sense. please > review > > On Jul 19, 5:26 am, Anwar Mohd wrote: > > Hi All, > > > > Can any one hel

$$Excel-Macros$$ Re: Fwd: Need Formula or Macros

2011-07-19 Thread john
I sorta see from the notes below the data what you are trying to do, but the sample results do not seem to match the data. ??? please check it for correctness or explain further how you reached those results On Jul 19, 5:26 am, Anwar Mohd wrote: > Hi All, > > Can any one help me with this. > >

$$Excel-Macros$$ Re: Fwd: Use The Same Vlookup To Find Two Different Values

2011-03-31 Thread Bhushan Sabbani
Your are welcome. I am glad that my solution helped out. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

$$Excel-Macros$$ Re: Fwd: Use The Same Vlookup To Find Two Different Values

2011-03-31 Thread bhavya khanna
Thanks a lot Bhushan On Tue, Mar 29, 2011 at 12:56 PM, Bhushan Sabbani wrote: > Dear Bhavya, > > Pls refer to attached file. > > Pls look to the column which are colored in yellow. > > > Warm Regards > Bhushan Sabbani > +91 98208 26012 > > > -- --

$$Excel-Macros$$ Re: Fwd: Excel 2003 vs 2007

2011-01-11 Thread Ayush
Thanks Raj for sharing knowledge with Group Members. I appreciate it. Best Regards, Ayush Jain Group Manager & Microsoft MVP. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

Re: $$Excel-Macros$$ Re: Fwd: Hide & Protect Sheet from other User

2010-11-11 Thread SHAH DARSHIL
Dear Ayush, Thanks .. it is also usefule for me. But i dont know VBA aslo. If you can breif in detail path then it will be great help for me. Thanks in advance. Regards, Darshil Shah. On Thu, Nov 11, 2010 at 8:38 AM, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Hemant > > You can use these V

$$Excel-Macros$$ Re: Fwd: Hide & Protect Sheet from other User

2010-11-10 Thread Ashish Jain
Hi Hemant You can use these VBA methods to solve your problem: Sheets(1).Visible = xlSheetHidden 'Hide the worksheet Sheets(1).Visible = xlSheetVeryHidden 'Hide the worksheet and won't be displayed in Unhide Worksheet dialog list Sheets(1).Protect("Password")'Replace password with yo

$$Excel-Macros$$ Re: Fwd: CAN HTML file Connect to Excel file

2010-08-11 Thread Soni.Rajender
Hi Rajesh We can import the data from the web, "Click on Data Tab --> From Web" (in office 2007) Regards Rajender Soni On Aug 10, 8:17 pm, Rajesh Nair wrote: > -- Forwarded message -- > From: Rajesh Nair > Date: Fri, Aug 6, 2010 at 1:27 PM > Subject: CAN HTML file Connect to E

$$Excel-Macros$$ Re: [Fwd: Help for format converson required]

2010-07-21 Thread Dilip Pandey
Hi Pradeep, I know that LIC works on Linux environment, no problems.. I have revamped the solution as per your requirements. Please see the attached file and get back in case of any queries. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail

Re: $$Excel-Macros$$ Re: [Fwd: Help for format converson required]

2010-07-20 Thread Sandeep Kumar Maurya
Hi, A good solution Dilip Ji. Please see the attached file with just a little modification. Thanks & Regards Sandeep On Tue, Jul 20, 2010 at 4:00 PM, Dilip Pandey wrote: > Hi Pradeep, > > Look out for green shaded cell in the attached spreadsheet, in which I have > done something for you. > >

$$Excel-Macros$$ Re: [Fwd: Help for format converson required]

2010-07-20 Thread Dilip Pandey
Hi Pradeep, Look out for green shaded cell in the attached spreadsheet, in which I have done something for you. Let me know if it works. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On

$$Excel-Macros$$ Re: Fwd: Help Accounting

2010-07-07 Thread Soni.Rajender
Hi You can find the same under Templates section in MS Excel. 1. Open MS Excel 2. Go to File -> New -> Templates -> More Templates -> Ledgers Regards Rajender Soni On Jul 8, 9:46 am, Dilip Pandey wrote: > FYI & FYNA...!! > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY >   MBA-HR,B.Com(Hons),

$$Excel-Macros$$ Re: Fwd:

2010-07-02 Thread George
Hi praveen, Let's say you have "United States of America" in "A1" cell and " " (space) in "A2" cell. Now you can run this code and get result in "A3" cell. Enjoy! Sub test1() Dim currentCell, currentLength, currentSymbol, i, currentSpace, j j = 1 Range("A2").Select currentSpace = A

$$Excel-Macros$$ Re: Fwd: VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-11 Thread Ayush
Dear Experts, Can someone help Punit on his request ? Thank you! BR, Ayush On Dec 11, 2:45 pm, punit poddar wrote: > Guys, pls help > > -- Forwarded message -- > From: punit poddar > Date: Dec 10, 2009 12:29 PM > Subject: VBA Code for Locking/Unlocking excel sheet using passwo

$$Excel-Macros$$ Re: Fwd: Urgent Help required

2009-11-20 Thread RolfJ
Ooops. I forgot to mention that you need to explicitly reference the MS Outlook library for the code I posted to be able to run by selecting Tools | References from the VBE main menu and then select 'Microsoft Outlook 11.0 (or 12.0) Object Library' from the 'Available References' list. Best wishes

$$Excel-Macros$$ Re: Fwd: Urgent Help required

2009-11-20 Thread RolfJ
I am not quite clear exactly when you would like an email to be sent. Is it when you change a cell in column A ('Subject Line') or when you update an email address in column D. Anyhow here is code that you could place in the VBA module associated with the worksheet you would like to respond to chan

$$Excel-Macros$$ Re: Fwd: FW: lookuphelplease.xls

2009-11-05 Thread Dave Bonallack
Hi Dellosa, See if the attached file gives you what you need. Regards - Dave. Date: Fri, 6 Nov 2009 10:20:53 +0800 Subject: $$Excel-Macros$$ Fwd: FW: lookuphelplease.xls From: osav...@gmail.com To: excel-macros@googlegroups.com Dear Gurus, Im trying to look up a value from a t

$$Excel-Macros$$ Re: Fwd: xls.

2009-10-19 Thread Dilip Pandey
Hi Anil Just answered this few seconds ago...!! Please let me know if you did'nt find my response. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/14/09, Anil Saxena wrote: > > Pls help me. > >

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

2009-09-24 Thread Chandra Gupt Kumar
Dear Sonal, I am afraid that the macro you are looking for may not be possible since name to be matched should be identical. If you find some solution, please let me know also. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

2009-09-23 Thread Sandeep Kumar Maurya
Hi Sonal, I take a look on your data and find that your data in file1 and file2 are not same as there are some short names and no middle name in one of the file but the other one has full name and short middle name. It can be done with VBA but if your data is not unique then there is no guarantee

$$Excel-Macros$$ Re: Fwd: Copy data from multiple workbooks

2009-09-18 Thread TAlgo
need real help On Sep 17, 1:06 pm, Algo Trading wrote: > All, > > I have a 'Master.xls' and multiple workbooks ( Posrep 1-2 to Posrep 9-16 ). > Those multiple workbooks have data in one sheet ("Main"). > > In each workbooks and sheet ("Main") > If any cell in Column B contains " Project Meal Tot

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-22 Thread Dhananjay Pinjan
Great Solution Mr. *Aindril De.* *That's what I am serching for.* Please can you tell me in detailed (or send a link) about "Custom Formatting" which is a very powerfull in Excell. Thanks in advance. Regards, Dhananjay On 8/16/09, Aindril De wrote: > > Dear Dhananjay, > > YOu can do a simple

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dilip Pandey
Hi Dhananjay, Thanks for encouraging words. This is done using custom format. Whenever you type in zero, it will treat that as "-". Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Aug 17, 2009

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dhartikumar Sahu
Hi Dhananjay Please find herewith excel file as per your requirement. U just set the currency 0="-" Dhartikumar On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > excel file. > > Can anyone pr

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dhartikumar Sahu
Hi Dhananjay Please find herewith excel file as per your requirement. U just set the currency 0="-" Dhartikumar On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > excel file. > > Can anyone prov

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread johnson john
its simple. use is error function. Pl. see the attachment. tx., On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > excel file. > > Can anyone provide me the solution as per the requirement in the

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Dilip Pandey
Hi Dhananjay, Solution is attached as per your requirements. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/15/09, Dhananjay Pinjan wrote: > Dear All, > > Please ignore the previous mail sent b

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Kavlya
Dear Dhananjay, Please change"-" to 0 & do formatting _(* #,##0.00_);_(* (#,##0.00);_ (* "-"??_);_(@_) Regards, Prashant On Aug 16, 8:54 am, Dave Bonallack wrote: > Hi, > Have a look at the attached. > I've used SUMIF. But I don't know why you don't want to use SUM. It works > just as well,

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Manish Purohit
Hi Dhananjay, Find the attached excel file with the solution. You can use N( ) to treat any string as 0. Manish Purohit Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world. _ From: excel-macros@googlegroups.com [mailto:excel-

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-16 Thread Aindril De
Dear Dhananjay, YOu can do a simple change in the formatting of the cells. Select the table, use custom format and choose General. Paste the following formatting. General;General;_-* "-"??_-;_...@_- Click oK. Now change all - with 0 . you will notice all 0 values will be represented as -. Hop

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-15 Thread Dave Bonallack
Hi, Have a look at the attached. I've used SUMIF. But I don't know why you don't want to use SUM. It works just as well, and is simpler. They are the results in red. Regards - Dave Date: Sat, 15 Aug 2009 17:21:35 +0530 Subject: $$Excel-Macros$$ Fwd: about to remove "#VALUE!" error From: dppin...

$$Excel-Macros$$ Re: Fwd: Remove Filter

2009-08-09 Thread Ujjwal Jha
The original file has 48000 line items...isnt there any way so that i can remove the filter from the same file without copy-paste. On Fri, Aug 7, 2009 at 2:29 AM, Harmeet Singh wrote: > made a copy of actual row and deleted the actual row afterwards. > > > On Thu, Aug 6, 2009 at 12:01

$$Excel-Macros$$ Re: Fwd: Remove Filter

2009-08-06 Thread Harmeet Singh
made a copy of actual row and deleted the actual row afterwards. On Thu, Aug 6, 2009 at 12:01 AM, Ujjwal Jha wrote: > could you please let me know how did you do it... > > On Wed, Aug 5, 2009 at 11:32 PM, Harmeet Singh > wrote: > >> done!!! >> >> On Wed, Aug 5, 2009 at 9:18 PM, Ujjwal J

$$Excel-Macros$$ Re: Fwd: Remove Filter

2009-08-05 Thread Ujjwal Jha
could you please let me know how did you do it... On Wed, Aug 5, 2009 at 11:32 PM, Harmeet Singh wrote: > done!!! > > On Wed, Aug 5, 2009 at 9:18 PM, Ujjwal Jha wrote: > >> Dear All, >> >> I am not able to remove the filter. Can anyone help me on this. >> -- >> >> Luv & Regards >> Ujjwal Jha >>

$$Excel-Macros$$ Re: Fwd: Please help me to solve the problm

2009-07-23 Thread tm
dear plz find attahced may this can suit your requriements. Reagrds.Toqeer On Sat, Jul 18, 2009 at 4:24 PM, shijomon joseph wrote: > Dear Friends, > Please help me to solve the problm.., I am attaching the sample sheet > also, > > Thanks in advance > > Best regards > > shijo > > --

$$Excel-Macros$$ Re: Fwd: Please help me to solve the problm

2009-07-18 Thread Daniel
Have a look at the attached file. Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of shijomon joseph Sent: samedi 18 juillet 2009 12:24 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Please help me to solve the problm Dear Frien

$$Excel-Macros$$ Re: Fwd: FW: MACRO EXCEL PROBLEM - i recd. back my query - by non posting article

2009-07-13 Thread Daniel
Give a try at the following macro. However, check the columns from : Cells(WhereToCopy, 9).FormulaR1C1 = "7/1/2009" I am not sure it should be column 9. Sub Macro2() ' ' Macro1 Macro ' ENTRY OF RENWAL DONE ' ' Keyboard Shortcut: Ctrl+Shift+A ' Dim WhereToCopy As Long, myRange A

$$Excel-Macros$$ Re: Fwd: plot

2009-06-12 Thread Dilip Pandey
Hi Jenny, Chart is done and is there in the attached workbook. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Fri, Jun 12, 2009 at 9:34 AM, jenny Hanson wrote: > Dear member, > > I have a question

$$Excel-Macros$$ Re: Fwd: plot

2009-06-12 Thread Akhilesh Karna
You need to copy the data to excel. The format of your data is not correct. Like, you will need to change 2.147.523 ---> 2147.523. In excel it is very easy to plot the data. Akhilesh Kumar Karna On Fri, Jun 12, 2009 at 1:04 PM, jenny Hanson wrote: > Dear member, > > I have a question . The qu

$$Excel-Macros$$ Re: Fwd: VBA help needed

2009-05-27 Thread Harish Bhatt
Hi Friends, I think this would be the solution to this problem. Sub datee() Dim rid As Integer Sheets("Sheet1").Activate Range("a1").Select rid = ActiveCell.End(xlDown).Row MsgBox rid Range("A" & rid).Select MsgBox ActiveCell.Value If ActiveCell.Value = Date Then Range("A" & rid).Select Else Act

$$Excel-Macros$$ Re: Fwd: VBA help needed

2009-05-27 Thread Dilip Pandey
Hi Frnds, Try using following code:- Sub datee() Range("b1").Select Selection.End(xlDown).Select 'Selection.End(xlUp).Select 'ActiveCell.Offset(1, 0).Select If ActiveCell.Value = Date Then Range("A1").Select Else ActiveCell.Value = Date End If End Sub The workbook is also attached having the same

$$Excel-Macros$$ Re: Fwd: VBA help needed

2009-05-20 Thread Sergio Abadesso
Hello Harmeet, I think I have a solution for your problem. see attached file. Regards, Sergio 2009/5/18 Harmeet Singh > > > -- Forwarded message -- > From: Nihar Turakhia > Date: Mon, May 18, 2009 at 12:47 AM > Subject: VBA help needed > To: harmeet.hew...@gmail.com > > > H

$$Excel-Macros$$ Re: Fwd: Help required

2009-05-20 Thread amrahs k
Hi Dave and Team, Thanks for the help provided. I have done this successfully with out any issues. once again thank you all for your valuable and swift response as well. Regards, Sharma On Wed, May 13, 2009 at 10:50 PM, Fabio Lemos wrote: > Hi, > It's possible to use Validation, but it need t

$$Excel-Macros$$ Re: Fwd: Excel Bible 2007, Shortcuts, Functions & More..!

2009-05-15 Thread Manoj S Negi
*Thanks a ton buddy. Its very nice think to share the knowledge with others Cheers.keep this think continue * *Unfeigned Regards Manoj S Negi "Miles & miles to go before I sleep"* *¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`

$$Excel-Macros$$ Re: Fwd: Help required

2009-05-13 Thread Dave Bonallack
pe this helps. Regards - Dave Date: Wed, 13 May 2009 16:50:11 +0530 Subject: $$Excel-Macros$$ Re: Fwd: Help required From: amrahs...@gmail.com To: harmeet.hew...@gmail.com CC: excel-macros@googlegroups.com Hi Harmeet, Please find the attached sample workbook that contains a simple query for m

$$Excel-Macros$$ Re: Fwd: Help required

2009-05-13 Thread amrahs k
Hi Harmeet, I have attached one sample workbook that contains a query for data validation. I just need a macro for the same. Thanks for your help. Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote: > Hi, > > Please see attached file. > > On Wed, May 6, 2009 at 5:53 PM, am

$$Excel-Macros$$ Re: Fwd: Help required

2009-05-13 Thread amrahs k
Hi Harmeet, Please find the attached sample workbook that contains a simple query for my project. Thanx in advance. Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote: > Hi, > > Please see attached file. > > On Wed, May 6, 2009 at 5:53 PM, amrahs k wrote: > >> Hi Team, >>

$$Excel-Macros$$ Re: Fwd: Help required

2009-05-06 Thread amrahs k
Thank you very much Harmeet! Just curious to know whether we can done it through VBA coding? because i suppose to apply this formula in all the checklists its around 50 workbooks. Any ways thanks for your swift response! Regards, Sharma On Wed, May 6, 2009 at 10:58 PM, Harmeet Singh wrote: > Hi

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-13 Thread harish pandey
gards, Harish Pandey, Manager Operations Religare --- On Mon, 13/4/09, Harmeet Singh wrote: From: Harmeet Singh Subject: $$Excel-Macros$$ Re: Fwd: mACRO HELP To: excel-macros@googlegroups.com Cc: jayendra.gau...@gmail.com Date: Monday, 13 April, 2009, 9:49 PM Hi Jayendra,   Finally, your reques

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-13 Thread amit thakkar
Hi I have a client data base system which works through internet. There are some fields in this data base where I have to update same information in same fields for different deals. I have heard of Macros that record Key Stroked. Can some one give me a link to a freeware which will help me. Regar

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-13 Thread jayendra gaurav
> Dear All, > > Can you please help me write a macro to simplify finding the packing list. > The required files are attached for your reference. The tedious job that we > do is as under: > > >- Fin`ding the container number PONU7259344 from the daily vehicle >entry file an excel file >-

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-09 Thread jayendra gaurav
Dear Ashis , U helps to all member ,pls help me also.Mateer is most urgent > > > >> Dear All, >> >> Can you please help me write a macro to simplify finding the packing list. >> The required files are attached for your reference. The tedious job that we >> do is as under: >> >> >>- Fin`ding

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

2009-04-09 Thread Dave
Change the units displayed on the value axis If your chart values consist of large numbers, you can make the axis text shorter and more readable by changing the display unit of the axis. For example, if the chart values range from 1,000,000 to 50,000,000, you can display the numbers as 1 to 50 on

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

2009-04-09 Thread Kuldeep Vashishtha
Use formula as =Cell no / 1000 _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prashanth Banneni Sent: Thursday, April 09, 2009 12:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

2009-04-09 Thread AngeloUCF
Right click the axis > format axis Then select the Number tab and select the Custom category. In the format code, type in "$###K" Then select the axis options tab and select the display units as "Thousands" This should be what you are looking for. Angelo --~--~-~--~~~--

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph...done

2009-04-09 Thread Bakul Patel
Hi Prashant,   Go to FORMAT CELL>Custom> _($#,k   this will solve your problem...   Cheers, Bakul   --- On Thu, 4/9/09, Prashanth Banneni wrote: From: Prashanth Banneni Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph To: excel-macros@googlegroups.com Date: Thursday, April

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph

2009-04-09 Thread Prashanth Banneni
Hi Lavprasad, You are awesome. Thanks a million. Prashanth On Thu, Apr 9, 2009 at 4:38 PM, Lavprasad Kori wrote: > > Hi Dear, > > Attached herewith the file of soluiton. > > Regards, > > Lavprasad > > > > On Thu, Apr 9, 2009 at 12:54 PM, Prashanth Banneni wrote: > >> Hi All, >> >> Any help on

$$Excel-Macros$$ Re: Fwd: Can you break password of attached sheet also let me solution.

2009-04-09 Thread Marcin
You can open it via OpenOffice Calc and then no password is needed. Regards, Marcin On Apr 7, 11:39 am, "prabhat.shrivasta...@gmail.com" wrote: > how u unprotected this file??? > > Wot is the mathod to unprotect a file > On Apr 6, 6:35 pm, "Mudassar Ramzan" wrote: > > > Please find unprotected

$$Excel-Macros$$ Re: Fwd: mACRO HELP

2009-04-08 Thread jayendra gaurav
Still I am waiting ..Pls Help me in this regards.matter is most urgent. > Dear All, > > Can you please help me write a macro to simplify finding the packing list. > The required files are attached for your reference. The tedious job that we > do is as under: > > >- Fin`ding the co

$$Excel-Macros$$ Re: Fwd: Can you break password of attached sheet also let me solution.

2009-04-07 Thread Mudassar Ramzan
From: To: "MS EXCEL AND VBA MACROS" Sent: Tuesday, April 07, 2009 2:39 PM Subject: $$Excel-Macros$$ Re: Fwd: Can you break password of attached sheet also let me solution. how u unprotected this file??? Wot is the mathod to unprotect a file On Apr 6, 6:35 pm, "Mudassar Ramzan&quo

$$Excel-Macros$$ Re: Fwd: Can you break password of attached sheet also let me solution.

2009-04-07 Thread prabhat.shrivasta...@gmail.com
how u unprotected this file??? Wot is the mathod to unprotect a file On Apr 6, 6:35 pm, "Mudassar Ramzan" wrote: > Please find unprotected file and VBA password is 12345. > > Thanks & regards, > > || Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | > 0321 7325277 || > >

$$Excel-Macros$$ Re: Fwd: Please let me know the answer to your sample querry. !!!its urgent!!!

2009-04-02 Thread zheng yu
Hi Shay, you can copy this and paste in your workbook_open() event. This should meet what you want Private Sub Workbook_Open() Dim RemindTime As Integer Dim B As Boolean Dim C As Boolean RemindTime = 5'set to whatever days y

$$Excel-Macros$$ Re: Fwd: Creating Expiry Date for Macro or VB Script

2009-03-09 Thread sarfaraz ahmed
Hello, You try putting declare dtexpire as date let dtexpire = 'your macro expiry date' if dtexpire < = date then your macro code here else msgbox "macro date expired contact developer" endif Regards, Sarfaraz Ahmed http://findsarfaraz.blogspot.com On Sun, Mar 8, 2009 at 10:10 AM, Ai

$$Excel-Macros$$ Re: Fwd: Creating Expiry Date for Macro or VB Script

2009-03-07 Thread Aindril De
Hi Mahesh, Please go through the following link. This should take care of your problem: http://www.vbaexpress.com/kb/getarticle.php?kb_id=475 Regards, Aindril On Sun, Mar 8, 2009 at 7:50 AM, Ashish Jain <26may.1...@gmail.com> wrote: > > > -- Forwarded message -- > From: mahesh p

$$Excel-Macros$$ Re: Fwd: read dis

2008-12-25 Thread Akhilesh Karna
Let us not forward hoaxes. We can easily find whether a message is hoax. Please refer below: http://www.hoax-slayer.com/nirosha-silva-hoax.shtml --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to t

Re: Fw: $$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-30 Thread sarfaraz ahmed
to say, there are things that we know we don't know. >> But there are also unknown unknowns. There are things we don't know we don't >> know." >> >> --- On *Thu, 27/11/08, [EMAIL PROTECTED] < >> [EMAIL PROTECTED]>* wrote: >> >> From:

Re: Fw: $$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-30 Thread Sunita Paudel
ings that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > --- On *Thu, 27/11/08, [EMAIL PROTECTED] < > [EMAIL PROTECTED]>* wrote: > > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> &g

Re: Fw: $$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-27 Thread Alokeshwar Tiwary
there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." --- On Thu, 27/11/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Subject: Fw: $$Excel-Macros$

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-26 Thread Naga
rom:* Naga <[EMAIL PROTECTED]> > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, 25 November, 2008 11:30:41 AM > *Subject:* $$Excel-Macros$$ Re: Fwd: Abt macro > > Hi all, > > Should we all request the group owner to remove Sharad Sharma from the > group ID. >

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-26 Thread Sarfraz Abbasi
Offers like this some one else's daughter, sister, mothers and wives are easy, but prior to give any such offer to any one, we should just think it once, if the same offer is given to our females (at home), what would be our possible reaction. West way to think have made us broader nation but no

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-26 Thread odd_to_a_skylark-spell
of this scrap.  From: Naga <[EMAIL PROTECTED]> To: excel-macros@googlegroups.com Sent: Tuesday, 25 November, 2008 11:30:41 AM Subject: $$Excel-Macros$$ Re: Fwd: Abt macro Hi all, Should we all request the group owner to remove Sharad Sharma from the group ID. This is disgusting to have s

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-25 Thread Sunita Paudel
yeah Naga,bhanu nd alam u r right . grp owner shud pay attention on this... we r here to learn nt to fool othr n humiliate... i hope Mr Ayush Jain will do needful... On 11/25/08, Naga <[EMAIL PROTECTED]> wrote: > > Hi all, > > Should we all request the group owner to remove Sharad

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-25 Thread Me_The_Story_Teller
*Dear Mr Sharad You are requested to maintain the decorum and not have such sarcastic thinking. This forums are used to help lot of people professionally and it kind of strange you using it other way around. Please @least Be Sorry For It !! Have some respect for the person. I hope you would not

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-25 Thread Naga
Hi all, Should we all request the group owner to remove Sharad Sharma from the group ID. This is disgusting to have such ppl in the group. Regards..Naga On Tue, Nov 25, 2008 at 10:15 AM, Sunita Paudel <[EMAIL PROTECTED]> wrote: > m shocked this type of ppl also here in this group !! > > > > --

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-25 Thread bhanu prakash
Hello Sharad, Wat's wrong with you.. This is very popular group..!! and really shock that this kind of people in this..?? *Group Moderator - Request you to please do some action on this kind of activities pls..thanks* Cheers. Regards, Bhanu On Tue, Nov 25, 2008 at 10:15 AM, S

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-25 Thread monaweer alam
Really it's wondering Amazing. On 11/25/08, Sunita Paudel <[EMAIL PROTECTED]> wrote: > > m shocked this type of ppl also here in this group !! > > > > -- Forwarded message -- > From: Sunita Paudel <[EMAIL PROTECTED]> > Date: Nov 18, 2008 9:20 AM > Subject: Re: Abt macro > To: Sha