Re: $$Excel-Macros$$ LIFE TIME DIARY

2010-09-13 Thread P.VIJAYKUMAR
Hello, You can also find a wide variety of useful templates in the New section of Excel ribbons button in Excel 2007. Regards, Vijaykumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tip

Re: $$Excel-Macros$$ LIFE TIME DIARY

2010-09-13 Thread Harpreet Singh Gujral
This looks like an amasing piece of work Harpreet Gujral -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

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

2010-09-13 Thread hemant shah
Hi Team, Please help on the attached. Thanks in advance. Regards, Hemant Shah -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Jo

Re: $$Excel-Macros$$ PLEASE UNPROTECT THE SHEET OF ATTACHED FILE

2010-09-13 Thread Syed Asad Ahmed Naqvi
Please guide about the process --- On Mon, 9/13/10, N.Shivkumar wrote: From: N.Shivkumar Subject: Re: $$Excel-Macros$$ PLEASE UNPROTECT THE SHEET OF ATTACHED FILE To: excel-macros@googlegroups.com Date: Monday, September 13, 2010, 7:10 PM Kindly have a look I have unprotected the sheets. N.SH

$$Excel-Macros$$ Retable a table

2010-09-13 Thread Drayton, Michael E
Hi Team: So Attached I have a small table, I need to create columns where the headers appear next to the data. Can anyone assist, please? Pivot tables don't work because they don't refresh correctly when utilizing macros. Thanks Michael -- ---

Re: $$Excel-Macros$$ Formula for Last Leave Date

2010-09-13 Thread ashish koul
can you please attach excel file On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote: > Dear Sirs, > > I want to capture data which employees are on leave as on date and > since when ? > Formula please….. > > (Format enclosed) > > NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave

Re: $$Excel-Macros$$ Entering Data in Excel

2010-09-13 Thread Deepak Gupta
take format cell as number On Sat, Sep 11, 2010 at 5:39 PM, viju mobile wrote: > Hi All, > I am trying to input 20 digit number in a column. But it does not > enter it correctly. > Please guide me. > Regards, > Vijay > > -- > >

RE: $$Excel-Macros$$ APPLICATION SHEET

2010-09-13 Thread عمر
=IFERROR(VLOOKUP(D2;A1048560:B1048563;2;0);"") From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ALAM Sent: Monday, September 13, 2010 3:24 PM To: excel-macros@googlegroups.com; toexcel-mac...@googlegroups.com Cc: noorain.ans...@gmail.com Subject: $$Excel-M

Re: $$Excel-Macros$$ PLEASE UNPROTECT THE SHEET OF ATTACHED FILE

2010-09-13 Thread roberto mensa
look this link: https://sites.google.com/site/e90e50/vba/rimuoverepasswordexcel regards r 2010/9/13 vikas gupta > Dear All > > I have a protected excel file can any one unprotect it > > regards > vikas > > -- > >

Re: $$Excel-Macros$$ LIFE TIME DIARY

2010-09-13 Thread Maries
Pls. check ur mail... i forwarded. On Mon, Sep 13, 2010 at 4:32 PM, Shimmy wrote: > Maries or any of teh EXCEL group friends, could you please email me > that 100 years diary document on my e-mail morur...@gmail.com, I > cannot manage to download or open the file by following the link. > Please

RE: $$Excel-Macros$$ Entering Data in Excel

2010-09-13 Thread Dave Bonallack
Hi, 20 digits is too much for XL, which I think only handles 16 digits accurately. If you really need accuracy to that degree, you'll have to go elsewhere, or start splitting the number over 2 cells, which makes the maths quite complex. If you Google "Big numbers in Excel" you'll see lots of q

Re: $$Excel-Macros$$ LIFE TIME DIARY

2010-09-13 Thread Shimmy
Maries or any of teh EXCEL group friends, could you please email me that 100 years diary document on my e-mail morur...@gmail.com, I cannot manage to download or open the file by following the link. Please guys, I beg, I beg, I beg, I beg and I BEG! I AM LOOKING FORWARD TO YOUR RESPONSE. Regards

Re: FW: $$Excel-Macros$$ Entering Data in Excel

2010-09-13 Thread viju mobile
You all might have see that even when i format the cell/column as number, it dont show me the exact number i do enter there. Vijay On Mon, Sep 13, 2010 at 11:35 AM, SUMIT VYAS wrote: > Dear, > > Right Click Cell > Format > Number Tab > Select Number > decimal place is 0 > > ok > > Regards > > Sum

RE: $$Excel-Macros$$ create a mcro in xls that launches other macros

2010-09-13 Thread Dave Bonallack
Hi, Yes, you can use Call eg: Sub Run5Macros() Call Macro1Name Call Macro2Name Call Macro3Name Call Macro4Name Call Macro5Name End Sub Regards - Dave. > Date: Mon, 13 Sep 2010 01:02:15 -0700 > Subject: $$Excel-Macros$$ create a mcro in xls that launches o

$$Excel-Macros$$ create a mcro in xls that launches other macros

2010-09-13 Thread fede
hi all, is it possible to create a macro that launches others 5 macros? someone can help me? many thanks. Fede -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://tw

$$Excel-Macros$$ Explain about list box properties

2010-09-13 Thread neil johnson
Hi Everyone, Can Someone Explain about Listbox properties in VBA. . When I use listbox in user form . and list box properties. there is *COLUMN COUNT* . *Why we user -1 in Column Count?* Please explain the properties of LIST BOX except this question. Thanks and Regards -- --

Re: Fwd: $$Excel-Macros$$ How to copy the list of autofilter selection?

2010-09-13 Thread neil johnson
Hi , Your Welcome. If you need any help ,I will try to solve it. On Mon, Sep 13, 2010 at 8:26 AM, Meimei wrote: > Thanks to both Neil and Paul. The VBA file Neil posted is similar to > what I need, except I would need the result in a sorted order, that is > why I was thinking whether I can dire

$$Excel-Macros$$ Formula for Last Leave Date

2010-09-13 Thread Nalini
Dear Sirs, I want to capture data which employees are on leave as on date and since when ? Formula please….. (Format enclosed) NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave Since A AB AB AB AB AB AB AB 01-Sep B pr pr

$$Excel-Macros$$ Re: User text boxes in word

2010-09-13 Thread Kishan Reddy, K
Right click the Text Box, Select properties. set the EnterKeyBehavior Property to true and set the multiline property to true. That's it. Bye Regards, Kishan Reddy, K On Sep 12, 8:09 pm, Johnnyboy5 wrote: > How do I get the text box to line feed on pressing enter instead of > the enter key ju

Re: FW: $$Excel-Macros$$ Entering Data in Excel

2010-09-13 Thread SUMIT VYAS
Dear, Right Click Cell Format Number Tab Select Number decimal place is 0 ok Regards Sumit Vyas +919755549483 On Sat, Sep 11, 2010 at 8:00 PM, Saurabh Patel < saurabh.pa...@in.aegisglobal.com> wrote: > Change the cell format to "Number" by right clicking on cell. > > Regards, > Saurabh Pate

Re: Fwd: $$Excel-Macros$$ How to copy the list of autofilter selection?

2010-09-13 Thread P.VIJAYKUMAR
Hello, You can select the Auto filter results only but before copying you must choose the option of Select visible cells only (ALT+;) then chose copy and paste the result wherever you require it.Without using the option of select Visible cells every result will be copies as if there is no auto fi

Re: $$Excel-Macros$$ Excel 97 - Windows 7

2010-09-13 Thread C.G.Kumar
Dear, You need not to worry. If you have Office 97 CD, you just install it on your PC (in case Office 2003/2007 is not provided by the vendor).Office 97 will work of Windows 7. In addition , if you install office 2007 then also you will be able to work with office 97 file created earlier. Regards