excel - Displaying multiple tables using a cells values as criteria -



excel - Displaying multiple tables using a cells values as criteria -

i have multiple tabs, each tab called

alpha, beta, gamma, delta etc

every tab have contain multiple tables containing values, called...

{tabname}first, {tabname}second, {tabname}third, {tabname}forth. give me 4 tables first called,

alphafirst, betafirst,gammafirst, deltafirst.....

i wondering if there anyway can pick/input value in cell, on tab none of these tables, instance select 'third' , below cell, or anywhere on tab version of 'third' appear, tables alphathird, betathird, gammathird etc appear, either seperatley, or info merged single table.

if need more info or examples, please allow me know , update best can.

i guess summarise, possible phone call forwards multiple tables using cell criteria tables phone call forward.

further details - edit

every table contain same column headers , contain same ranges of info within them. have same number of columns, each table can contain amount of rows. values in tables manually typed or picked picklist, containing no formula

to set scenario, there 5 shops, tab each, on each tab table each supplier have, containing order info store each supplier. wish take supplier on separate tab , have orders supplier appear on page every store. store name not need displayed, wish know on order supplier.

excel excel-formula

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more