2011

Please forgive if this has been covered, I searched but there were *so* many posts on the general topic and the first bunch I looked at were all Windows-only solutions, so I decided I just needed to post anew. I'm on Mac Excel 2011, so there is no Pivot Table Wizard. I have 4 workbooks, each...

Dear fellow members, I'm looking for help in doing range sliders in Excel like described here (Range Filter Slider Control in Microsoft Excel - Clearly and Simply) the only problem I have is that this solution doesn't work on Mac (both 2011 and 2016 versions). May be there is a solution which...

I am trying to use Find and Replace to find the pipe symbol (|) and replace this with a carriage return. The ctrl+shift+j does not work for me on the Mac keyboard using Excel 2011 for Mac. If I go into my VM running windows and Excel, then it works just fine. Thanks, Benje02

Hi, I would like to code something simple to automate the following process: <colgroup><col><col><col><col></colgroup><tbody> Survey Period Normalized Score Diff vs Preop IDK 1 pre-op 63.89 6 wk 97.22 97.22-63.89 12 wk 100.00 100-63.89 24 wk 100.00 100-63.89 52 wk...

Hello, I've been researching my problem but can not get it to work. Here is the setup, 5 columns (A-E) 20 rows (1-20)the conditional formating is set so if A1=0 then it will fill A1-E1 black.I want to copy it down so each row works the same. However every time I copy and then special paste...

Hello And Thank You All!! Thanks to everyone for all the help! I just learned the wonders of pivot table WOW! I have looked and experimented on how to include multiple ranges on a pivot table in excel 2011, i have found how to to it with the wizard but i can not find the wizard. Can some...

Hi All, I am using Excel Mac 2011 and it appears to be clearly ignoring the screenupdating command. My Macro opens a new workbook and saves it as something else hundreds of times whilst taking information from another workbook which remains open the entire time. The trouble is, the screen...

Hi All, I am using Excel Mac 2011 and require the code to wait for a certain period of time. Is there an alternative to using the 'sleep' command as results in an error? Thanks, Dave

Hi Folks, I am using Excel Mac 2011 and have a rather large macro that takes information from a very large global worksheet (10,000 rows) and creates approx 100 new worksheets. It's mostly nested for loops, nothing too complex. The overall performance of the Macro is fine, taking around 10...

I have hidden sheets that I want to 'unhide' once a hyperlink is clicked but can not figure out the code needed on each sheet. I've tried this code I found online but it's not working for me. Please help! Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) shtname =...

-- removed inline image --- <style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px...

I am trying to find out the exact sum of time down to the hh:mm:ss on my pivot table from different people on different dates (in half hour increments). Hence: Columns: name name name name name Rows: 01-01-2010 12:00 01-01-2010 12:30 I need a sum of time from each column WITHOUT the dates...

Hi all, I have quite a simple question for you, having just migrated to a mac and Office 2011. Of course the first thing I want to try out is whether the macros from my PC still work ... I have a Cell on a sheet, that contains the full pathname of the file I want to load. My macro uses this...

Hello all, I'm trying to run macros in Excel 2011 (Mac) that worked fine in Excel 2004 (Mac). I have OS 10.6 on a Macbook Pro. The line of code causing the error is: Trial = Worksheets(Subject).Cells(I, 1).Value Where subject is string containing numbers (e.g. 801); I is an integer and a...

I am new to excel (excel 2011 for Mac OSX) I set up MSN stock tracker so that on "Sheet 2" I have the MSN app and on "sheet 1" the company names in Column 1 and the price in column 2 - The cells in sheet one update every time I refresh MSN data. Looks like this.... ..........A.......B...

Hi, I have Excel 2011 and have been trying for a while, but have not succeeded, to insert a picture into my VBA form. I've saved as every file type imaginable, including Windows BMP, but when I attempt to import it, Microsoft Visual Basic tells me that it is an Invalid Picture. How the heck...

We are having a problem reopening saved XLSX (as well as DOCX) files. If a legacy XLSX file (probably from Excel 2009 for Mac) is opened in Excel 2011 for Mac, modified, then saved, it become un-openable. Error message is: "Excel cannot open this file. The file format or file extension is not...