Dear Exports,
Need ur help
I have 1 Excel file in which
1. you cant Left Column "F" Blank if Column "E" Not Blank
2. you cant Left Column "G" Blank if "E"= HO
Regards
Harish Upadhyay
-
6th Flr, Solaris Building # 3,
Opp L & T Gate No - 6,
Saki Vihar Road, Powai
And
Hi Dalvi,
Thanks for invitation.I want to join but how, please explain.
Naveen
On 9/4/08, Dalvi, Kundan <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> Would like to jon this community for learning excel macros.
>
> Kundan Dalvi
> LEHMAN BROTHERS INDIA
> Finance - BPM
> * 8-053-3924
> [EMAIL PROTECTED
Are you just incrementing the dates by one day? If so, it's quite
easy. Enter the first date in J5. In K5, enter =J5 + 1. Copy K5 all
the way to AW5.
On Sep 4, 10:37 am, cmatera <[EMAIL PROTECTED]> wrote:
> I have a worksheet where cells J5, M5, P5 All the way through AW5 have
> dates formatted i
According to me this is the best formula for Vlookup, Check the
attached file.
Regards,
Ajay
On Thu, Sep 4, 2008 at 10:55 AM, shaily goel <[EMAIL PROTECTED]>wrote:
>
> hi Arjum,
>
> pl find attached file
>
> Regards,
> Shaily
>
> On Thu, 04 Sep 2008 Arjunm1984 wrote :
> >
> >Hi Shaily,
> >
> >If
You can enter date in J5 and then select J5, K5 (Blank) and L5 (Blank) and
then click on the plus sign which you can see on right hand down side of
cell L5 and then strech your selection using mouse (dont leave first button
of your mouse until the selection is complete) till AW5 or till wherever yo
