$$Excel-Macros$$ Please suggest

2015-01-21 Thread Rajeev Ranjan
Dear All, I have a one issue. I want the define in particular category. eg:- Value Category Emp_code+Emp Name "new code" Emp_name_Mob_No "Old Code" Means:- Pre Numerical + Any String then write the* "New Code*" in Category columns Any

$$Excel-Macros$$ please suggest

2015-07-07 Thread Kumar Bhanushali
Dear Sir, 1) Is there any way, that if any value is pasted in column, it should be automatically round off to specified value. 2) Is there any way, that if cell having formula is copied and it will paste to another sheet, but it will paste only formula text removing = from it, not value. Regar

$$Excel-Macros$$ Please suggest

2010-05-15 Thread ╚►♥ѕαη∂єєρ♥◄╝
Hi All, I am Sandeep one of the group member like you, I am living in West Delhi Uttam Nagar wanted to Learn VBA( Macros ), Access and SQL. if you know abt any institute, any faculty, any good book or any thing which help to learn this Please Reply the mail or may ID sandeepxxxku...@gmail.com

Re: $$Excel-Macros$$ Please suggest

2015-01-21 Thread Kanwaljit Singh Dhunna
Dear Sir, A sample file would help to understand the issue. On Wed, Jan 21, 2015 at 4:45 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > Dear All, > > I have a one issue. I want the define in particular category. > > eg:- >Value Category > Emp_code+Emp Name "n

Re: $$Excel-Macros$$ Please suggest

2015-01-21 Thread Rajeev Ranjan
HI, please find the Sample data Input Data are Value columns output data are Category columns. Value*Category*Description001_Anil Sikdhar_MPCG_VAINew Codeinteger value+ String456_RAJENDRA Kewat_MPCG_VAINew CodeAP_Adecco_Maheshwar Kumar.V_98660Old CodeString + IntegerAP_Adecc

Re: $$Excel-Macros$$ Please suggest

2015-01-21 Thread Vaibhav Joshi
check col. B in attachment Cheers!! ᐧ On Wed, Jan 21, 2015 at 5:47 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > HI, > please find the Sample data > > Input Data are Value columns > output data are Category columns. > > Value*Category*Description001_Anil Sikdhar_MPCG_VAINew >

Re: $$Excel-Macros$$ please suggest

2015-07-08 Thread XL Macros
Hi Kumar, For your 1st Question, you need to write the macro in Worksheet_Change Event. For your 2nd Question, yes you can get only formula text. You can use the formula called FORMULATEXT =FORMULATEXT(Cell_Refefence) Note: FORMULATEXT is a new formula in 2013 Version of excel. Previous versions

Re: $$Excel-Macros$$ please suggest

2015-07-08 Thread Kumar Bhanushali
Dear Sir, 1) will you suggest me the code. 2) how to use the formula in 2007, for that also if you suggest the code. It will help me a lot. thanks Regards, Kumar Bhanushali Re: $$Excel-Macros$$ please suggest XL Macros to: excel-macros 08-07-15 12:33 PM Sent by: excel-macros

Re: $$Excel-Macros$$ Please suggest

2010-05-15 Thread Rahul Mulchandani
Hi, For VBA, I can suggest Excel 2007 VBA for dummies - John Walkenbach Excel 2007 Power Programming with VBA - John Walkenbach If you're starting out for Access, start off with the Missing Manual. I'm not an Access guy, but there are good reviews on Amazon for the same. SQL - No Idea, no idea f

Re: $$Excel-Macros$$ Please suggest

2010-05-15 Thread Rahul Mulchandani
But, don't learn VBA for the heck of it, try to implement in work/projects, that's when you'll learn it faster. On 16 May 2010 00:35, Rahul Mulchandani wrote: > Hi, > For VBA, I can suggest > > Excel 2007 VBA for dummies - John Walkenbach > Excel 2007 Power Programming with VBA - John Walkenbach

Re: $$Excel-Macros$$ Please suggest

2010-05-15 Thread Rahul Gandhi.
Dude, If you will be able to find any institute then also let me know, I also wants to Join and I am residing in Subhash Nagar. Regards, Rahul Gandhi. +91-9711772297. On May 15, 8:31 pm, ╚►♥ѕαη∂єєρ♥◄╝ wrote: > Hi All, > > I am Sandeep one of the group member like you, I am living in West De

Re: $$Excel-Macros$$ Please suggest VBA Book Name

2011-09-20 Thread rajan verma
You can finf excel vba 2007 published by o reily On 20/09/2011, Rupesh Shrivastava wrote: > Hi, > > Can anybody suggest me the name of the Best book available in the market to > learn VBA. Please suggest. > > I have already one book "Excel 2010 Power programming with VBA" , By- John > Walkenbach

Re: $$Excel-Macros$$ Please suggest VBA Book Name

2011-09-20 Thread NOORAIN ANSARI
Dear Rupesh, I would suggest to check the Group's page for ebooks. Alternatively, you can also google and download pdf books as per your choice. There are many online tutorials available as per various expertise levels You can also download ebook... http://www.recordexcelmacro.com/vebook

$$Excel-Macros$$ Please suggest as i want to learn MS-Access (Noida)

2012-04-24 Thread prince sethi
I am not aware whether i should have to write this or not.. If it not adequate post please discard this one but not banned me from this Forum. what will be the duration for the same. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ Please suggest as i want to learn MS-Access (Noida)

2012-05-05 Thread LAKSHMAN PRASAD
contect to NOORAIN   @      From: vijayajith VA To: excel-macros@googlegroups.com Sent: Saturday, May 5, 2012 11:31 AM Subject: Re: $$Excel-Macros$$ Please suggest as i want to learn MS-Access (Noida) HI prince Try this. MVP'S Web Links Al Cam