Excel Forum - solved topics

Ask a question
Search
Close
Results 1101 - 1150 of about 1,710
  • Solved
  • Conditional formatting using dates in different cells Solved/Closed

    Hello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...

    rbarletta | Latest reply: rbarletta Mar 6, 2013
    2 replies
  • snding sms from excel sheet Solved/Closed

    Hello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...

    ramesh1974 | Latest reply: ramesh1974 Feb 28, 2013
    4 replies
  • Dropdown lists in excel 2007 Solved/Closed

    Hello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...

    Gouws | Latest reply: rizvisa1 Feb 27, 2013
    33 replies
  • Using Vlookup to return insted of 00/01/1900 Solved/Closed

    Hello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...

    Tom9o | Latest reply: tom9o Feb 24, 2013
    2 replies
  • Formula for Between to Dates Solved/Closed

    Hello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...

    Tom9o | Latest reply: Tom9o Feb 23, 2013
    2 replies
  • one cell will turn green when the two other cells match Solved/Closed

    Hello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...

    diestra123 | Latest reply: diestra123 Feb 20, 2013
    13 replies
  • =month(d2) Solved/Closed

    Hello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...

    ramlalmeena | Latest reply: ramlalmeena Feb 20, 2013
    5 replies
  • Macro to email picking up email address in one cell using lookup Solved/Closed

    Hi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...

    Tom9o | Latest reply: Tom9o Feb 19, 2013
    6 replies
  • returning value from column b in column c, in a cell ajacent to Solved/Closed

    Hello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...

    lawrencen | Latest reply: lawrencen Feb 19, 2013
    3 replies
  • Recovery my work and restart microsoft excel Solved/Closed

    Hello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...

    Rangie | Latest reply: Sridhar L Feb 18, 2013
    21 replies
  • compare data in seperate columns to find likely matches Solved/Closed

    Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...

    Spraoi | Latest reply: Spraoi Feb 18, 2013
    4 replies
  • No tool bars or address bar on my browser Solved/Closed

    Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...

    mandi | Latest reply: Paddy Feb 17, 2013
    175 replies
  • Code for macro that conditionally inserts rows Solved/Closed

    Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...

    bfleming | Latest reply: bfleming Feb 15, 2013
    4 replies
  • excel for mac opens all files on desktop Solved/Closed

    Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...

    emee | Latest reply: Dan Feb 14, 2013
    10 replies
  • Can't open Excel file Solved/Closed

    Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...

    duncan | Latest reply: yolooo Feb 13, 2013
    6 replies
  • IF statement errors and using multiple IF statements. Solved/Closed

    Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...

    jsav | Latest reply: jsav Feb 12, 2013
    3 replies
  • merging more cells into one cell Solved/Closed

    Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...

    marjean | Latest reply: markswan20 Feb 6, 2013
    10 replies
  • how can calculate days between twodates Solved/Closed

    Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...

    samruddhi naik | Latest reply: Kevin@Radstock Feb 6, 2013
    2 replies
  • Transferring data from one sheet to another Solved/Closed

    Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...

    cuffy70 | Latest reply: Cuffy70 Feb 3, 2013
    15 replies
  • Time calculations on a 24-hr clock Solved/Closed

    Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...

    Harters | Latest reply: Zohaib R Feb 2, 2013
    1 reply
  • Auto notify or mail when Excel sheet updated. Solved/Closed

    Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...

    Satya | Latest reply: cdb2013 Feb 1, 2013
    20 replies
  • Excel 2007 resetting cells to Date format Solved/Closed

    Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...

    ktech25 | Latest reply: Archit Badwe Jan 30, 2013
    11 replies
  • conditional Formatting Solved/Closed

    Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...

    Harters | Latest reply: Harters Jan 27, 2013
    4 replies
  • Simply cannot find an answer Solved/Closed

    Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...

    mona3 | Latest reply: mona3 Jan 25, 2013
    8 replies
  • VB issue with delete rows with specific values Solved/Closed

    Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...

    weenie | Latest reply: rizvisa1 Jan 23, 2013
    8 replies
  • Macro Help: Copy Data from a Range of Sheets to a Master Sheet Solved/Closed

    Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...

    supermate | Latest reply: supermate Jan 23, 2013
    7 replies
  • Tagalog Solved/Closed

    Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...

    flower_girl | Latest reply: flower_girl Jan 21, 2013
    2 replies
  • How to convert number into text in Excel Solved/Closed

    Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"

    boratechandu | Latest reply: Raj Jan 21, 2013
    9 replies
  • Adding a new entry into a list - Excel 2007 Solved/Closed

    Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...

    talana | Latest reply: confused Jan 18, 2013
    12 replies
  • VLOOKUP range question Solved/Closed

    Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...

    mjaybee | Latest reply: mjaybee Jan 17, 2013
    1 reply
  • adding the same action to every second line Solved/Closed

    hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...

    DG83 | Latest reply: Dg83 Jan 15, 2013
    8 replies
  • If, Then formula Solved/Closed

    Hello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...

    eaglewings1983 | Latest reply: eaglewings1983 Jan 14, 2013
    2 replies
  • convert date into month name Solved/Closed

    Hello, suppose date has mention 1/1/09 and no month name then how to get the month name

    danny | Latest reply: Manoj Jan 14, 2013
    20 replies
  • copy Excel 07 sheet to other & keep formulas? Solved/Closed

    Hello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...

    Linda | Latest reply: limitdydx Jan 13, 2013
    8 replies
  • excel - Active X Combobox, Selecting Sheets Solved/Closed

    Hi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...

    MRafik | Latest reply: rizvisa1 Jan 12, 2013
    5 replies
  • Many Columns return into fewer columns. Solved/Closed

    Hello, I have a spreadsheet that was exported from Survey Monkey. So the format cannot be changed. There can be data in any of 100 columns. Howeve...

    JW32 | Latest reply: Ambucias Jan 8, 2013
    15 replies
  • MSOffice 2010 Solved/Closed

    Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.

    SADETR9876 | Latest reply: rizvisa1 Jan 6, 2013
    1 reply
  • Short cut to merge cells Solved/Closed

    Hello, If there a short cut on the key board to merge cells in excel?

    rossdavid | Latest reply: Roopesh Dec 31, 2012
    17 replies
  • Formating Date Solved/Closed

    Hello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells date. ...

    shishacu | Latest reply: shishacu Dec 19, 2012
    9 replies
  • Match barcode between 2 sheets Solved/Closed

    Hello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...

    Ram | Latest reply: TrowaD Dec 13, 2012
    3 replies
  • How can I eliminate #VALUE in calculated cells Solved/Closed

    Hello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like to ...

    hwrychen | Latest reply: hwrychen Dec 9, 2012
    14 replies
  • Help with VBA Solved/Closed

    Hello, I'm trying to program a macro in Excell 2010. What I need it to do is look in a Range for the NotEmptyCells and change their property fro...

    amedotero | Latest reply: amedotero Dec 2, 2012
    2 replies
  • Copy data into next empty cell in new sheet Solved/Closed

    Hello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell shoul...

    nikwak | Latest reply: rizvisa1 Dec 1, 2012
    15 replies
  • Auto filter problem Solved/Closed

    Hello, when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further behind th...

    miteshmech87 | Latest reply: rizvisa1 Dec 1, 2012
    1 reply
  • Splitting list of names with formula - can you spot what's wrong Solved/Closed

    Hi everyone, I have a list of 1805 names which are gathered in a single column. These names range in length and "format" (e.g. John Smith, John C ...

    excelamateur | Latest reply: Zohaib R Nov 30, 2012
    4 replies
  • IF FUNCTION in excel Solved/Closed

    Hello, my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"") I want in place of ..........

    bkaromo | Latest reply: bkaromo Nov 30, 2012
    5 replies
  • Comparing two excel worksheets Solved/Closed

    Hello, I am trying to find an easy way to compare and extract data from two excel worksheets. This is the scenario.. I have an excel worksheet ...

    squirrel | Latest reply: lcouri Nov 28, 2012
    10 replies
  • Cut/Copy in VBA Solved/Closed

    Hello, I am fairly new to Macros but I am trying to write vba code in Excel 2003 version that will enable me to cut/copy a table from one worksh...

    Chamberlyn | Latest reply: Chamberlyn Nov 26, 2012
    3 replies
  • Covnvert numbers to single words Solved/Closed

    Hello, In excel 2010 i would like to convert numers to words i.e. 123.00 (one two three point zero zero) or 1006235.23 (one zero zero six two thre...

    naaur | Latest reply: venkat1926 Nov 23, 2012
    3 replies
  • Compare and copy data from one column to another Solved/Closed

    Hello, I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N in ...

    VBLearner | Latest reply: Zohaib R Nov 20, 2012
    4 replies