Office Software Forum - solved topics

Ask a question
Results 301 - 350 of about 2,640
  • Solved
  • IF function in Excel error Solved/Closed

    Hello, anyone can tell me where the error Is. =IF(G:G>="0:05", 0:30Min, IF(G:G>="0:20",1:30hrs, IF(G:G="0:00",0:00hrs , 4:00hrs))) * * ...

    AngelaTyq | Excel | Latest reply: AngelaTyq Dec 12, 2017
    3 replies
  • Product key of Office 2010 Solved/Closed

    I don't K now product key of office 2010 please send me this key Regards Pardeep Gur

    PardeepGur | Office Software | Latest reply: Ambucias Dec 8, 2017
    2 replies
  • Conditional formatting with multiple rules and blank text cells Solved/Closed

    Hi, I wonder if someone would be able to help me with this. This is probably really simple, but I can't get it to work. I need excel to change a c...

    PaiviM | Excel | Latest reply: PaiviM Dec 6, 2017
    6 replies
  • Setting up Excel formula Solved/Closed

    Hello, I need some help with the excel formulas I have new taxation laws that apply my organization from January. The current taxes are 10%...

    Carlo1991 | Excel | Latest reply: ac3mark Dec 4, 2017
    7 replies
  • Post it digital notes Solved/Closed

    Everytime I try to download Post it Digital Notes I get the 404 error. What do I need to do?

  • Where can I download a free Word document to PDF converter Solved/Closed

    looking to download a free word to PDF converter

    watzi | Word | Latest reply: watzi Dec 3, 2017
    2 replies
  • Comparing data between two excel sheets Solved/Closed

    Hello, I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "upd...

    Annie | Excel | Latest reply: dubla89 Dec 1, 2017
    12 replies
  • Corrupt Powerpoint file, the file extension does not match the I Solved/Closed

    Hello, I have several PowerPoint presentations that I can't open them now it says " file may be corrupted when use PowerPoint or expansion file ma...

    singularity83 | PowerPoint | Latest reply: xpcman Nov 29, 2017
    1 reply
  • How to create serial numbers Solved/Closed

    Hello, I have an excel format shows different values of schedule of correspondence and some of the mails are gone to different addresses and the ma...

  • Formatting cell Solved/Closed

    Hello, I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here so...

    sheeba | Excel | Latest reply: sheeba Nov 21, 2017
    3 replies
  • Drop down look up Solved/Closed

    Hello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...

    nminnis | Excel | Latest reply: vcoolio Nov 21, 2017
    14 replies
  • Automatically update master worksheet from other worksheets Solved/Closed

    Okay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...

    Saktivel | Excel | Latest reply: vcoolio Nov 21, 2017
    18 replies
  • Help- conditional cell formatting Solved/Closed

    Hello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...

    campbellty10 | Excel | Latest reply: campbellty10 Nov 21, 2017
    2 replies
  • Make a macro run when data entered in a cell Solved/Closed

    Hello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...

    SandsB | Excel | Latest reply: Rajiv Nov 15, 2017
    36 replies
  • Word 2010 showing dots instead of spaces Solved/Closed

    Hello, when I press space tab in the keyboard, a dot is printed in the Microsoft word 2010. How can I fix this problem? faithfully you Con...

    mehdiei | Word | Latest reply: Hugh Nov 14, 2017
    10 replies
  • Worksheet_SelectionChange event not working Solved/Closed

    Hello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...

    Omi Kat | Excel | Latest reply: Omi Kat Nov 13, 2017
    2 replies
  • Working out the difference in times between two columns Solved/Closed

    I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...

    sailingdemon | Excel | Latest reply: sailingdemon Nov 12, 2017
    5 replies
  • SKU011.CAB Solved/Closed

    when I go to open ms word or ms excel computer ask for file. I have no cd of office 2003. please help

  • How to copy columns to a specific column header and repeat? Solved/Closed

    Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...

    stylus33 | Excel | Latest reply: stylus33 Nov 10, 2017
    2 replies
  • Changing format of date in Excel Solved/Closed

    Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...

    drizn | Excel | Latest reply: Dnbaugh Nov 9, 2017
    56 replies
  • Outlook 2010 configure for Gmail Solved/Closed

    I have created an account and tried configuring through Outlook 2010. Though the test message is successful for sending and receiving, outlook is able...

    MadanKrishna... | Outlook | Latest reply: Ambucias Nov 8, 2017
    10 replies
  • Copying formula by changing only one rule. Solved/Closed

    Hello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...

    shan_asa | Excel | Latest reply: shan_asa Nov 7, 2017
    2 replies
  • Can't open documents with a W. Solved/Closed

    In my documents, I have some items with PDF and some with a W. When I try to open the ones with a W, I am asked to sign up with Word. How can I open t...

    Bob.C | Word | Latest reply: Bob.C Nov 1, 2017
    3 replies
  • How to compare a range of data in Excel? Solved/Closed

    Dear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...

    shan_asa | Excel | Latest reply: shan_asa Oct 29, 2017
    4 replies
  • Ms Visio setup free download Solved/Closed

    i got a little challeng dowenloading free Ms visio setup could u send me please

    belaynew | Office Software | Latest reply: huda-rezk Oct 28, 2017
    2 replies
  • VBA for copying from data entry sheet to corresponding sheets Solved/Closed

    Hi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...

    OMCHABRIA | Excel | Latest reply: TrowaD Oct 24, 2017
    7 replies
  • Copy Rows from one sheet to others based on a condition Solved/Closed

    Hello, I have a workbook for our teams budget that has 1 master sheet with 28 columns. The master sheet will be updated with more rows often (addi...

    EmrsnMktgAnyst | Office Software | Latest reply: TrowaD Oct 19, 2017
    6 replies
  • Delete or insert rows in a workbook Solved/Closed

    Hello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...

    ehsan | Excel | Latest reply: TrowaD Oct 12, 2017
    1 reply
  • How to use a macro to check data in 2 work sheets Solved/Closed

    Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...

    MadhaviLakshmi | Excel | Latest reply: ac3mark Oct 9, 2017
    1 reply
  • Use Macros to copy worksheet and rename using a list of names Solved/Closed

    Hi all, I'm an excel novice and hoping for help. I need to write a macro to 1. Copy worksheet "Alstromeria" and 2. Rename worksheet to the name...

    eswhi | Excel | Latest reply: eswhi Oct 7, 2017
    0 replies
  • How to generate a STATIC unique identifier for each Excel row Solved/Closed

    Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...

    Musicar | Excel | Latest reply: ac3mark Oct 6, 2017
    4 replies
  • Two IF forumlas inside an IF formula Solved/Closed

    Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...

    AdrianHowland | Excel | Latest reply: Mazzaropi Oct 6, 2017
    4 replies
  • Autopopulating multiple sheets from one main sheet Solved/Closed

    Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...

    Mikey | Excel | Latest reply: TrowaD Oct 5, 2017
    45 replies
  • How to sum a number from a range of cells, based on value Solved/Closed

    Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....

    cathcam | Excel | Latest reply: TrowaD Oct 5, 2017
    3 replies
  • Rank of numbers between specified range Solved/Closed

    Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...

    talent.anand | Excel | Latest reply: TrowaD Oct 2, 2017
    3 replies
  • Formatting cells based on certain criteria Solved/Closed

    I want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...

    sailingdemon | Excel | Latest reply: sailingdemon Sep 29, 2017
    7 replies
  • SUM IFS function Solved/Closed

    Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...

    dshaviv | Excel | Latest reply: dshaviv Sep 25, 2017
    2 replies
  • Excel Macro: Copy formulas across worksheets Solved/Closed

    So first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...

    Bobo | Excel | Latest reply: OCG Sep 24, 2017
    12 replies
  • Arrow keys scrolling in Excel Solved/Closed

    Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not...

    Deb | Excel | Latest reply: Upthewall Sep 20, 2017
    24 replies
  • Excel work sheet not copy to another sheet Solved/Closed

    Hello, System Configuration: Windows / Firefox 52.0 I am =DGET(Sheet1!1:156,"NAME",$A$1:E$2) but it is not work

    a g doddamani | Excel | Latest reply: a g doddamani Sep 20, 2017
    0 replies
  • Help with formula please Solved/Closed

    Hi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...

    CB7373 | Excel | Latest reply: CB7373 Sep 19, 2017
    3 replies
  • Subtract last column from first column Solved/Closed

    Hello, I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last colu...

    Gaurav Kumar | Excel | Latest reply: vcoolio Sep 18, 2017
    3 replies
  • Need to calculate monthly avg and yearly miles from odometer Solved/Closed

    Good afternoon, I am having an issue figuring out how to get excel to calculate the yearly mileage and monthly avg by just monthly odometer reading...

    jamishore | Excel | Latest reply: vcoolio Sep 13, 2017
    5 replies
  • Auto-populate info. from master sheet to multiple sheets Solved/Closed

    Hi, I have been working on an excel sheet for the past month and have not found a solution that would do what I need it to do. I'm sure there have ...

    kvil | Excel | Latest reply: TrowaD Sep 12, 2017
    15 replies
  • Find word within cell & put value in adjacent Solved/Closed

    Hello, I'd like to scan a column for a certain word (e.g. "apple") and put a code (e.g. "A") on the cell next to it each time it finds it. In this ...

    Mr.G | Word | Latest reply: BogelBot Sep 9, 2017
    39 replies
  • Update data from one sheet to the next. Solved/Closed

    The macro I want just takes data from one tab and adds it to another like an update. i suspect that the macro will take some time to make as the updat...

    raymondald | Excel | Latest reply: ac3mark Sep 5, 2017
    3 replies
  • Conditional formating - apply on more cells Solved/Closed

    Hello, i'm not so familiar with conditional formatting, so I would like to ask something: I'm making a doc where Column A has number values, column ...

    Biljana | Excel | Latest reply: Raj Aug 30, 2017
    32 replies
  • How to change the date format in Excel 2007 Solved/Closed

    Hello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- monday,1dec.2008 plz. answer me soon....

    PANKAJ | Excel | Latest reply: Praveen Aug 26, 2017
    22 replies
  • Search for input criteria, return designated cells. Solved/Closed

    Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...

    crlarus | Excel | Latest reply: vcoolio Aug 19, 2017
    12 replies
  • Copying dates to another worksheet. Solved/Closed

    Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...

    Scencea | Excel | Latest reply: vcoolio Aug 17, 2017
    12 replies