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
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
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
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
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
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
>
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
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
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
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
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
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
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
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
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
15 matches
Mail list logo