Re: $$Excel-Macros$$ Vlookup value with comments

2013-05-18 Thread David Grugeon
Excel can do it but unfortunately the restriction not to use VBA prevents it. Perhaps you should talk to your IT department and ask them how to solve it. Regards David Grugeon On 19 May 2013 07:02, santosh subudhi wrote: > Hi Group, > > Attached is the sample sheet where in the comments part

RE: $$Excel-Macros$$ Vlookup value with comments

2013-05-18 Thread santosh subudhi
Hi Group, Attached is the sample sheet where in the comments part have been taken place by cell colour. I cannot use VBA due to some internal IT restrictions. If the cell colour can be picked by vlookup it will be of much helpful. -- Regards Santosh santoshkumar.subu...@gmail.com Date: Wed, 15

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

2013-05-18 Thread P.VIJAYKUMAR
Respected Prabhu, It think the file didn't get attached.Please find them, On Fri, May 17, 2013 at 7:15 PM, Prabhu Pinky wrote: > Dear Vijaykumar, > > which file u refer to..? i dont find any attachment. > > > > On 17 May 2013 10:02, P.VIJAYKUMAR wrote: > >> Respected Prabhu, >> >> Hope this fi

$$Excel-Macros$$ Re: Macros Tips

2013-05-18 Thread bpascal123
A few things about Vba for Excel on my website... lots of work left to (btw i'm looking for partners...) http://multiskillz.tekcities.com/k2500_0vbaMenu.html regards Pascal -- 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 Faceb

$$Excel-Macros$$ Re: VBA for Dynamic Range

2013-05-18 Thread bpascal123
why Sht = "'" & ActiveSheet.Name & "'" ? Sht = ActiveSheet.Name should be fine -- 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 of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise

$$Excel-Macros$$ Copy Data from Sheet to Sheet based on both columns in Excel

2013-05-18 Thread sreenivas kammari
Hi all, I'm very much confused how to post and where to post my questions?...I need a small help but its very urgent... I need a macro for the below mentioned problem. Say for example: I have a column A and B in a sheet. In column A say I have 1,2,3,4,5, and in column B say I have A.b.

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-18 Thread priti verma
can u please send your file in which you are facing this problem. ig a1= a,b,c,d,e,fi use above formula only i got answer a b c de , can u explain what i am doing mistake pls On Wed, May 15, 2013 at 12:45 PM, jmothilal wrote: > ig a1= a,b,c,d,e,fi

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-18 Thread Waseem Saifi
you can do it with text to columns command. using delimited option in text to columns command. and check comma box then finish. do you want to do it with formula? On Mon, May 13, 2013 at 8:24 PM, jmothilal wrote: > Dear any one > > i want split address column wise based on comma > > file attach

$$Excel-Macros$$ Data Validation and Automation

2013-05-18 Thread Eugene Bernard
Dear all, Please go through the sheet attached, where there are 4 columns. Column 1 is ID which is used to differentiate the component or item. Column 2 is Stage, which is used to designate where the component / item is being processed (ie) stage 1 or 2. Column 3 is completion quantity of compo

Re: $$Excel-Macros$$ Macros Tips

2013-05-18 Thread Shrinivas Shevde
Dear Abhishek Its really helpful (site and the draft) You said it rightly here are many Excel master who are ready to help for all your problem and as per my experience you will get more than one solutiion for any problem Once again thanks for site and draft Dear Chhaya I am not expert in Macro but