Re: $$Excel-Macros$$ Cell Formating

2010-02-26 Thread VIRAL PANDYA
hit "CTRL + SHIFT + ~"KEY... Regards, Viral Pandya On Fri, Feb 26, 2010 at 2:53 PM, ankur wrote: > format the cells of whole sheet in general format... > > > if still problem > check this link > http://www.brighthub.com/computing/windows-platform/articles/2

Re: $$Excel-Macros$$ Need to grab a word from a string

2010-02-24 Thread VIRAL PANDYA
Say Cell A1 is 12 Roosevelt Ave =VALUE(LEFT(A1,FIND(" ",A1,1))) Regards, Viral Pandya On Thu, Feb 25, 2010 at 8:23 AM, Mike wrote: > Hi folks, > Looking for a function(if it exists) that will grab the first letter > in a string and put it in another cell. For example: &g

$$Excel-Macros$$ URGENT HELP REQUIRED

2009-08-30 Thread VIRAL PANDYA
Dear Excel Champs..., Please help me out, I want to password for an XLA (add-ins) file. Is there any way to know the coding of an XLA file??? awaiting reply. Viral Pandy --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: i Challenge that who ever does it, is genious in excel

2009-02-20 Thread VIRAL PANDYA
Dear All, Just FYI. this question is closed. How ever we shud start a tredition that as soon as some1's query resolved, he/she shud reply with a thanking note to the person who so ever have solved that query... Hope member will agree and start practice. Regards, Viral Pandya On Thu, F

$$Excel-Macros$$ Re: How to filter "," from data in cell.

2009-02-13 Thread VIRAL PANDYA
i have already send file with result wht required. Regards, Viral Pandya On Thu, Feb 12, 2009 at 7:37 AM, SHAH DARSHIL wrote: > Can any one help on below attached file. > > > can help me for attached file . i want to retain the "." in data . > i try with your so

$$Excel-Macros$$ Need Help

2009-02-08 Thread VIRAL PANDYA
How can i open Password protected XLA file? Regards, Viral Pandya --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit

$$Excel-Macros$$ Re: How to filter "," from data in cell.

2009-02-05 Thread VIRAL PANDYA
find the attached file. Regards, Viral Pandya On Thu, Feb 5, 2009 at 12:41 AM, Sachin N Harale wrote: > Dear friends, > > Please help me out in filtering the "," (comma) out from the data which is > comma separated. Further I want to retain the "." (dot) in d

$$Excel-Macros$$ Re: please help me with count function !!!URGENT!!!

2009-02-04 Thread VIRAL PANDYA
find attached file Regards, v...@l p...@ndya On Wed, Feb 4, 2009 at 3:05 PM, shay shay wrote: > > please help me with count function > -- > Shay > > A Thinker tends to use reason and logic > > A feeler tends to use values and subjective Judgement. > > Be a Thinker in Life. > > > > --~--~--

$$Excel-Macros$$ Re: Help-Excel files formula

2009-02-04 Thread VIRAL PANDYA
Please find attached file. Regards, Viral Pandya +91-992-432-1990 On Tue, Feb 3, 2009 at 8:09 PM, Rabindra Thapa wrote: > > Please help me on attach files. > -- > > Regards, > Rabindra Thapa > ¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep

$$Excel-Macros$$ Re: Selective copy of non bank cell

2009-02-02 Thread VIRAL PANDYA
No need to wrote macro select column, press F5 select special select constants hit enter... that's it Regards, Viral Pandya On Sun, Feb 1, 2009 at 9:08 PM, Debasish Sahu wrote: > Hi I hv a xl sheet whre i want to copy one of the column which contains > both blank

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

2009-02-01 Thread VIRAL PANDYA
ALT + E + I + S On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar wrote: > > > The fill handle is very helpful for filling cells with various values. > However, I much prefer to use the keyboard in preference to the mouse. Is it > possible to utilize the fill handle in some way only by using the keyboa

$$Excel-Macros$$ Calculate invoice about to due in a week...

2009-01-23 Thread VIRAL PANDYA
Dear All, Please find attached file. My problem is self explanatory if you see the file. Thanks in an advance. Regards, Viral Pandya --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group

$$Excel-Macros$$ Re: How to unhide the sheet

2009-01-21 Thread VIRAL PANDYA
Office that's the ultimate solution for your problem. Regards, Viral Pandya On 1/21/09, vinu wrote: > > > Yes I have tried.. its not working.. > > > On Jan 21, 10:51 am, Naveen wrote: > > Hi, > > Have u tried this one.? > > > > >

$$Excel-Macros$$ Re: Create a file that linked with excel sheet

2009-01-20 Thread VIRAL PANDYA
Plz plz plz help me out. On 1/18/09, VIRAL PANDYA wrote: > > Dear All, > > I have a excel sheet contains 128 Sheets and daily i have to take print out > only for 5 Sheet (record sheets). > > Is there any way by which i can create a linked excel file for only this 5

$$Excel-Macros$$ Create a file that linked with excel sheet

2009-01-18 Thread VIRAL PANDYA
Dear All, I have a excel sheet contains 128 Sheets and daily i have to take print out only for 5 Sheet (record sheets). Is there any way by which i can create a linked excel file for only this 5 sheets? Please help. Regards, Viral Pandya

$$Excel-Macros$$ Re: Excel to PPT

2009-01-06 Thread VIRAL PANDYA
& 12. Look forward to hear from you soon. Regards, Viral Pandya On 1/6/09, Tom Jeffries wrote: > > This may help > > To create a link from PowerPoint to the info in your Excel file. > > 1. If you're working with content on a worksheet rather than on a > char

$$Excel-Macros$$ Excel to PPT

2009-01-06 Thread VIRAL PANDYA
have 24 slides in our MPR presentation. I workout date in excel and copy the same and paste in Power point as EXCEL OBJECT. now i and sheet 1 (say Sales Varience to paste on slide no 2). Sheet 2 (say receivables date to paste on slide no 3). Look forward to hear from you soo. Regards, Viral

$$Excel-Macros$$ Re: request to hlp me on the attached file query

2008-12-31 Thread VIRAL PANDYA
HI DEAR, I THINK THIS WILL BE EASILY SOLVED WITH USE OF PIVOT TABLE. WHAT U SAY REGARDS, VIR On 12/29/08, Tom Jeffries wrote: > > The attached workbook (GetJobs) shows a way to get the data you want. Use > the Worksheet_Change event to launch a subroutine to retrieve the desired > inform

$$Excel-Macros$$ Re: How to calculate Hours and miutes between two dates.

2008-12-24 Thread VIRAL PANDYA
C1 = B1-A1 this will show u result like this 03-01-1900 7:35:00 AM now go to format cell go to time on Number Tab select 37:30:55 this will show u ans as *79:35:00* ** *any query mail me... or call me +919924321990* ** enjoy... Regards, Viral Pandya I am not programmer, I am just an end-user