Hi Kannan, To create a report in this format is not advisable. The data have to be in contiguous, there should not be merged cell in between them. Maintain listing productivity and broker productivity separately.
if you maintain it this way the data can be pulled in a numbers of ways in seconds. Regards Umesh Dev On Sat, May 21, 2011 at 5:35 PM, kannan excel <kannan.ex...@gmail.com>wrote: > If i put my executive name, his weekly and monthly perfomance will come > automatically > > > On Sat, May 21, 2011 at 5:31 PM, kannan excel <kannan.ex...@gmail.com>wrote: > >> Hi rajan, >> >> i am maintain our office Productivity tracker. >> my boss asked our executive weekly and monthly perfomance sheet. >> >> now i want, if i put my executive name, his details all will come >> automatically. >> include also formulas, macros, vba.... any thing... >> >> tomorrow sunday i want to submit my productivity tracker. >> >> i attached my company productivity excel. >> >> i don't know how i manage this problem. pls help me. urgent. give my excel >> sheet perfectly. today or tomorrow morning before 12pm. >> >> Kannan V >> 9941077703 >> >> >> On Sat, May 21, 2011 at 5:00 PM, rajan verma <rajanverma1...@gmail.com>wrote: >> >>> we cant understand your problem.... Please Explain More.. >>> >>> >>> On Sat, May 21, 2011 at 3:28 PM, kannan excel <kannan.ex...@gmail.com>wrote: >>> >>>> >>>> Pls me ya. >>>> >>>> I want excel Vb coding format in Mis >>>> >>>> executive's - weekly and monthly Productivity. >>>> >>>> Broker's- weekly and monthly productivity. >>>> >>>> Broker's given listing for - weekly and monthly productivity >>>> >>>> and our company weekly and monthly producivity. >>>> >>>> need searching option in vb coding excel. like macro. >>>> >>>> I don't have any examble. but i attached my excel sheet. u just see and >>>> help me. >>>> (must in search engine) >>>> like if any executive name i type and click search button means his >>>> details ll appear immediatly. >>>> >>>> pls help urgent. >>>> >>>> thanks & regards >>>> >>>> Kannan V >>>> 9941077703 >>>> onechennaiproperty.com >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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 >>> Rajan verma >>> +91 9158998701 >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 > -- ---------------------------------------------------------------------------------- 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
