excel mac

Hello, I have tried everything to find a solution for that. My code is working perfectly on Windows. Is there any equivalent function for the RowSource to use in Excel for Mac? I do not want to use listbox.add, because I want for multiple columns. This is my code that works perfectly on Windows...

Hi I'm trying to create a Macro so from my worksheet by pressing a button it will export it as a PDF but then save it based on 3 cell values C4, C6, C8 (All Values are Text) I'm wanting to save it to a specific file location smb://seacroft_file/Head Office Management/Timesheets Its Excel For...

I am new to Mac, and don't know how to toggle between open excel workbooks. The research I have done online is dated more than 5 years ago. And their tips didn't work. Anyone know how to toggle between open workbooks on a Mac? (Like using the CTR+Tab key on a PC?) Thanks for your help!

I have a large macro that creates reference columns based on other data in the workbook. This macro is working fine on a Windows PC, but is giving me issues on the Mac version of Excel. Section of code: Range("O2").Select 'Enter formula on first cell...

I need to create charts like this for each priceband. my questions : 1. how to show % on both vertical axis? 2. how to make both areas overlap so that when these areas combined, it shows the total share of that particular category ? I m using Mac - would appreciate if someone could show me...

Hi all, I wrote a macro for our accounting department that generates a PO number for purchase orders by referencing numbers that have already been used, copies the tab to a new workbook, deletes the macro buttons off of it, and saves the purchase order in a specified location on the network...

I'm trying to make a graph to see the differences in student testing by age and their school rating. I could very easily make a scatterplot with student test scores by age and another for student test scores by school rating. But how can I get them on the same graph in a way that will tell me...

I have groups of cells that are different number of rows long. What differentiates the groups is a space in between them. I would like to be able to change every row from A within a group into a new Colum. For example: INPUT <tbody> <tbody> 3/S Carwash Service 4635 S. Harlem Forest...