$$Excel-Macros$$ Access Problem

2011-05-08 Thread Yogesh Gohil
Hi Guys, Some time when i want to import any data in Access then i get an error "* is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.*" can Any one suggest me how to remove this error. Thanks Yo

Re: $$Excel-Macros$$ Fwd: Plz help me

2011-04-29 Thread Yogesh Gohil
Check this might be it help On Fri, Apr 29, 2011 at 9:45 AM, sanjay maurya wrote: > > All Friends > > I have some solution. I have problem to create the report look in attached > Excel Sheet. > > -- > ***Thanks & Best Regards** > Sanjay Kumar Maurya* > > * > Life is Very beautiful !!! > * > * >

$$Excel-Macros$$ Please Complete this Calculator

2011-04-26 Thread Yogesh Gohil
Hi All, -- -- 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 @ http://www.linkedin.com/groups?gid=1871310 3. Exce

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

2011-04-26 Thread Yogesh Gohil
Sorry Renuka, Not TRIM use Clean Formula. =Clean(A1) TRIM formula use to clean unnecessary space from the text. On Tue, Apr 26, 2011 at 11:12 AM, renuka chari wrote: > thanks to all here i am attaching one sheet here how to remove this > kind of special characters help me plz > > -- > > -

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

2011-04-26 Thread Yogesh Gohil
Hi Renuka, You can use TRIM formula. Like =TRIM(A1) Thanks and Regards Yogesh Gohil On Tue, Apr 26, 2011 at 11:12 AM, renuka chari wrote: > thanks to all here i am attaching one sheet here how to remove this > kind of special characters help

Re: $$Excel-Macros$$ Help me in this

2011-04-24 Thread Yogesh Gohil
nt to update all > sheets on daily basis. If i'll do this, it also be take same time. If you > have any other idea please share with me. I am also working on it if i will > get any solution then i will tell you. > > Thanks & Regards > Yogesh Gohil > > On Sat, Apr

Re: $$Excel-Macros$$ Help me in this

2011-04-24 Thread Yogesh Gohil
Thanks Dave, for your suggestion. but problem is that i want to update all sheets on daily basis. If i'll do this, it also be take same time. If you have any other idea please share with me. I am also working on it if i will get any solution then i will tell you. Thanks & Regards Yogesh

$$Excel-Macros$$ Help me in this

2011-04-23 Thread Yogesh Gohil
Hi Experts, Actually, this waterfall made by me but its take 3hour to complete. Please help me out to make easy and time reducer format. This format have Excel function and VBA coding. *For the attachment you can click on* http://www.megaupload.com/?d=8KTIVGZX Thanks & Regards Yogesh G

Re: $$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

2011-04-18 Thread Yogesh Gohil
Thanx Ansul, This code really works. Regards Yogesh Gohil On Sun, Apr 17, 2011 at 11:13 AM, ashish koul wrote: > try this > > Sub method2() > Dim i, j, k, s As Long > s = Sheets.Count > Sheets.Add After:=Sheets(Sheets.Count) > For i = 1 To s > Sheets(i).Select > &#x

$$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

2011-04-16 Thread Yogesh Gohil
Hi Experts, Please provide me the solution for this. Regards Gohil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Linked

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

2011-04-15 Thread Yogesh Gohil
by Text to Column you change its format. Short Key is ALT+D+E Select *Delimited -> Click Next -> Click Next -> Select Date Format (DMY) -> Click Finish* On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor wrote: > Dear all, > > Would like to seek your kind assistance/help on the date f

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-15 Thread Yogesh Gohil
Like this??? On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi, > > I want to create one pivot table. In this, *I want to calculate the number > of employees in Poor, Avg, good, and very good.* > But it is showing the same no. of employees in each catego