Re: $$Excel-Macros$$ Re: concatenate in one cell

2017-12-27 Thread N.Shivkumar
see attached solution On 25 December 2017 at 14:35, Aamir Shahzad wrote: > this is manual formula & need select cells one by one I want to use entire > range e.g. A1:HL1 > > On Mon, Dec 25, 2017 at 4:40 AM, who wrote: > >> =trim(C4)&trim(D4)&trim(E4)&trim(F4)&trim(G4) >> >> Try the abo

Fwd: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2017-09-18 Thread N.Shivkumar
Dear Mr. Prabhu Please add me in WHATAPP GROUP M: 9422613567 -- 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, accurate thread titles

$$Excel-Macros$$ Fwd: HIDE AND UNHIDE

2017-09-18 Thread N.Shivkumar
​SEE THIS SOLUTION FOR HIDE UNHIDE​ ​​ -- 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, accurate thread titles. Poor thread titles, l

Re: $$Excel-Macros$$ VBA password protected

2016-03-05 Thread N.Shivkumar
​Send me the file​ On 5 March 2016 at 19:48, wrote: > Hi all, > > I have an excel file which has multiple macros built. When I try to access > the VBA, it gives a pop-up to enter the password. The macros have been > written by predecessor and my boss wants me to decode this. > > Since i

$$Excel-Macros$$ Repair excel file

2015-02-02 Thread N.Shivkumar
Dear friends Can somebody help in recovering the attached file please. Thanking you in anticipation of a quick reply N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ quick help

2014-07-13 Thread N.Shivkumar
see attached file unlocked. don't tell anybody in the group OK all the best​ N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 13 July 2014 12:04, daya p wrote: > sir, > my request prob not done by group members > is a

Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar
Exactly and thanks for your reply ​ N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 16 June 2014 11:54, Ravinder wrote: > PFA, if you are looking for this. > > > > *From:* excel-macros@googlegroups.com [mailto:

Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar
Dear Vaibhavji If the achievement is > 100% it should green arrow up, if it is less than 90% it should show red arrow down and if between 90 and 100 it should show straight arrow.​ N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On

$$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar
Dear friends Can anybody throw some light and help me as to where I am going wrong in conditional formatting! N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread N.Shivkumar
Thanks Sir. It is a live example. I used the delimiters and got the answer. I was looking for a macro If I can get a better result :) N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 3 June 2014 18:53, Paul Schreiner wrote: >

Re: $$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread N.Shivkumar
Dear Sir I would prefer a macro as importing text file all the data comes in one cell only Your help is solicitated. N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 3 June 2014 16:55, Paul Schreiner wrote: > Are you wantin

$$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread N.Shivkumar
Dear friends I am enclosing a txt file generated out of Cobol package. Can anybody help in out to convert the same into excel. Thanking you in anticipation of a favourable response N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com -- Are you

Re: $$Excel-Macros$$ How to include new Rs font in Excel Currency format (option in format cell)

2011-04-30 Thread N.Shivkumar
After downloading the font as our friends have suggested the cell can be formated as under : [>999]"` "##\,##\,##\,##0.00;[>9]"` "##\,##\,##0.00;`##,##0.00 Bye N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo

$$Excel-Macros$$ Help required in average if - Excell 2003

2011-04-30 Thread N.Shivkumar
It is easy in exel2007. Kindly show how the same is to be worked in excel 2003 Thanx in advance N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com *Please consider the environment before printing this email

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

2011-03-02 Thread N.Shivkumar
Great contributions by Ashish. Keep up the good work. We need your help N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com *Please consider the environment before printing this email.* On 2 March 2011 17:36, DILIPandey wrote: > Congrats Ash

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

2011-01-03 Thread N.Shivkumar
Congrats Dilip on your achievement Keep the good work moving N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com *Please consider the environment before printing this email.* On 3 January 2011 15:31, Ayush wrote: > Dear Group, > > I am

Re: $$Excel-Macros$$ password

2010-09-23 Thread N.Shivkumar
Send the file i will do it for you N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 23 September 2010 04:40, Skanda wrote: > Hi All, > How to unlock a password that is set for an exce

Re: $$Excel-Macros$$ old file can't open

2010-09-15 Thread N.Shivkumar
send the file to me N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 14 September 2010 22:56, Robert wrote: > I created a file with a VB macro long time ago for the final at the > college and now i can't figure out what are the

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

2010-09-09 Thread N.Shivkumar
e is a mentor to me on a number of soulutions that he has posted N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 9 September 2010 11:11, Kal xcel wrote: > Dear Dilip, > > I can't see the codes. How shal I get codes. Please h

Re: $$Excel-Macros$$ Rupee symbol on PC

2010-09-08 Thread N.Shivkumar
Thanx a lot I would like to know how to have the new symbol in the below mentioned format : [>999]"Rs. "##\,##\,##\,##0.00;[>9]"Rs. "##\,##\,##0.00;Rs.##,##0.00 N.SHIVKUMAR -- -

Re: $$Excel-Macros$$ File Password for Excel

2010-07-31 Thread N.Shivkumar
Dear Kamlesh Jain Is it possible to send me the file I will find the passwod BYe N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 31 July 2010 21:08, Vikas Chouhan wrote: > yes > > On Sat, Jul 31, 2010 at 7:24 PM, kamlesh ja

Re: $$Excel-Macros$$ SumIF Sumproduct

2010-07-02 Thread N.Shivkumar
Hi Can you send me the file so that I can give a solution. Bye N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ how can protect the excel sheet in VBA Passward.

2010-04-27 Thread N.Shivkumar
en Sheet2.Unprotect "1823" Else MsgBox " Incorrect Password" Worksheets(1).Activate End If End Sub N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com On 8 April 2010 13:56, rf1234 rf1234 wrote:

Re: $$Excel-Macros$$ URGENT :Sumif Query

2010-02-11 Thread N.Shivkumar
Dear Sir Kindly see the attached sheet for the query you raised. I am not sure whether this what you were looking for. I may have used the longer route. Kindly enlighten me. With regards Bye N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1

$$Excel-Macros$$ Re: PDF password CRACKER

2009-10-07 Thread N.Shivkumar
Is it possible for you to send me the file I will crack the same and return back to you Bye N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: PDF password CRACKER

2009-10-01 Thread N.Shivkumar
Kindly send me the file I will send the password & the file N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo

$$Excel-Macros$$ Re: Forgotten Password

2009-09-28 Thread N.Shivkumar
Dear Ramkrishna Serial to register passware-kit-enterprise is : FPVYK-EVHVF-WR7H4-H4EXE-ZAJB5U N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: Forgotten Password

2009-09-24 Thread N.Shivkumar
Thanx it now working fine Bye N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: Forgotten Password

2009-09-24 Thread N.Shivkumar
Sir the link ( http://hotfile.com/dl/9555021/35152c2/passware.kit.enterprise.9.3.full_gavn.rar.html is incorrect kindly send me the correct link or the file itself Thanks Bye Bye N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1

$$Excel-Macros$$ Re: Forgotten Password

2009-09-24 Thread N.Shivkumar
Dear Umesh Is it possible to send me the file I will try to crack it. Bye N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: Pls Help- Div by Zero error

2009-09-13 Thread N.Shivkumar
Dear Anup Is it possible to send me the file for me to help you N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: Date Issue

2009-09-09 Thread N.Shivkumar
It is just formating i.e. format cell i.e Format/Cell/Number/Custom dd/mm/ N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: NAMED Range

2009-08-13 Thread N.Shivkumar
Dear Suresh The same way how you created name i.e. from A1 to A5. Go to Insert -Name - Define and then delete the named range. It is that simple N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: Any way to divide the cell for ex. by 1000 in its place

2009-04-23 Thread N.Shivkumar
I am enclosing the excel file without a macro. Hope the same serves your purpose. Bye and with best wishes N.SHIVKUMAR Mobile : +919866533180 Office : +914027685423 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com

$$Excel-Macros$$ Re: Query

2009-02-24 Thread N.Shivkumar
The solution suggested by Mr. Johnson is the easiest for a layman. I fail to understand why people make simple things complicated. N.Shivkumar Office : +914027685423 Mobile : +919866533180 Res : +914040035774 Alternate Email : shiv1...@yahoo.com