Office Software Forum

Ask a question
Search
Close
Results 5551 - 5600 of about 16,600
  • 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
  • HOW TO RECOVER SOFT DELETED EMAILS ? Closed

    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
  • Duplicating Macro Closed

    Hi I currently have the below macro to duplicate rows for me but I want it to show the data in 2 columns instead of nderneath each other. EG OV...

    Ceri88 | Excel | Latest reply: TrowaD Sep 1, 2014
    7 replies
  • VBA to copy and paste between workbooks Closed

    I need a VBA to copy selected cells and then paste them into a pre-existing workbook. So it will need to open that workbook and then paste. For ex...

    Kauket24 | Excel | Latest reply: Kauket24 Sep 1, 2014
    0 replies
  • How to convert number into text in excel Closed

    Hello, Thanks for the nice solution. I have a problem and that's what should I do if the number is bigger than 999,999,999? Configuration: Wi...

    memo.1361 | Excel | Latest reply: Kulmalik Aug 31, 2014
    1 reply
  • formula that i can get a total for D7, if D7= D4 + (C6*D7) Solved/Closed

    $1,613.00 (Cell D4) (C6) Hours ___ $175.00 (D6) TOTAL (D7) Can any one tell me a formula that i can get a total for D7, if D7= D4 + (C...

    dmadden | Excel | Latest reply: dmadden Aug 29, 2014
    2 replies
  • Simple IF function Closed

    Hello, I have a column reading random dates (dd/mm/yy) and the column next to it has to read "Y" or "N" depending on whether the date is before or...

    lubs_sidd | Excel | Latest reply: rayh Aug 28, 2014
    2 replies
  • How to copy data in cell ranges to another worksheet "if" Closed

    I have a source worksheet that is named "AVDistribution" and has several columns and rows of data and I have additional worksheets in the same workboo...

    Ydls | Excel | Latest reply: ac3mark Aug 28, 2014
    4 replies
  • conditional formatting between Closed

    Hi Ppl have conditional formatted a range of cells with numbers, to turn green if numbers are BETWEEN numbers in Column A and Column B but Proble...

    Bennett4 | Excel | Latest reply: venkat1926 Aug 27, 2014
    1 reply
  • Need Power Point for dummies Closed

    Greetings from old school new freshman with power point presentation due in 2 weeks....yikes. what's power point? Thank You!!! I will let you know ...

    Icmafnforreal | PowerPoint | Latest reply: johnebadbak74 Aug 27, 2014
    3 replies
  • makin a PowerPoint Closed

    Hello, how to make a best PowerPoint video Configuration: Windows 8 / Chrome 34.0.1847.116

    skiruba | PowerPoint | Latest reply: denissenco Aug 27, 2014
    3 replies
  • microsoft office Closed

    how to use power point?

    Mr.vhieyephi | PowerPoint | Latest reply: denissenco Aug 27, 2014
    2 replies
  • auto copying in excel Closed

    Suppose I have account in say 5 different banks and I have made one excel sheet for each showing date wise transactions. The sheet contains the follow...

    GoutamG | Excel | Latest reply: venkat1926 Aug 25, 2014
    1 reply
  • Comparing unsorted data across separate files Closed

    I need an automated way to compare the 2 sheets to make sure no equipment gets missed for ordering. I have to compare an order for equipment against ...

    TechNotAAnalyst | Excel | Latest reply: Mazzaropi Aug 23, 2014
    1 reply
  • Calculating a distance within an interval in a cell with text Closed

    I have a cell that contains words and numbers in the following format: Dig (30'-40', 50'-65'), Fill (70'-90') What I'd like to figure out is a f...

    ohai309 | Excel | Latest reply: Mazzaropi Aug 22, 2014
    3 replies
  • If -Then formula needed please... before I head to the roof Solved/Closed

    Using Excel 2007, I need a formula to do the following: if the date shown in a cell is 1/31/14, display 'monthly activity - january, or if the date...

    hotpeppermom | Excel | Latest reply: hotpeppermom Aug 22, 2014
    4 replies
  • Extraction of Excel data by using an Excel column parameter Solved/Closed

    Hi, I have a problem in extracting information from an Excel Sheet 1 (entire database), by using an Excel column parameter (Model No) in Sheet 2. S...

    strikewind | Excel | Latest reply: strikewind Aug 21, 2014
    5 replies
  • conditional formating Closed

    I am working on a spreadsheet that tracks vehicles preventive maintenance. I would like the Mileage Last PM was performed (A1) to turn red when th...

    ROB_L | Excel | Latest reply: Mazzaropi Aug 21, 2014
    1 reply
  • Insert number into cell based on other cells containing x Closed

    I am setting up a spreadsheet tracker for the school. I want J2 to auto fill a price depending on whether C2-G2 have an X. BUT, depending on which c...

    gbroley | Excel | Latest reply: Mazzaropi Aug 21, 2014
    1 reply
  • How to convert numeric to word in excel Closed

    How to convert numeric to word in excel

    boneydey | Excel | Latest reply: ac3mark Aug 20, 2014
    1 reply
  • create a formula such that each cell in a given column auto Closed

    Hello, Is there a way to create a formula such that each cell in a given column automatically calculates a specific percentage of the value in the...

    shs1954 | Excel | Latest reply: ExPatBrit Aug 19, 2014
    1 reply
  • highlight entries one list if they appear in an associated list Closed

    I wish to highlight entries in one list if they appear in an associated list: I chose to do this by using a modified COUNTIF function, which I had te...

    ExPatBrit | Excel | Latest reply: ExPatBrit Aug 19, 2014
    0 replies
  • Excel Golf Skins Sheet Solved/Closed

    I need a micro that will highlight the cell with the lowest unique value in each individual column. It would not highlight anything if there were m...

    agw2010 | Excel | Latest reply: agw2010 Aug 18, 2014
    2 replies
  • Need to merge data logically Closed

    Hello, I want Macro for below example, SUBACC STMTPG OPBALDT OPBALTP CLBALDT CLBALTP 123abc 1 04-07-2014 04-07-2014 123abc 1 05-07-2014 05...

    Mandy | Excel | Latest reply: TrowaD Aug 18, 2014
    1 reply
  • Help to debug this sentence for me please ? Closed

    Hi, Is there any way I can debug the sentence highlighted in yellow ? Thanks!

    SherlynPeh | Excel | Latest reply: TrowaD Aug 18, 2014
    1 reply