Office Software Forum

Ask a question
Search
Close
Results 4151 - 4200 of about 16,600
  • Macro that kills a macro when a new workbook is opened. Solved/Closed

    Hi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...

    JStill | Excel | Latest reply: ac3mark Aug 17, 2015
    5 replies
  • Comparing 2 worksheets & extracting matched and unmatched data. Closed

    Hey guys, I'm trying to compare one column in a worksheet with another column in another worksheet and also at the same time, extract matched value...

    wolfblader | Excel | Latest reply: wolfblader Aug 17, 2015
    0 replies
  • convert text paragraph to excel columns Closed

    Hello, i have few pdf files that needed to be entered to excel columns. i have worked on a html software at my last work that could convert it to ...

    vivek | Excel | Latest reply: vivek Aug 17, 2015
    0 replies
  • If Or famula for finding word in a sentance Closed

    Hello, Can anybody help to find ans for below question if sentances are " HEDgroup people are in bench" "evals making count" "nothing in MIL" ...

    Ammu | Excel | Latest reply: Ammu Aug 17, 2015
    0 replies
  • How to open OST files? Closed

    Hi, my Exchange Server not work. I need to open my ost file. Is it possible to do this using the Outlook? Files are larger than, which stores a lot of...

    ethangoodwin | Outlook | Latest reply: Ambucias Aug 16, 2015
    1 reply
  • Corrupt Pptx files. Need to repair them. Please help! Closed

    Hey guys, there is big mess over here. Here I quote: I made some presentation files for promoting our new business. I showed them to my boss. She wa...

    kayones867 | PowerPoint | Latest reply: Ambucias Aug 16, 2015
    1 reply
  • Exchange 2007 Restore Mailbox Data Deleting Closed

    Hello, Summary: Trying to restore an old Exchange 2007 Mailbox, the restore seems to work as I see data in Outlook however as soon as the restore ...

    joshuareeves | Outlook | Latest reply: joshuareeves Aug 16, 2015
    2 replies
  • exchange .edb corrupt Solved/Closed

    hi all, Had an exchange server go down, got the exchange .edb files only to find its corrupt, tried to use eseutil.exe to repair the file but when ...

    OsbornMorgan | Office Software | Latest reply: FrancisHancock Aug 14, 2015
    1 reply
  • Nested If statement... Closed

    Hello, Can anyone find any errors with this formula. I know it will never return a "N" because the vlookup will terminate anything that doesn't m...

    Andy | Excel | Latest reply: M.Hanzla Aug 14, 2015
    2 replies
  • auto fill Closed

    Hello, im looking for a formula when i add a"XXXX" word to a cell K7 it takes the value of another F7 and auto populates to another H7. so "WOR...

    paulie1307 | Excel | Latest reply: Mazzaropi Aug 13, 2015
    1 reply
  • Excel, how to use macros and conditioning. Solved/Closed

    Hello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...

    Matt | Excel | Latest reply: Matt Aug 13, 2015
    2 replies
  • Microsoft Excel Conditional Formatting Closed

    Hi, I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or "Riverda...

    bunnyboy123 | Excel | Latest reply: Mazzaropi Aug 13, 2015
    3 replies
  • Input Mask Closed

    Dear Sir/Maddom. Hope to be fine and doing well. first of all i am thanks from your services in the filed of IT. I am working in Telecom Comp...

    babakarkhail | Excel | Latest reply: TrowaD Aug 13, 2015
    1 reply
  • Transfer Comments Closed

    Hello, Is it possible to transfer comments from one cell to another on a different sheet or workbook? I am able to transfer the contents of the ce...

    Danny1235 | Excel | Latest reply: TrowaD Aug 13, 2015
    1 reply
  • Using 'rept' inside 'If' Solved/Closed

    Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...

    dinu | Excel | Latest reply: dinu Aug 13, 2015
    2 replies
  • Conditional formatting dates Closed

    I have three date columns in a sheet, order date, approved date and received date. I want the ordered date to be green but going red if not approved ...

    Needtoknowit | Excel | Latest reply: Needtoknowit Aug 12, 2015
    0 replies
  • date formula Solved/Closed

    Hello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...

    judy | Excel | Latest reply: Judy Aug 12, 2015
    9 replies
  • How to enter a row when an "if condition" is met Closed

    Hello, Would like to know how to add a row in a different sheet when an "if condition" is met. To illustrate, I have the following columsn in s...

    El Magnifico | Excel | Latest reply: vcoolio Aug 12, 2015
    1 reply
  • compare two sheets and highlight the difference Closed

    Hello, In sheet 1 i have some 10 rows in sorted order for eg say like it has two Sheet 1 Name Age Sam 9 Teena 10 Sheet 2 Nam...

    ammu | Excel | Latest reply: ammu Aug 12, 2015
    0 replies
  • Compare Worksheets return third result Closed

    I Have two worksheets a) Warehouses Combined - this list all codes a to z b) Suppliers - list all suppliers with discount per supplier. Warehouse...

    AndesGillion | Excel | Latest reply: xpcman Aug 11, 2015
    1 reply
  • Populating companies sheets from mastersheet Closed

    Hello, Could someone help please. I have a excel file with a master sheet which contains invoice companies. The are alphabetical ordered. Bu...

    Alin | Excel | Latest reply: TrowaD Aug 11, 2015
    1 reply
  • Transferring data between sheets with conditions Closed

    Hello, I have a daily driver routing excel sheet that has driver fees. The sheet is for the month listed daily. I am trying to figure out how to e...

    kwardrop | Excel | Latest reply: kwardrop Aug 10, 2015
    0 replies
  • assigning values to a row Closed

    Hello, I have a row with descriptions in the adjacent cell for example a1 sam b1 happy a2 Jessica b2 sad a3 max b3 angry then in row c it...

    cooldave1981 | Excel | Latest reply: Mazzaropi Aug 10, 2015
    1 reply
  • Outlook 2003 pptx attachment won't open Solved/Closed

    Hello, I have Outlook 2003 and was emailed a pptx attachment. When I double click it, it always asks to save instead of opening it. Docx files ope...

    van_veen | PowerPoint | Latest reply: van_veen Aug 10, 2015
    3 replies
  • fetch data Solved/Closed

    fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...

    khroliya | Excel | Latest reply: vcoolio Aug 10, 2015
    3 replies
  • Need to find end row in Col which has data & format the col Closed

    Need to check when the row is finished - by checking whether data is there in the cell or not and format entire column. Example Col A.. has data upto...

    Idu_Moses | Excel | Latest reply: Idu_Moses Aug 10, 2015
    0 replies
  • problem with open doc files in ms Solved/Closed

    Hello, I have several .doc files with .xls files (both 97-2003 versions) embedded. When I open the .doc file in Word 2010 and try to open the .xls...

    mennonepelle | Office Software | Latest reply: baruraf2015 Aug 9, 2015
    2 replies
  • When inserting picture to the email, it looses clarity Closed

    Hi, whenever I insert picture into the body of the email, the pictures loses its clarity. I always create images at 300dpi. could you please suggest h...

    sanamkhan27 | Outlook | Latest reply: sanamkhan27 Aug 8, 2015
    0 replies
  • Comparing 3 columns Closed

    Hello, Please help me get the correct formula for this: RETURN RED IF D1 lower than D2 and lower than D3 ...

    Jose D Chiong | Excel | Latest reply: Mazzaropi Aug 8, 2015
    3 replies
  • how to populate data from master sheet to different sheets Closed

    Hello, Configuration: Windows XP / Chrome 44.0.2403.130 i have a master sheet Q and i want to auto populate some companies name of sheet Q t...

    kksharma | Excel | Latest reply: kksharma Aug 8, 2015
    0 replies
  • Comparing two columns Closed

    Hello, I want to know the formula for the below If column A is having list of cities eg Chennai and column b is having list with extension eg ...

    Nirmal | Excel | Latest reply: Nirmal Aug 8, 2015
    0 replies
  • Problem in comparing rows Closed

    Hello, I want to compare two adjacent rows and highlight the difference; then I want to apply this to entire worksheet so that all adjacent rows (...

    VB | Excel | Latest reply: venkat1926 Aug 8, 2015
    1 reply
  • Number convert in whole excel sheet Closed

    Hello, This formula only works in a specified excel file. I want it to be worked in whole excel file. Like when even I'll open an excel file, it wil...

  • multiple if and functoions Closed

    Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell ...

    Cato | Excel | Latest reply: Mazzaropi Aug 7, 2015
    1 reply
  • Stop Outlook from transfering emails from my Solved/Closed

    Hello, Everytime I open my outlook it transfres all of my comcast emails to outlook. How do I stop this? Thanks, Harri

    Harri | Outlook | Latest reply: Bugs bunny Aug 7, 2015
    19 replies
  • Conditional formatting Closed

    Hello, I need dates to be highlighted if over 6 months but to clear again if marked Y (completed) in another cell? I can obviously get the 6 month d...

    Taffy | Excel | Latest reply: Taffy Aug 7, 2015
    0 replies
  • Recover paper term 2 year 4 english Closed

    Hello, i edited my paper on email and click on to save but when i log out and try to open it again i found that it was lost. please help me to find...

    tupou | Word | Latest reply: Ambucias Aug 6, 2015
    1 reply
  • Find text and add two different texts next to cell Closed

    Hello, I have a sheet with contractor names(sheet1) on A1 and I have a separate sheet (sheet2) with contractor names (A1), personnel assigned to t...

    Vega | Excel | Latest reply: TrowaD Aug 6, 2015
    1 reply
  • Percentage Closed

    Hello, I have Rs. 1.3 million divided to 35 peoples. Sô you can help me, i mean 1st prize is high, 2nd low prize, 3rd is more low. Please guide me f...

    Faisal | Excel | Latest reply: TrowaD Aug 6, 2015
    1 reply
  • Conditional Format Restrictions Closed

    Hi. Need a little help with conditional formatting. Basically need to build in a excel spreadsheet a rule where conditoinal formatting will pick up...

    Mike | Excel | Latest reply: TrowaD Aug 6, 2015
    3 replies
  • Conditional formatting based text in another cell Closed

    Hello, I want to conditionally format the cells in one column (in my case) D, if the cell in the same row but in column K contains one particular ...

    y88y | Excel | Latest reply: y88y Aug 5, 2015
    2 replies
  • Creating New Spreadsheet based on column - Macro Help! Closed

    Hello, This is my first time trying to use a Macro, so please bear with me. Anywho, I am using Excel 2007, if that helps. I have a spreadsheet th...

    renntek07 | Excel | Latest reply: venkat1926 Aug 5, 2015
    9 replies
  • Match cells in which only certain strings of text are the equal Closed

    Hi everyone, I'm trying to find a way to use excel to match two columns of information. The problem is that those two columns do not contain the e...

    James The Rock | Excel | Latest reply: James The Rock Aug 4, 2015
    0 replies
  • Matching cells in which only certain strings of text are equal Closed

    Hi everyone, I'm trying to find a way to use excel to match two columns of information. The problem is that those two columns do not contain the...

    James The Rock | Excel | Latest reply: James The Rock Aug 4, 2015
    0 replies
  • change password OpenOffice Calc Closed

    Hi, i have a password on my openoffice calc document, but i need to change it, can find help on how to set one but not to change it?? Thanks

  • Inporting images from folder to excel using a cell as reference Closed

    Hello, I'm trying to produce an excel sheet where I display several images present on a specific folder in my computer. I'll have a reference c...

    Jbistro | Excel | Latest reply: Jbistro Aug 3, 2015
    0 replies
  • Date formate in formula bar Closed

    hi Tried to change the date format in the formula bar but its not taking for ex: 29/05/2015 is showing as MM/DD/YYYY in formula bar but in sheet its ...

    phebbar | Excel | Latest reply: TrowaD Aug 3, 2015
    1 reply
  • Help with returning multiple values Closed

    Hi, I have 3 columns in Excel. I need to search value from Column A in Column B and return value from Column C. For example I need to find 004 f...

    swampy1977 | Excel | Latest reply: TrowaD Aug 3, 2015
    3 replies
  • looking up and adding the values fixing different criteria Closed

    Hello, "A column" the name of items such as Tiles, Pipes, Tables etc (many times repeated) "B Column" the size of each item such as 10mm, 20mm, 50m...

    Mizan | Excel | Latest reply: M.Hanzla Aug 3, 2015
    1 reply
  • Comparing two columns with string Closed

    I have two columns :A (shorter list) and B (longer list). Is there a way to find all instances of B which may have any string from A? For e.g. COLU...

    apbbsr | Excel | Latest reply: M.Hanzla Aug 2, 2015
    7 replies