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
