How do I add a drop down list of strings that represent different worksheet names in Excel 2007? -

-

Recently my job is placed on a reporting project, my overall purpose is to report 9 different charts Which can also be filtered by data and by group. There are 22 different groups and I need to drill down to show a report from the individual month, week, and day. I have to do all this in Excel in 2007. For now, I am working on showing results from the month and for all the different application groups and for all the groups Summary

The way in which I have installed it is a workbook containing 2 worksheets , 1 in which there are 9 lines, let's call this dashboard_ell. This graph is linked to another sheet that contains all the information for each article, let's call it Chart_Data.

Can you imagine, from which chart data is coming? Chart_Data references some tables in another workbook, which includes raw data, pivot tables, and matrix tables. I have set it on a worksheet that contains all the raw data in a table. A worksheet contains all the spindle tables (1 pivot table for each chart) so that it touches raw data and gives me results. I have created 23 different worksheets that have these results, 1 for each group (I have used group filters on each piet table) and 1 as the summary for all groups. I have also created 23 different worksheets, where I have created matrix tables for each pivot table result. These tables are used because whenever I change a pivot table for a different group, the results change and sometimes the columns or rows are omitted, so if no data is read, I use tables It has been made that the pivot table is for reference cells, which basically act as sparse, if the pivot table has empty values, these charts are different Nine months are present in the form of rows of all possible combinations and different columns. Chart_data from the previous workbook references these matrix tables.

I used a VLOOKUP function in the chart code that is linked to a drop down list. For example, please select one month: drop down January February March ... Vlookup all months knows that when I only show a number of charts for that related month a month I choose. That's why my monthly objective has been fulfilled. Now for the Apps Group, I need another drop down box which will reference different matrix table worksheets in my workbook. If I select a group from drop down, then VLUKUP will go with the appropriate information in that appropriate sheet.

The problem is, how do I give it to identify different sheets? For example, 

  = VLOOKUP (C3, '[Blah-Blow_Vava_churs.xlsx] Group 1 chart data'! $ A $ 20: $ B $ 32, 2)   
 How can I have a change in "Group 1" with drop down selection?  
 I know it has been rotating and misleading for a long time, but I'm not sure how to tell it further. Thank you so much.   
 
 
 You can use an indirect () example;  
  = VLOOKUP (C3, indirect ("[HPSM_" and C1 and ".xlsx] sheet 1! $ A $ 4: $ B $ 16"), 2)

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

c# - Using Vici cool Storage with monodroid -

-
Oh, for the moment I am not sure how it is officially supported, but for the success of the people Using Monodroid Vic Cool Storage I am able to leave and compile assemblies in my project, but while trying to use some classes, the errors of time have to be gathered. Especially when trying to connect like the example for Mono Touch string dbName = path. Cobain (environment. Gatefolder path (environment specialfolder personal), "mydb.db3"); // The following line will be called coolestation, where is the database, // to make it if it does not exist, and call a delegate that creates the necessary tables (only when the database file was newly created //) CSConfig.SetDB (DbName, true, () => {CSDatabase.ExecuteNonQuery ("Subscriber Integer Primary Key Attribute, Name Text (50) No, Number, Date First Text (30)");); There is no difference when I try to use the methods of CSConfig and when I cscfif If I try to pass 3 aggregates to STDB (3) then I get the invalid ...
Read more

python - referencing a variable in another function? -

-
I am an experienced TCL developer and write my own processes to help myself. I call it a proc i callVar, print out the value of the variable in a certain format, so I know that it is variable and what is the value "set foo 1; putVar foo" result 'foo = "1" I want to do the same thing in Python, but I can not find the answer :( In TCL I use the up command because when I pass the name of the variable, then I can see the value at the top. . I understand that an advanced light in the dragon There is no mechanism of r, but with its introspection capability, I would think that this is something trivial, but I am not getting the answer anywhere. It seems that this should work: and expanded: def foo (): y = "Hello World" printwor ("y") foo () y = "Hello World " You can, but you should not do so if your code is correct If is needed , then there is something wrong with your design, and you should probably use the dictionar...
Read more