Office Software Forum

Ask a question
Results 5551 - 5600 of about 16,700
  • Excel place a vaue in a cell if a number is in a certain range Closed

    I need to setup ranges and place a number associated with-in that range. 150 300 450 600 750 900 This data is from column M. I need to b...

    rangebob | Excel | Latest reply: TrowaD Sep 23, 2014
    1 reply
  • Formula compare two different cells containing the scores of tes Closed

    Hello, I am trying to create a formula that will compare two different cells containing the scores of two tests. A student can only get PASS remark ...

    ayili | Excel | Latest reply: TrowaD Sep 23, 2014
    1 reply
  • Macro or VB Code Closed

    Hi, Input sheet will have data entered in Column A to F like name, emp id, date etc and I need this data to move in specific cells of a pre formatted...

    DSDaisy | Excel | Latest reply: DSDaisy Sep 23, 2014
    0 replies
  • static dates Closed

    Hello, I'm new to the abilities of excel and would appreciate any help. I'm trying to create a worksheet where when any data is entered in column A ...

    jaddiso | Excel | Latest reply: venkat1926 Sep 23, 2014
    1 reply
  • Microsoft Publisher Closed

    I tried to download Microsoft Publisher at least 10 times and I kept getting caught in some kind of loop to nowhere. What gives? Also, the downloa...

  • Referencing like numbers with different extensions Closed

    I'm not sure how to ask this, but I have multiple workbooks sent to me (new job-set up by someone else) with one of the sheets that I am to use in eac...

    denalraab | Excel | Latest reply: denalraab Sep 22, 2014
    0 replies
  • How to copy data based on criteria met Solved/Closed

    Help! I am totally stuck and this is probably a very simple fix. I have two sheets "Priority Accounts" and "ACN Dashboard". I need to move data i...

    katcrisjul | Excel | Latest reply: TrowaD Sep 22, 2014
    12 replies
  • Transferring data from one workbook to another Closed

    I want to copy data from one work book to another. I have got a data which will be entered by the user on their excel sheet in the specified format...

    innocentspy | Excel | Latest reply: innocentspy Sep 22, 2014
    0 replies
  • Need publisher Closed

    Question - You had "free" microsoft publisher but need a key to unlock. What does that mean and how much does it cost?

    Anonymous User | Office Software | Latest reply: Ambucias Sep 20, 2014
    1 reply
  • Having problems with Office Word 2010 can someone help? Solved/Closed

    Hello, I had to re-download Microsoft Office Home and Student 2010. Now whenever I save a Word document I winds up saving it as a WordPad document....

    Newbie56 | Word | Latest reply: Newbie56 Sep 19, 2014
    2 replies
  • Sum total numbers of the same date Closed

    I have a column with various birthdates 1953, 1983, etc. In the column there may be 10 1953's and 30 1983's. how do I get excel to sum up all the ce...

    brian | Excel | Latest reply: brian Sep 18, 2014
    0 replies
  • Excel formula Closed

    how to convert no in words. pls give me formula ex. 132507 Ans - one lac thirty two thousand five hundred & seven

    annasaheb | Excel | Latest reply: annasaheb Sep 18, 2014
    0 replies
  • SUM invoice number and invoice amount Closed

    I am looking to sum up multiple rows containing currency, while disregarding the text. I want to take the "amount" and subtract the multiple ...

    ShannonKAllard | Excel | Latest reply: ShannonKAllard Sep 17, 2014
    0 replies
  • stuck Closed

    Hello, I'm new to excel's advanced abilities. Is there a way to transfer the total of column E in sheet 1 to cell C3 in sheet 2? Configuratio...

    jaddiso | Excel | Latest reply: jaddiso Sep 17, 2014
    0 replies
  • Excel 2010 VBA Date Formula Solved/Closed

    Hi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...

    Oz_Dex | Excel | Latest reply: dave Sep 17, 2014
    3 replies
  • Create a Sales by Week Combined Report Closed

    Hi I want to create a report where I but in sales a use a Macro to insert a date and then insert all of the data in the worksheet into a seperate w...

    Mr S | Excel | Latest reply: Mr S Sep 17, 2014
    0 replies
  • Word document with Picture jpeg as background Closed

    Hello - when I covert a word document into a PDF file, the background changes into a tile effect format.I cannot change this by locking the picture f...

    Nidhideva | Word | Latest reply: xpcman Sep 16, 2014
    1 reply
  • Copy values in row to columns in spaces Solved/Closed

    Hello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...

    LearnVBA | Excel | Latest reply: LearnVBA Sep 16, 2014
    4 replies
  • Excel report Closed

    Hello, I create a seller report Worksheet 1--- I named it as Price list ... is a Data for my seller report that I set a code, name, points and ...

    Winndixie | Excel | Latest reply: Winndixie Sep 13, 2014
    0 replies
  • Copying data from one data sheet to another automatically excel Closed

    Dear Excel Gurus, What I want excel to do is, if a name put in a certain category on sheet one, then it automatically get copied into another sheet w...

    arropes | Excel | Latest reply: venkat1926 Sep 13, 2014
    3 replies
  • Adding comment to a Pivot Table using VBA Closed

    I have a requirement to put comment in a paticular pivot table column . The user can insert column or delete column ,the comment should dynamically p...

    ajita | Excel | Latest reply: ajita Sep 12, 2014
    0 replies
  • Formula to perform range of sums based on range of words Closed

    HI I am trying to find a formula that will basically: Check B2 to see if it contains the word "Fortnight" or "Month" or "Annual" and then "equal th...

    jesstopher | Excel | Latest reply: jesstopher Sep 12, 2014
    0 replies
  • Compare multiple spreadsheets + conditional pivot formatting Closed

    I have a list of 200 locations that are looking to renew their internet contract. I am asking 30 different vendors to provide their best available pri...

    NW | Excel | Latest reply: NW Sep 11, 2014
    0 replies
  • Tranferring Data from one spreadt to another Closed

    How do I transfer info, including the result of a formula and keep them updated from one spread sheet to another

    Johnny4567 | Excel | Latest reply: Johnny4567 Sep 11, 2014
    0 replies
  • Conditional Formatting Solved/Closed

    Suppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...

    tareqnaser95 | Excel | Latest reply: Osama_bb11 Sep 10, 2014
    2 replies
  • Movind data from one cell to another via a Macro Closed

    Hello all-- I am in need of someone's valued assistance. Here's the story: I have an excel spreadsheet that contains address data in Cell B6 & B...

    mpstockdale | Excel | Latest reply: venkat1926 Sep 10, 2014
    3 replies
  • REMOVING " FALSE " VALUE IN "IF&quo Closed

    Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C13="",IF((K13>="06:00"+0)*(K13="...

    dieselkhan | Excel | Latest reply: RayH Sep 9, 2014
    1 reply
  • Excel: differentiation by seller sales Closed

    Hello, I trying to create a sellers sales report. I set up total 6 worksheet for my seller sales report Worksheet 1 - named it Price list .....

    Winndixie | Office Software | Latest reply: Winndixie Sep 9, 2014
    0 replies
  • Excel 2010 code that clears content of a cell on open Closed

    Hi I am looking for code that clears content of a cell based on a value when the workbook opens. I have several sheets in the workbook with varied...

    jamhome | Excel | Latest reply: TrowaD Sep 9, 2014
    1 reply
  • Conditional formating of row based on other cells Closed

    Hello, I am trying to format cells A7-E7 based on the relationship between C6 and C5. Ideally they would be coloured on a scale between green and y...

    Bitbull | Excel | Latest reply: TrowaD Sep 9, 2014
    1 reply
  • Move (list) data from one Excel 2010 tab to a new summary tab Closed

    Hello, Would someone be able to advise if there's an automatic way of moving data from multiple Excel 2010 tabs onto a summary tab please? I wor...

  • Specific data from one worbook to another (Excel 2010). Solved/Closed

    Hello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...

    vcoolio | Excel | Latest reply: vcoolio Sep 9, 2014
    29 replies
  • If then formula using a date Closed

    Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value r...

    chashare | Excel | Latest reply: Mazzaropi Sep 8, 2014
    1 reply
  • excel 2007 custom filter problem Solved/Closed

    Hello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...

    h4 | Excel | Latest reply: mark Sep 8, 2014
    6 replies
  • Macro to Insert Multiple Images to Multiple Sheet of a Excel Closed

    Hello Everyone, Greetings to All. I have some Issues in the below Macro. My intention is to Copy/Insert the multiple Images in a folder that I se...

    Nimalan_Dude | Excel | Latest reply: Nimalan_Dude Sep 8, 2014
    0 replies
  • Multiple columns using countifs Closed

    I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N ...

    jclegg42002 | Excel | Latest reply: venkat1926 Sep 7, 2014
    1 reply
  • VBA/Formulas for Repeating Values by Cell Value, w/Offset Closed

    Hello, I have a pretty complex little thing going on, but I'm having trouble getting through the next part. Using VBA, two lists are generated ...

    crochenemg | Excel | Latest reply: crochenemg Sep 5, 2014
    0 replies
  • Making date appear on master copy Closed

    Could anyone help with a formula for the date to appear on my Master copy of Items sold and purchased. i.e .A. .B. ...

    Bigmick | Excel | Latest reply: Bigmick Sep 5, 2014
    0 replies
  • Comparing Excel Columns - Help ASAP Please! Closed

    Hello, I need help, please! I have two worksheets (C & Q). Each worksheet contains four columns, each column has different information(A=Date, B=Mis...

    Lori | Excel | Latest reply: Gary Myers Sep 4, 2014
    2 replies
  • Microsoft Office product key Solved/Closed

    what is the product key of the app i downloaded?

    erinkrizel | Office Software | Latest reply: Ambucias Sep 4, 2014
    6 replies
  • run VBA automatically when criteria is met Closed

    I want to be able to run a macro automatically when criteria is met.. If any cell in column A is change to "re-let" run "rowformat" macro can an...

    Debs269 | Excel | Latest reply: venkat1926 Sep 4, 2014
    1 reply

    The exchange email inbox, which is available for me alows a max of 920 MB message storage space. When the mailbox reaches 720 MB, an automatic pop up ...

    datta_vg007 | Outlook | Latest reply: datta_vg007 Sep 3, 2014
    2 replies
  • time calculation Solved/Closed

    Hello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...

    Osama_bb11 | Excel | Latest reply: Osama_bb11 Sep 3, 2014
    2 replies
  • Macro that copies certain cells Closed

    Hello All , I need a Macro that copies certain cells , from other workbooks in a folder . it should open the first workbook, copy 3 cells , past...

    SAG123 | Excel | Latest reply: SAG123 Sep 3, 2014
    0 replies
  • Automatic update of date from one sheet to another Closed

    Hi I need to make a form that will update any written information from one spreadsheet to another automatically. E.g. I have one work-folder wi...

    loegborg | Excel | Latest reply: loegborg Sep 3, 2014
    0 replies
  • How to compare 2 sheets in Excel Closed

    Hi, Could you please let me know how to compare data in 2 work sheets. I have the data in sheet1 and sheet2. I need to test whether the data in t...

    raj4team | Excel | Latest reply: raj4team Sep 3, 2014
    0 replies
  • Conversion of multiple column into single column Closed

    Hello, I have a date set in the following format 1 3 5 7 2 4 6 8 I want this in the format 1 2 3 4 5 6 7 8 Please help m...

    TiwariUjjwal | Excel | Latest reply: aamirsq Sep 2, 2014
    1 reply
  • 4 conditional formats Closed

    I am attempting to add 4 conditional formats; First in red the 'cancel' - already done Secondly all things that complete on today's date in blue - d...

    Morganatic | Excel | Latest reply: aamirsq Sep 2, 2014
    1 reply
  • copy data skipping blank cell Closed

    Hi, 1. How can i copy my my excel sheet1 (range B2:BJ800) data into sheet 2 skipping blanks cells. All want all data should be on sheet 2, colum...

    aamirsq | Excel | Latest reply: aamirsq Sep 2, 2014
    0 replies
  • Copying cells Closed

    My question is similar to those above. We have rental properties. When a guest reserves I enter the data in one sheet (let's call it Sheet 2) that I...

    jaubin | Excel | Latest reply: jaubin Sep 1, 2014
    0 replies