Office Software Forum - solved topics

Ask a question
Results 801 - 850 of about 2,640
  • Solved
  • Accounts data requires automatic analysis Solved/Closed

    Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...

    249ccjames | Excel | Latest reply: 249ccjames Sep 2, 2015
    2 replies
  • custom sorting & calculating average based position Solved/Closed

    please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...

    oluwaridenawa | Excel | Latest reply: oluwaridenawa Aug 31, 2015
    2 replies
  • search word from list, match it copy values next to it Solved/Closed

    I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...

    haris1989 | Excel | Latest reply: haris1989 Aug 31, 2015
    2 replies
  • Concatonating within commands??? Solved/Closed

    Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...

    BrianGreen | Excel | Latest reply: BrianGreen Aug 21, 2015
    4 replies
  • impact font Solved/Closed

    hello, is the impact font included in windows 8.1. Configuration: Windows XP / Firefox 40.0

    duane | Open Office | Latest reply: xpcman Aug 20, 2015
    1 reply
  • Comparing columns and returning value Solved/Closed

    Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...

    Thakkudu | Excel | Latest reply: TrowaD Aug 20, 2015
    14 replies
  • Word "False" kept on Appearing? =IF function Solved/Closed

    =IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...

    InfoTech04 | Excel | Latest reply: InfoTech04 Aug 19, 2015
    2 replies
  • sumproduct based on relative cell Solved/Closed

    Hello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...

    Brian | Excel | Latest reply: BrianP Aug 19, 2015
    2 replies
  • stack range of data to next empty row in other sheet Solved/Closed

    Hello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...

    milli | Excel | Latest reply: Milli Aug 18, 2015
    4 replies
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Need VBA code to create loops Please Solved/Closed

    I have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...

    Jan | Excel | Latest reply: FaizanRoshan88 Jul 31, 2015
    6 replies
  • vba Solved/Closed

    I want to append the month name at the end of the tab names in my workbook I have 86 tabs which are named by employee name and every month I want to ...

    looneybin | Excel | Latest reply: looneybin Jul 30, 2015
    2 replies
  • Formatting cells Solved/Closed

    I'm stuck.... I am creating an invoice of sorts for a company who deals in different currencies. Q1. I have created a drop down list of all products ...

    Stace123 | Excel | Latest reply: Stace123 Jul 28, 2015
    2 replies
  • The object is corrupt - in Word 2003 Solved/Closed

    We have a document that has several objects (Excel tables) in it. We update the tables each month and then "save-as" the new month. We have one tabl...

    elijahirwin27 | Word | Latest reply: fazekasbence Jul 28, 2015
    2 replies
  • Exchange 2007 Corrupt Database Solved/Closed

    I'm running Exchange 2007 Enterprise on Windows 2003. I have about 10 databaes that are running. I reboot the server this morning due to some updates ...

    mareliwalberg | Outlook | Latest reply: enzocalleros Jul 28, 2015
    2 replies
  • Cutting last 10 charecters of a cell and pasting to next cell Solved/Closed

    Hi Guys - Im back again with another excel macro problem. I can find all sorts of advice when I google this, but none of it quite matches my needs so ...

    BrianGreen | Excel | Latest reply: TrowaD Jul 28, 2015
    4 replies
  • Microsoft Project 2007 Corrupting Data Solved/Closed

    I have a split situation. At work I use MS-Project 2007 and at home 2003. To ensure transportability filers are always saved in 2003 MPP formats. ...

    malteolsen | Office Software | Latest reply: aidanthomas Jul 28, 2015
    1 reply
  • Opening a corrupted Illustrator .ai file Solved/Closed

    We have an Illustrator CS2 file, that a co-worker has been working on for the last month, that is now telling us unknown error has occured. We have...

    BenjaminOwens | Office Software | Latest reply: williammcdowell Jul 28, 2015
    1 reply
  • illustrator File Damaged And Could Not Be Repaired Solved/Closed

    its been coming more and more common for my files to become damaged and not be able to open for me. It started with files that had an insane number of...

    hanerggyn | Office Software | Latest reply: myleszikiom Jul 26, 2015
    2 replies
  • How to restore xls? Solved/Closed

    We had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Offi...

    finlaywilson45 | Office Software | Latest reply: danielriqueti Jul 26, 2015
    1 reply
  • Excel formula needed to count a list of names Solved/Closed

    Hi This is probably an easy one for the pro's, basically I have a list of names that will change as reports are generated. The report will inclu...

    lut1n | Excel | Latest reply: LINA Jul 25, 2015
    8 replies
  • Publisher 2007 Solved/Closed

    Hello, My computer crashed purchased a new one and am reloading software. I have my Publisher CD but no longer have the key. I called microsoft and th...

  • opening pdf files in photoshop Solved/Closed

    Hello, I am having trouble opening my pdf file that I created using photoshop CS2. I can't seem to open this file anymore, previously I could open i...

    iosivberg | PDF | Latest reply: avilsben Jul 24, 2015
    1 reply
  • Conditional formatting: Find text and highlight from other cell Solved/Closed

    I have a table with names and number values alternating in a table. I add all the numerical values and highlight based on the total value for each nam...

    drumroll13 | Excel | Latest reply: TrowaD Jul 23, 2015
    7 replies
  • MS Outlook outlook data file cannot be accessed " while accessin Solved/Closed

    I am unable to open my Outlook file due to corruption how to repair database .pst file of MS outlook. I was using Microsoft Outlook 2007 from last 2 y...

    StuartDoyle | Outlook | Latest reply: davidmoore Jul 17, 2015
    1 reply
  • get data present in Row1 of Sheet1 copied into row1 of Sheet2 Solved/Closed

    Hello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...

    ShambuKarpur... | Excel | Latest reply: vcoolio Jul 15, 2015
    11 replies
  • Outlook 2010 cannot open or access the required PST file Solved/Closed

    Thi smorning a system has had a problem. When I try to open Outlook, I get the following error: "Cannot expand the folder. The set of folders canno...

    atroharju | Outlook | Latest reply: thijngihenne Jul 15, 2015
    1 reply
  • formula - If C2 is not blank, and b2 Is blank, then copy c2 to Solved/Closed

    Hi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...

    Eirualmac | Excel | Latest reply: Eirualmac Jul 12, 2015
    2 replies
  • how to sort data according to shift Solved/Closed

    i want to sort according to person shiht

    bharatdevekar | Excel | Latest reply: bharatdevekar Jul 11, 2015
    0 replies
  • Transfer data and then apply formula Solved/Closed

    Hello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...

    TJay | Excel | Latest reply: Hydro Jul 9, 2015
    3 replies
  • Copy formulas across workbook Solved/Closed

    Hello, I want to copy Excel 2007 formulas from one workbook and past to the other workbook without the workbook name in the pasted formulas. Can ...

  • Macro to copy/paste specific range every 3 rows Solved/Closed

    Hello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...

    Isa | Excel | Latest reply: Isa Jul 7, 2015
    2 replies
  • Need urgently to find a macro in excel report across sheets Solved/Closed

    Hi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...

    moisdois | Excel | Latest reply: moisdois Jul 7, 2015
    6 replies
  • Error trying to populate new worksheet using macro Solved/Closed

    Hey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...

    AmitMehta96 | Excel | Latest reply: AmitMehta96 Jun 30, 2015
    2 replies
  • add string only if a text is present in a cell Solved/Closed

    Hello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...

    Deloro | Excel | Latest reply: Deloro Jun 30, 2015
    6 replies
  • Copy cell from another sheet where cell is value...? Solved/Closed

    Hi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...

    wzshop | Excel | Latest reply: wzshop Jun 30, 2015
    2 replies
  • macro for filling data from specific cell to another Solved/Closed

    Hi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...

    kayuf | Excel | Latest reply: kayuf Jun 30, 2015
    4 replies
  • Error: embedded Excel spreadsheet Solved/Closed

    Occasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...

    BrianGold654 | Excel | Latest reply: MatthewBon Jun 28, 2015
    1 reply
  • Lost BASIC11N.MSI Solved/Closed

    Hello, I cannot open MS Office Basic Edition 2003. I keep getting a message that says, "Missing BASIC11N.MSI file" I am missing the installer file. ...

    chocolateher... | Office Software | Latest reply: nuryev Jun 27, 2015
    6 replies
  • Need to recover a pst file having a password. Solved/Closed

    Hello, I am in need of a soft utility which can be used to change/ recover the password set on a pst file in outlook. I have a user who has forgo...

    r.doyle31 | Outlook | Latest reply: r.doyle31 Jun 26, 2015
    3 replies
  • Transferring Data Automatically in same Worksheet EXCEL Solved/Closed

    Hello, I'm finding a difficulty in transferring data from a number of cells to a table automatically. What I'm trying to accomplish here is that w...

  • Need value as per given criteria Solved/Closed

    Hello, There is a range given on one column and on the other column there are points. Ex: 200 - 180. 10 points 179 - 160. 9.5 points 159...

    Sanam Khan | Excel | Latest reply: Mazzaropi Jun 23, 2015
    6 replies