Thanks
Actually data which i have provided is a part of my database atually in my
database we have details of all candidates who joines on that basis we have
some unique status (given in Current status column") which we have to update
during his trianing but the problem is that we have to update all the staus
manually becusae of this some time error accured so that is why i want it
that
1) when ever any status (out of 31 status only ) updated in A Column in
Sheet1 rest details ( from B to S column) should automatically updated in
that area
For eg:If i am updating "Induction Dropout or Core " in Current status
column rest details (From "Induction In" column to "Production In " column )
should come automatically
For all staus details kindly look into Attachement
*Current Status* *Induction In* *Induction Dropout* *Core In* *Core
Addition* *MIT Core In* *Total Core In* *Core Out* *Process In* *Process
Addition* *MIT Process In* *Total Process In* *Process Out* *OJT In* *OJT
Addition* *MIT OJT In* *Total OJT in* *OJT Out* *Production In* Induction
Dropout Yes Yes No No No No No No No No No No No No No No No No Core Yes No
Yes No No Yes Core Core Core Core Core Core Core Core Core Core Core Core
Request you to provide me the solution.
On Thu, Feb 24, 2011 at 11:20 PM, Ms-Exl-Learner . <ms.exl.lear...@gmail.com
> wrote:
> Hi Maulik,
>
> I am sure you will get it resolved if you explain your expectation with
> some more brief about the way of pulling the data with cell reference and
> how it can be derived.
>
> Because you know very well about your data and the way your expected
> result. But for us the data is a new one and we will be having some more
> interpretations about your actual query and we wont come to know your exact
> requirement until unless you explain it in a better and clear way.
>
> Hope that makes sense :)
>
> -----------------------
> Ms.Exl.Learner
> -----------------------
>
>
> On Wed, Feb 23, 2011 at 10:44 PM, maulik desai <mauliksde...@gmail.com>wrote:
>
>> Hi ashish sir,
>>
>> thanks u for this ,but can u pls tell me how to use this because when
>> i del any status and enter other in same cell it gives some error and
>> basically i want that when ever any status updated in that column in
>> database rest values should come automatically
>>
>> On 2/23/11, ashish koul <koul.ash...@gmail.com> wrote:
>> > see if that helps
>> > On Tue, Feb 22, 2011 at 11:07 PM, maulik desai
>> > <mauliksde...@gmail.com>wrote:
>> >
>> >>
>> >> In My excel database there are Huge database availble
>> >> for this eg I have given the unique current status (which can be
>> repeted
>> >> many times )
>> >> what I want is when ever Below status updated in "Current status "
>> Column
>> >> Rest colums should give me the value based on status provided In that
>> >>
>> >> This the just small part of the database.
>> >>
>> >> For more infomation kindly ref the attachment
>> >> --
>> >> Thanks & Regards,
>> >> Maulik Desai
>> >> 9967363926
>> >>
>> >> --
>> >>
>> >>
>> ----------------------------------------------------------------------------------
>> >> Some important links for excel users:
>> >> 1. Follow us on TWITTER for tips tricks and links :
>> >> http://twitter.com/exceldailytip
>> >> 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >>
>> >> To post to this group, send email to excel-macros@googlegroups.com
>> >>
>> >> <><><><><><><><><><><><><><><><><><><><><><>
>> >> Like our page on facebook , Just follow below link
>> >> http://www.facebook.com/discussexcel
>> >>
>> >
>> >
>> >
>> > --
>> > *Regards*
>> > * *
>> > *Ashish Koul*
>> > *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>> > *akoul*.wordpress.com <http://akoul.wordpress.com/>
>> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>> >
>> >
>> > P Before printing, think about the environment.
>> >
>> > --
>> >
>> ----------------------------------------------------------------------------------
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> > http://www.facebook.com/discussexcel
>> >
>>
>> --
>> Sent from my mobile device
>>
>> Thanks & Regards,
>> Maulik Desai
>> 9967363926
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Thanks & Regards,
Maulik Desai
9967363926
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
