-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
qqq
-
S
Cell contents to be used as worksheet reference
Using VBA I'm trying to read a cell (with a dropdown list of symbols) -- like "QQQ," and then use this symbol to refer to a worksheet in a formula such as: Range("N38").Formula = "=Offset(QQQ!AL10, 4, 2, 1, 1)" so that I can use whatever symbol is in the dropdown and have it refer to to a...- StanSz
- Thread
- cell dropdown qqq symbol worksheet
- Replies: 7
- Forum: Excel Questions
-
U
Help with query
Hi there, I want to know if there's a way to brake-down to components a data table according to weight? I have a portfolio of equities and etf's (table 1) , and I want that every ETF in it will be 'opened' according to the weights (table 3) of its related index (table 2) , so I'll get a table...- udigold1
- Thread
- access consumer qqq query table
- Replies: 7
- Forum: Microsoft Access
-
D
Excel frequency of data graphing
Hi, I have been trying to create this but haven't worked for me yet. What I am looking for is: I have a deployment sheet as follows and need to create a graph: 1. by division, monthly; how many apps deployed in region "MO" 2. by division, quarterly; how many apps deployed in region "MO" 3. by...- desta
- Thread
- qqq
- Replies: 8
- Forum: Excel Questions
