s,
DK.
-- Forwarded message --
From: priti verma
Date: Thu, May 16, 2013 at 10:57 AM
Subject: Re: $$Excel-Macros$$ Excel Validation
To: excel-macros@googlegroups.com
Hi DHAMODHARAN,
*i have a solution ,**May I restrict to enter that entry that is not a PAN
number in that column.*
*The benefit of this
rectify the incorrect PANs in the main sheet.
>
> I attach the Sample File.
>
> I further request to see my previous message (appended below) in case, you
> look for any reference.
>
> With Regards,
> DK.
>
>
> -- Forwarded message ------
>
Resending, Updated with conditional formatting for incorrect PANs,
On Wed, May 15, 2013 at 9:07 PM, Abhishek Jain wrote:
> Hi Sir,
>
> On behalf of the group, let me welcome you to our little excel loving
> family.
>
> Please find attached a quick try upon your query. Hope this helps.
>
> If you
Dear Friends,
*Sub : Validation.*
Please see the attached sheet, which is self-explanatory.
I need to have validation for PAN.
That is, the PAN structure is AAAPA 1234 A
First, Five Characters are to be only ALPHA i.e. AAAPA
Sixth to Ninth Character have to be only Numeral i.e. 1234
Tenth Ch
Hi All,
I put a validation in one excel worksheet
It's dosen't accept the data's copy from one sheet to past this sheet.
e.g : copied from onther sheet and paste
--~--~-~--~~~---~--~~
-
