excel for mac 2011

I wrote a query to download stock data from the web which works when I enter the symbol manually. However, I tried making the query to look for the symbol in a cell but can't fire it out. Any direction would be greatly appreciated. The code has more lines but for simplicity I copied below is...

I'm developing a testing platform. I'm struggling to come up with a formula in Excel for the following tasks Add Pass/Fail/Advisory dropdown list. When Fail/Advisory selected from the dropdown list. The user will have to write a few lines about the outcome results. Then all the results then...

Hi I have multiple datasets each of which has close to 1200 Worksheets. In each of these worksheets there is data spanning from 1000 rows to 5000 Rows.(Mostly at the lower end of the spectrum) The problem is quite simple. I have obtained this data from an online database and since it is based on...

All, please can you help? I've just moved to using excel for mac 2011, and I am working with charts. When I build a chart excel for mac seems to default to having the largest scale numbers as the y axis, regardless of what column order I build the chart with. I need to swap the x and y axis in...

I am working with Excel for Mac 2011. In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these? If not, can I add a macro to a shape so that it can do what the picture boxes do...

I am working with Excel for Mac 2011. In the SmartArt section they have a picture tab, where you can select from various formats. None of these formats fit my needs. So my question is, can I customize these? If not, can I add a macro to a shape so that it can do what the picture boxes do...

What I have: I have a .csv file that has a column that contains 4 paragraphs of text within each cell. When "wrap text" is selected, an individual cell appears neatly formatted. I have roughly 300 rows of these paragraphs (300R x1C) What I am trying to do: Remove paragraphs 2 & 4 while...

Hi. New to Macros... Using Excel for Mac 2011. My goal is to be able to select cells and convert cells with formulas into the resulting values. I manually recorded this Macro: Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Option+Cmd+q ' Range("D16").Select Selection.Copy...

Hello, I have been using a specific excel macros 4.0 workbook for years and recently upgraded to Excel for Mac 2011 from 2004. I am using MacOS 10.6. The macros were written for me by someone more than a decade ago and he is not available now. When I use the macro it comes back with this...