excel 2011 for mac

Hello all! I found a macro on these boards for tracking attendance with a barcode scanner, but the code does not seem to function in Excel for Mac 2011. Here is a link the the old thread with the macro I'd like to use: Need Help with an Attendance Sheet Using a Barcode Scanner - Page 2 I...

I'm trying to create a very user friendly form for a team of mental health workers, who are not tech savvy. Essentially, it's a progress note that is filled out after each session. I'd like for the template to carry over to the next sheet and be named the date of session that the therapist...

Is there a command in Excel for Mac 2011 similar to .WebTables in Excel/Windows 2010 that allows one to select the tables to download? i.e.: .WebTables = "8,11,14,17,20,23"

I'm using Mac Excel 2011. It seems that CF only supports style changes like color, font, etc. and not formatting changes like currency, percentage, etc. If this is not the case, how does one do this? Assuming my above assumption is correct, how can I achieve the following: I have two...

Hello guys, I am having an issue when trying to search for a file (based on a cell reference) within a specific directory using the MacID function. The code I am currently using will attach only the entire folder and not the specific file within the folder: The cell "C8" is an invoice number...

Hello guys, I am by far no <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51);">VBA</acronym> expert and have managed this far by copying code from elsewhere...

I imagine this must have been asked and answered before, but I couldn't seem to find an answer to this exact scenario, and I'm hoping someone else can point me to one. I'm on Mac using Excel 2011. This means I don't have "slicers", which is all my Googling kept turning up. I have a pivot...

I am a 5th grade teacher developing a lesson plan template for myself & for my elementary work colleagues. We are now required to include the Common Core State Standards (CCSS) in our weekly lesson plans. To help with this task, I am working on a template using Excel wherein the teacher can look...

If I want to display row values 1-30 when the cell value is 30 or 1-10 when the value is 10, what function do I use for that? Thanks in advance.

Just like the title says, I have a fairly large amount of data reporting into a pivot table. I made this on windows and it works perfectly fine. I sent it over to someone with a Mac (their excel is fully updated), and after they modify the source data and try to refresh the pivot table, Excel...

So, I feel a little dumb asking this, but I've tried to work on it and figure it out all day to no avail, and I figure this is the quickest way to get an answer... I wrote this code on a machine running excel 2003 and everything seemed to work fine, but I brought it to my iMac at home running...

I have a question about compatibility of VBA code between the PC and Mac. I have several scripts that I am using successfully on my PC at work, but when I try to run them on Excel 2011 on my Mac at home, they error out. I'm assuming this is a Mac issue, and not an issue with compatibility...

Hi Guys I apologise first of all - I'm a mac user and using the mac version of excel which frankly I will openly admit is no competition for the pc version. I'm dealing with lots of data information on massive spreadsheets and constantly using the search facility. On the mac version of excel...

I have created meaningful icons for a number of macros used by our engineers. These were used as "buttons" on the ribbon in previous versions. Is there anyway to convert these images or create new images for buttons on a custom toolbar in Excel 2011 for Mac? The 42 supplied by Microsoft won't...