Office Software Forum - solved topics

Ask a question
Search
Close
Results 401 - 450 of about 2,640
  • Solved
  • Outlook 2007 is not sending mails Solved/Closed

    Hello, Have a nice day. I migrate my data from one PC to another. The old one was having Windows XP operating system along with Outlook 2003 w...

    medo | Outlook | Latest reply: danigirl May 2, 2017
    32 replies
  • Copy and insert rows n number of times in Excel Solved/Closed

    I am trying to create a macro under Excel. My data is as follows: Col1 Col2 Col3 Col4 Col5 Col6 Col7 A1 1080 90 M 40 45 50 A2 999 90 M 25 ...

    SentiaD | Excel | Latest reply: SentiaD Apr 28, 2017
    0 replies
  • Shortcut to edit a cell without using F2 key Solved/Closed

    Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...

    Ben | Excel | Latest reply: BenFromSingapore Apr 25, 2017
    7 replies
  • Data in a hot key Solved/Closed

    Hello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.

  • Conditional format if hyperlink Solved/Closed

    Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...

    Obonden | Excel | Latest reply: ac3mark Apr 24, 2017
    12 replies
  • Compare the words in 2 columns in Excel Solved/Closed

    I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...

    chongml | Excel | Latest reply: TrowaD Apr 24, 2017
    11 replies
  • Excel forum within a range Solved/Closed

    Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...

    Gerberreinette | Excel | Latest reply: Gerberreinette Apr 24, 2017
    2 replies
  • Convert wordpad document back to pdf Solved/Closed

    Hello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done beca...

    uncltomm | PDF | Latest reply: ac3mark Apr 21, 2017
    10 replies
  • Need to delete columns based on Column header Solved/Closed

    Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...

    yesare | Excel | Latest reply: topazfae Apr 21, 2017
    7 replies
  • Auto generation of code Solved/Closed

    Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...

    karthick | Excel | Latest reply: TrowaD Apr 20, 2017
    1 reply
  • Excel - A macro to create new workbook and copy data Solved/Closed

    In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...

    Shridharb2002 | Excel | Latest reply: TrowaD Apr 18, 2017
    29 replies
  • Excel - macro to create multiple sheets Solved/Closed

    Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...

    Mariaca113 | Excel | Latest reply: vcoolio Apr 14, 2017
    5 replies
  • 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: Column: A...

    ll | Excel | Latest reply: kittu Apr 14, 2017
    35 replies
  • Import .pdf ...? Solved/Closed

    Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...

    RickRoll | Excel | Latest reply: RickRoll Apr 12, 2017
    2 replies
  • Running a macro in different cells Solved/Closed

    Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...

    Rinat | Excel | Latest reply: sd Apr 6, 2017
    3 replies
  • Formula Solved/Closed

    I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...

    ehmetcalf | Excel | Latest reply: ehmetcalf Apr 6, 2017
    2 replies
  • Conditional Formatting based on two cell values Solved/Closed

    Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...

    JamesA82 | Excel | Latest reply: Mazzaropi Apr 3, 2017
    3 replies
  • Copying cond. format for entire row based on 1 cell to other row Solved/Closed

    I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value

    TheBigMac | Excel | Latest reply: Mazzaropi Apr 3, 2017
    3 replies
  • Drop down lists Solved/Closed

    Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...

    christossol | Excel | Latest reply: Mazzaropi Mar 31, 2017
    3 replies
  • Removing False Value Solved/Closed

    Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...

    danmanuele | Excel | Latest reply: ac3mark Mar 30, 2017
    5 replies
  • Copy rows to other sheets based on value in column Solved/Closed

    All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...

    LeedMe | Excel | Latest reply: vcoolio Mar 30, 2017
    6 replies
  • PDF file alwasy opening in Word Solved/Closed

    Hello, What to do to disable my attachment file in pdf to open in Word application?

    Lou | Word | Latest reply: blkdolphin Mar 28, 2017
    5 replies
  • Trying to create a multi-column formula. Solved/Closed

    Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...

    oduana777 | Excel | Latest reply: TrowaD Mar 28, 2017
    9 replies
  • Excel problem Solved/Closed

    Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...

    John | Excel | Latest reply: Mazzaropi Mar 22, 2017
    3 replies
  • recover user id of irctc Solved/Closed

    Hello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101

    niranjan1608 | Word | Latest reply: rishabhj2019 Mar 22, 2017
    2 replies
  • Excel find word in series of cells and add Solved/Closed

    Hello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...

    Payroll | Word | Latest reply: matt Mar 17, 2017
    3 replies
  • Highlight one value in a dropdown menu of three responses Solved/Closed

    Hello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...

    MeganN | Excel | Latest reply: MeganNolf Mar 17, 2017
    2 replies
  • Code to move rows into another sheet based on certain values Solved/Closed

    I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...

    nathaliecannell | Excel | Latest reply: vcoolio Mar 17, 2017
    1 reply
  • Excel formulla Solved/Closed

    Hello, I want to split cell of available qty in to multiple cell according to requirement. Input Sheet -1 Material PO qty Req. Qty ...

    Jayesh patel | Excel | Latest reply: Jayesh patel Mar 12, 2017
    0 replies
  • Search a list of names at one time in excel Solved/Closed

    Hi, I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is i...

    priya_mbial | Excel | Latest reply: priya_mbial Mar 8, 2017
    8 replies
  • If a cell contains any text then add a value (with dates) Solved/Closed

    I am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday...

    ryannordgren | Excel | Latest reply: ryannordgren Mar 7, 2017
    7 replies
  • Macro to increase a cell reference by 11 Solved/Closed

    Hi everyone I want a macro that on open will increase the cell reference in a cell by 11 each time the book is opened i.e. Cell C18 has =Sheet2!H2. T...

    SLKG | Excel | Latest reply: YaneyYan Mar 7, 2017
    6 replies
  • How do I change a word doc into PDF or similar file format Solved/Closed

    Want to send off a resume and they do not accept my covering letter in Word format, how do I change it to PDF or similar please

    KatdirecT | PDF | Latest reply: KatdirecT Mar 6, 2017
    2 replies
  • conversion of DOB to full words Solved/Closed

    Hello, Configuration: iPhone / Safari 4.0 I want to to convert dob to word like 5/6/2014 to fifth June two thousand fourteen please tell me...

    jigs | Excel | Latest reply: gane@1987 Mar 3, 2017
    9 replies
  • Data auto change on multiple status in one column Solved/Closed

    Hello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...

    -Hta- | Excel | Latest reply: Mazzaropi Mar 3, 2017
    10 replies
  • Question on VBA code Solved/Closed

    Hello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...

    Griever666 | Excel | Latest reply: Griever666 Feb 28, 2017
    2 replies
  • Formula help - if cell contains a number, +1. Solved/Closed

    Hi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...

    Crozzers | Excel | Latest reply: Mazzaropi Feb 28, 2017
    3 replies
  • Covert date of Birth Solved/Closed

    Dear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...

    sushim1399 | Excel | Latest reply: sushim1399 Feb 27, 2017
    2 replies
  • Need help with Macro to generate Monthly Overview Solved/Closed

    Hi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...

    ZhengPeng | Excel | Latest reply: ZhengPeng Feb 27, 2017
    12 replies
  • Conditional Formatting Solved/Closed

    I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...

    cmenzies | Excel | Latest reply: Mazzaropi Feb 27, 2017
    3 replies
  • Transfer data from one sheet to another Solved/Closed

    Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...

    Anita80Olivier | Excel | Latest reply: vcoolio Feb 24, 2017
    3 replies
  • Date formats Solved/Closed

    Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...

    jbeasley | Excel | Latest reply: ac3mark Feb 22, 2017
    3 replies
  • Adding number of days in filtered excel sheet Solved/Closed

    how to add number of days to columns in a filtered excel sheet

    rashiken | Excel | Latest reply: rashiken Feb 22, 2017
    0 replies
  • complicated auto populate possible or not and if so how. Solved/Closed

    Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...

    jmp2009 | Excel | Latest reply: vcoolio Feb 22, 2017
    9 replies
  • Copy row by x times where value x is cell value of the range Solved/Closed

    I need to scan each value in a column A and use the value in that column to copy the current row x times to another sheet. The second sheet is to be u...

  • iso 27005 Risk Value Solved/Closed

    Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...

    christossol | Excel | Latest reply: Mazzaropi Feb 21, 2017
    5 replies
  • copy a row from one worksheet to another, based on criteria Solved/Closed

    Hello, I'm trying to copy rows from my "master" worksheet to another sheet based on criteria in column A. Can I do this? Please help, thanks...

    wy | Excel | Latest reply: vcoolio Feb 20, 2017
    15 replies
  • I want to send 120 e-mail with 120 attachments Solved/Closed

    Hello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want ...

    issahamameh | Excel | Latest reply: medo42002 Feb 19, 2017
    35 replies
  • Totaling Hours by Code Solved/Closed

    I'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...

    nowlanandrea | Excel | Latest reply: Mazzaropi Feb 17, 2017
    7 replies
  • change data status in one same column Solved/Closed

    Hello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...

    -Hta- | Excel | Latest reply: Mazzaropi Feb 17, 2017
    4 replies