Stack Overflow
Stack Overflow

Questions tagged [excel-2011]

Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.

151 questions
0
votes
1 answer

Compile error: Expected Function or variable

I have this macro (written in Excel 2016/Windows) that acts a very simple reservation tool, checking if an asset is currently booked or free. Depending on this, it either writes when the booked period will end or when the next booked period will…
Jascha Ell
  • 1
  • 2
0
votes
2 answers

ROW() in formula Excel for Mac 2011

I have an XLS file with several Sheets named "1", "2", "3", "4", etc. Now I need a formula that will result in e.g. "='1'!M16" where the name of the Sheet I am referring to is based on current row. So if the current row is 16, the formula would be…
Tom Picka
  • 23
  • 6
0
votes
0 answers

Mac Excel 2011 VBA Dir() function file recognition issue

I am trying to create a macro that will allow me to import data from all files ending in ".xlsx" in a specified folder into a single spreadsheet. I've mostly figured it out, but there's a recurring issue that requires a manual work-around until I…
bdn711
  • 27
  • 5
0
votes
1 answer

If two cells match, return value from third- one of the "matching" cells is vertically merged

I have a contact list from hell that needs cleaning up. The basic problem is this: the company name is merged vertically and there multiple rows of information for each company (with blank cells everywhere). Screenshot of Excel Issue I have…
Jahana Uchtman
  • 1
0
votes
1 answer

Inserting column from sheet2 into sheet1 in Excel without zeroes on unavailable data?

I am trying to get a column from one sheet and putting it in another. I am pulling the "names" column from this sheet: this is sheet2 and putting it into another sheet (sheet1) by using =sheet2!A3 and =sheet2!A4 and then dragging down to the bottom…
FishMonkey
  • 178
  • 4
  • 15
0
votes
1 answer

Get data from textbox in Word-UserForm

I have a Word document based on a template for invoices and a database in Excel containing two tables: Company and Person. I want to put some string into the textbox in the userform in Word which will then be searched in Excel. Excel shall return…
Kathara
  • 1,226
  • 1
  • 12
  • 36
0
votes
2 answers

Specify a range of cells around a particular cell

I am trying to write a function in Excel for Mac 2011 (NOT as a macro; just plain old "=[Function Here]" format) that will take to following form: =STDEV([X cells above and below this specific cell, in a different column]) NOTE: I am specifying the…
Matt Billman
  • 472
  • 5
  • 19
0
votes
1 answer

How to use an IF statement to calculate commissions or flat fee

I am trying to use an IF statement in Excel. I would like the statement to do the following: I have three fields (C13, D16 and E16) that are user inputs. C13 holds a sales price, and then the user either enters a commission percentage rate (D16) or…
sewnerdy
  • 15
  • 8
0
votes
2 answers

Replace italics within Excel file with HTML tags

is there a way to replace formatting such as italics with their tags, e.g. ? More in general, how do I search for a format:italic and replace with foundstring(^&)? Basically what I want is to have this: blabla bla bla replaced with…
HBMCS
  • 686
  • 5
  • 25
0
votes
1 answer

OS X Excel 2011 VBA Save File Name

I need to write a script to save a worksheet with to a predetermined location and the save name is filled from values within the worksheet. I can get it to save in the proper location, but the file name returns a combination of FATPMetiFolderPath…
Gerasimos.Zap
  • 159
  • 1
  • 3
  • 16
0
votes
3 answers

Display the upcoming due date

I am working with Microsoft Excel for Mac 2011 doing some personal finance and trying to devise a formula to display a specific date. I have a credit card bill that is due on the 24th of every month. I have the name in Column A, and the Date it is…
Tibneo
  • 39
  • 1
  • 9
0
votes
1 answer

xlwrite changing font format in Excel

I am currently running MATLAB R2013a on OSX and am attempting to write the contents of a cell array into a specified cell of an .xlsx file in Excel 2011 for Mac. When I first tried using the built-in MATLAB function xlswrite, I was unsuccessful, and…
dwm8
  • 309
  • 3
  • 16
0
votes
1 answer

Copying a range in a row where the # of x to be copied is in cell

I need to copy each of 69 rows n number of times. The n number of times each range in a row that should be copied is in the row as well. I attached a screen shot so you can see the data. I tried one of the other answers on here, but it did not work…
shannimcg
  • 71
  • 1
  • 10
0
votes
1 answer

How to auto-fill a simple excel formula down an entire column

I have an excel file with health records above (immunizations to be exact) that looks like the attached image. The format I am needing is to have the below record dates going all across the file in a single row. So, it would look like: dtap dtap…
Joe
  • 512
  • 1
  • 3
  • 16
0
votes
0 answers

Scripting Excel with Applescript: Problems with reading a range

I have a script that I use to export expense entries from Excel to QIF format. To create the output files, I have a table in Excel that lists the expense (account) types: PaymentType Category Acct Type ----------- ----------------- …
SwimsZoots
  • 387
  • 2
  • 4
  • 13
1 2 3
…
10 11