**what is wrong with this If Statement? thnak you** *Summary*: I am trying to submit a multi if statement and vlookup. here is what I have but not working =IF(ISNA(VLOOKUP(C122,ProjectTracker!$A$1:$AV$118,3,FALSE...

**How to extract 1 date from a cell with multiple dates?** *Summary*: I have one cell with a date range and need to have each date be extracted to a different cell. message edited by sarahh770...

**[Solved] Copy entire excel row to a new sheet if a value is true?** *Summary*: I need a code for the follow scenario: Also if you can kindly help with how to input the code. Thank you in advance. My Sheets are Titled: Sheet 1...

**[Solved] How to lock buttons & textboxes on a work sheet?** *Summary*: LOCKING CONTROL BUTTONS IN PLACE..USING ACTIVEX OPTION BUTTONS, TEXTBOXES, LABELS AND COMMAND BUTTONS ON AN EXCEL WS...WOULD LIKE THEM TO STAY WHERE I...

**Excel Formula needs to add Index to return cell information** *Summary*: Hello, Currently I am working with two tabs of data that do not have the same unique identifiers at the same time. I am using a series of functions ...

**[Solved] Change number in a formula buy referencing a different cell** *Summary*: Basically I have this formula: =(MIKE!$B8) and I have a bunch of cells withs Numbers like so: Cell | Cell Number Change C1 | 10 C2 | ...

**How do I add rows of data to new worksheet from data dump** *Summary*: Hello. I am looking for copy data based on criteria into a new work sheet and format it at the same time. My data is a database dump with thousands up...

**[Solved] Return a number based on today's date compared another date.** *Summary*: I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th f...

**[Solved] Look for matches between 2 worksheets in Excel 2010** *Summary*: I've been attempting to write a macro to do a comparison with a copy function when a match is found. Hopefully this helps explain it: Situation: Work...

**[Solved] Drop downs not showing in document on my Excel** *Summary*: I am using an EXCEL '10 from my employers to use for reimbursements. They have included various drop-down menus on the sheet but no drop down appears ...

**[Solved] Windows Excel 2010 Starter fails to start** *Summary*: Have tried restore to earlier date with no luck. It was working last week and I have restored back past an AVG update today. ...

**hyperlinks suddenly stop working error message can't locate** *Summary*: excel 2010 have adjusted trust centre settings and made Internet Explorer home search....................................................................

**[Solved] Relocate specific rows within the same worksheet** *Summary*: I need a macro that will find rows that column K shows "X", then cut the rows and insert them further down the same worksheet below a merged row highl...

**[Solved] how to get data to correspond to text** *Summary*: I am working on a spread sheet in Excel 2010. The first column has over 1,000 cells and 5 different items in it. The second column has the price of t...

**[Solved] excel 2010 how to freeze and unfreeze headers** *Summary*: I am working with excel 2010 spreadsheet and i will like to know how to freeze and unfreeze headers so i can see the heading as i scroll down my spre...

**[Solved] how to get weekly and monthly totals from horly totals** *Summary*: how do i get weekly and monthly totals from hourly figure totals and monthly hourly overtime totals that are the same in Excel 2010 message edited by ...

**[Solved] Formating to a date Excel 2010** *Summary*: Hi everyone This might be an easy one for whoever knows it I have a number 8202014 I need to format it as a date to show 08/20/14 And the formula shou...

**[Solved] How to find the same numbers in Excel 2010** *Summary*: I have two columns of ID numbers, A1:750 and B1:750. In each columns there are some IDs that are the same but also some IDs that are different. When a...

**[Solved] How do I BOLD specific text string in a Concatenate formula?** *Summary*: Using Excel 2010 Do not want to use VBA, if possible. If this request is not available in 2010, is it available in 2013? ...

**[Solved] Amount greater than, but less than** *Summary*: What is the Excel 2010 formula for the following scenario: Income is $162,000. I need to calculate the amount that is greater than $90,000, but less ...

**excel 2010 How To Turn Off Auto-Hide Ribbon** *Summary*: how can I switch on/off auto-hide in excel 2010. while I'm typing the toolbar is hided, but when the mouse is placed on the top of my program it switc...

**[Solved] how can i track a due date on ms excel 2010 spreadsheet** *Summary*: I am trying to keep track of due dates on my spreadsheets. I have some dates that expire annually and the others biennially. ...

**[Solved] If statement using data validation in Excel 2010** *Summary*: I am trying to use the data validation function to allow certain range of numbers based on a particular category. Category Range Allowed Superior >3.5...

**[Solved] Excel 2010 jumps to File tab whenever a format is changed** *Summary*: In EXCEL 2010, ON the HOME Tab, Whenever I change any cell format from the CTRL+1 pop-up, eg font size, Decimal places fill etc, Excel jumps from th...

**[Solved] Keep a running total of a growing spreadsheet** *Summary*: So....a friend has a spreadsheet that will be growing daily with new data and on one row, he'll have the totals of all calls that he wants to sum auto...

**[Solved] How do I remove trailing zeroes in Excel 2010?** *Summary*: How do I remove trailing zeroes in Excel 2010? I want to remove the last two zeroes from the entire column. For example I want 703100 to look like 703...

**[Solved] how to copy file with macro module** *Summary*: My ex-colleague create invoice using ms excel 2010. In year 2013, my colleague create the invoice start fr worksheet name 13-001, 13-002 .... until ...

**[Solved] copy file from microsoft excel2010 to another workbook** *Summary*: hi, I am using Microsoft excel 2010. When I copy a file to another workbook . My currency in words become #NAME? . but when I go to that cell the for...

**[Solved] Adding totals from multiple ws according to employee name** *Summary*: If you've already answered a similar question for me, I apologize but I cannot figure this out. I have a workbook that has 13 pages, Jan, Feb, Mar, Ap...

**[Solved] How to format a cell in Excel 2010 when selected** *Summary*: I am going to use a macro with relative references to copy a range of cells from one workbook to another. As such the user must be in a specific cell...