Once the file is open, the rest of your code is fairly stright forward. It justs copy pastes and sets a VLOOKUP formula. I think (not positive) that part is all the same on a PC and Mac. Here is a good link that shows you how to prompt a user to open a file for a Mac. Select files on a Mac (GetOpenFilename) That's all I have to offer. Excel 2011 Quick Reference Card Excel 2011 Screen Keystroke Shortcuts General. To Cut or Copy Data: Select the cell(s) and press + X to cut,. The chart is inserted in the worksheet. To Use the Formula Builder: Select the cells you want to format. Click the Copy button on the Standard toolbar, press Command-C, or choose Edit→Copy. Click in the cell where you want to paste and choose any of the typical paste methods. Click the Paste button on the Standard toolbar (or the Home tab of the Ribbon), press Command-V, or choose Edit→Paste. Excel has many ways to move to different data areas in a worksheet or between different worksheets in the same workbook. Some methods — such as the Go To command — can be accessed using keyboard shortcut key combinations, which, at times, can be easier and quicker to use than the mouse.

, vbInformation, 'Process Complete' Exit Sub 'This is to stop the procedure so we dont display the error message every time. Err_Handler: It works, but it copies the entire column.

If there's a way to only clear the data from certain cell ranges (as opposed to a complete wipe of the sheet), that would be even better. Jun 3, 2013 I would like to insert a calendar into a cell that will 'pop out' like when booking an airline, and then you would choose your date.

Managing Worksheets, Cells, and Cell Data 3. Managing Worksheets, Cells, and Cell Data • • • • • • • • • • • • • • • • 4. Summarizing Data Using Formulas and Functions 4.

Next, select the cell(s) that you wish to hide the formulas for. Right-click and then select 'Format Cells' from the popup menu. When the Format Cells window appears, select the Protection tab. Check the 'Hidden' checkbox. Click the OK button. For the formulas to be hidden, you must also protect the worksheet. To do this, select the Review tab in the toolbar at the top of the screen.

So when I use the on error resume next, then by the time it gets to the foundfiles line, there are no variables set, so on the next line (workbooks.open) nothing happens. Is there an easier (more up to date?) method to open all csv files (or excel files) in a folder? Dec 12, 2011 In MS Excel 2011 for Macintosh can I assign a macro to an object, such that if the user clicks the object it runs the macro? That is creating a button on the spreadsheet that will execute a macro. Jan 25, 2012 So i am working on an attendance tracker here. I already have aligned on a separate tab all of the works aligned next to their manager EX Column A: Column B: Worker Name Manager What i would like to do is create a drop down menu with all of the Managers name listed to where someone can select that manager and when they do all of the workers names show up in Column A and then that Manager Listed next to them.

Step 13.Choose the new worksheet and check the data present there like the last one. Method 2: How To Move or Copy Worksheet to another Workbook This method would help you to move or copy the current worksheet to a different workbook.

The result is 2.

What do I need to do to create a list that will support that? Jul 6, 2012 Using excel 2010, how do you insert a drop down calendar? Will this be able to display the date and then can I add a nuber to it and the result be a date Apr 16, 2013 I select the date from drop down calendar in excel and linked with one cell. When i use the date in vlookup formula it does not work due to linked cell date format. Apr 13, 2013 I want a drop down calender to choose date from and found that i can use More Controls> 'microsoft Date and Time Picker 6.0 (SP4)' for excel 2007 but it doesn't work with other excel and shows a 'x' not recognised in some other machines. May 2, 2014 I am currently using a pop up calendar in Excel 2010 that with CTL+SHIFT+B that a calendar pops up, you select your date, and then the calendar closes.

I need to look it up on another sheet which has the same number stored as a number, and =VLOOKUP can't find it! On my work laptop, running Vista and Excel 2003, I can copy the number into NotePad, and copy it back again to find it's magically converted to a number stored as text, and =VLOOKUP works. I tried the same thing with Lion, Excel 2011, and TextEdit, and it didn't work - the number is still a number.

Option 1 • With a single cell selected, hit Shift + Space to select the row. • Hit Control + Shift + + (Plus Sign) to insert a row above the current row. Option 2 • With a single cell selected, hit Control + Shift + + (Plus Sign) to insert a row. • Hit Enter to accept the default of Shift Cells Down. If inserting many rows at once, I think the first option is the best since you can repeat the second step without having to re-select the row. This inserts a new empty row. To copy the row, you just need to hit Ctrl+ C between the steps one and two.

See solution in other versions of Excel: • • • • • Question: In Microsoft Excel 2011, I have formulas in a worksheet that I don't want to be visible when that cell is selected. Is there a way I can click on the cell and not see the formula up top in the edit bar? Answer: As you can see, currently the formulas are visible. When you select cell A1, you can see the formula in the formula bar.

I worked for 8 years in a Fortune 50 company. I reduced one process from 45+ days to less than an hour. I learned much from books, and a couple Excel sites where international MS VIP's participated. Not once did they ever want credit. I had posed a problem to do something that was rather difficult, and time consuming (replace hundreds of items in 30,000 rows). There were several excellent solutions.

For the formulas to be hidden, you must also protect the worksheet. To do this, select the Review tab in the toolbar at the top of the screen.

This question already has an answer here: • 7 answers Does anybody know the keyboard shortcuts or menu commands to fill a formula down without dragging? I'm using Excel for Mac 2011 on a MacBook. I've got a spreadsheet like this pattern but for like 5000 rows: A, B, C, D 5, 1, 3 =SUM(A1:C1) 3, 2, 4. I know how to hover over D1 and get the handle and drag down, but there must be an easier way.

Nevertheless, as I press ctrl +. Here, we will see that the formula got copied all the way down to row 742. Clicking ctrl +.

Sep 15, 2012 I use mac and I have 'Excel for Mac 2011'. I need to exact some data from a file. I can open the file, but can't see any data of it.

Power Functions 6. Power Functions • • • 7. Selected Financial Functions 7. Selected Financial Functions • • • • 8. Selected Math Functions 8. Selected Math Functions • • • • • • • • • 9.

Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado. By: Dennis Taylor course • 25h 12m 36s • 1,373,984 viewers • Course Transcript - We're looking at the workbook called chapter 3a, and there are many worksheets in it. We can see all the worksheets at the bottom, but that's not always the case, so, a habit to get into, when you're opening a workbook that you have not seen ever, or, perhaps, not in a long time, is, in the lower left-hand corner, you'll see four arrows, right-click, and you'll get a vertical list of sheet names. It just so happens, right now, we can see them all at the bottom of the screen, but that's not always the case.

Now what I'll do is simply copy this over, or move it over, right to there. And we'll simply copy this down one cell and we're all set. But anytime you do have an empty cell in an adjacent column to the left, the double-clicking method will stop if it sees an empty cell. If there's any thought or any suspicion there might be one, simply highlight the column to the left. But always check out after double-clicking whether the formula got copied all the way to the bottom.

Code: Columns('AI:AI').Select Selection.TextToColumns Destination:=Range('AI1'), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _ [Code]. Aug 15, 2013 I am running Excel 2011 on Mac OS X.

It's called the fill handle, and we see all of our results popping into place. I think what you would want to know almost immediately is, 'Did this get copied all the way down the column?' But rather than scrolling, which is relatively easy, simply press ctrl +. And that moves the active cell to the bottom of the list. You might want to scroll slightly below that just to see it and make sure. Simply moves the active cell around the corners of a selected range. And when you double-click, not only are you copying the formula but you're also highlighting the range.

I am having some success for each task with exception to relative cell values. As the code will be specific to the row (one button per row) Questions: how to i determine the location of the button that is clicked? (I assume once this is established i can use to pull values in the same sheet on certain columns.?) Jan 30, 2012 I'm using Excel 2011 for MAC. What I need is to clear and lock some cells based on a drop down list selection. The case is like this: In Cell [E14] is a drop down list: 0,1,2 or 3 Cells: (D19:E19), (D21:E21), (D23,E23) Merged are PART DESCRIPTION Cells: [G19], [G21], [G23] are COST So I need when 0 is selected in the dropdown list, all of the above cells are cleared and no input is permitted, Cells locked.

How to get the sorted blank cells to the top? I'm using Excel 2011 on Mac OS X 10.7.

Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.

Anyhow, the excel problem appears to be fixed. Hope the printer issue is fixed too! Very slow copy and paste This one has been plaguing me too, but only intermittently - bizarrely in one file some sheets were fast, others slow. What I discovered, by chance, was that there were hidden objects sitting on a layer above the cells - revealed by accident only if I moved the cursor slowly around a sheet, and cross occasionally turned either to an arrow, or the floating text cursor.

Click the Copy button on the Standard toolbar, press Command-C, or choose Edit→Copy. • Click in the cell where you want to paste and choose any of the typical paste methods.