Office Software Forum

Ask a question
Results 2351 - 2400 of about 16,600
  • How to create several rules to change a cell's format. Closed

    Hello, I'm trying to create an excel spreadsheet to manage a property but I'm having difficulties in creating rules. Here's the schedule I'm m...

    Eaqj | Excel | Latest reply: Mazzaropi Oct 28, 2016
    1 reply
  • Inputting data to create a document Closed

    Hello, I would like to create a macro or snippet of code, whatever, that allows me to enter information that is then put into a document following...

    MSe | Word | Latest reply: MSe Oct 28, 2016
    0 replies
  • Compare two columns and add data from other columns if match fou Closed

    Ok i have names in Columns D and Columns I. I want to compare those two and if they match i want to copy the data adjacent to column I (J and K) to ...

    mwilke | Excel | Latest reply: Mazzaropi Oct 27, 2016
    3 replies
  • Changing a formula when a certain company is used Closed

    Hello, I am curious if anyone knows if there is a way to have excel change a formula when a certain word is used, and only change the formula in t...

    whitty | Excel | Latest reply: whitty Oct 27, 2016
    0 replies
  • Auto-generate new sheets with starting and ending date. Closed

    I started using macro in excel and I would like to inquire how to generate sheets by just giving the starting and ending dates. For example, I have th...

    ify11 | Excel | Latest reply: ify11 Oct 27, 2016
    0 replies
  • Error "Range of object Global failed" Solved/Closed

    Hello Everyone, Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed". Dim feat...

    adikademani | Excel | Latest reply: adikademani Oct 27, 2016
    2 replies
  • Excel- if this, than return that? Solved/Closed

    Background: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I need to...

    Happy Adminy | Excel | Latest reply: HappyAdminy Oct 27, 2016
    2 replies
  • Macro to copy rows and populate month/year based on start date? Closed

    Hi all, I have a set of data where I need to create a row for every month through December 2016 based on a start date. For example, below is how the d...

    ekwacillin | Excel | Latest reply: TrowaD Oct 27, 2016
    1 reply
  • Graphing Data from a Filtered Column Closed

    I am currently graphing a lot of data that I look at on a scatter plot. I have a column that is named "Step name " that has about 30 different steps d...

    NACDale | Excel | Latest reply: NACDale Oct 27, 2016
    0 replies
  • Trying to concatenate a letter with a date Solved/Closed

    Hello, I'm trying to keep a date in a recognisable format and precede it with a character. e.g. I want "D" and 27 July 2015 to appear as D 27 J...

    GBW | Excel | Latest reply: GBW Oct 27, 2016
    1 reply
  • Macros to Create new workbooks and Name them based on a list Closed

    Hello, I have a template which contains all the templates that needs to separated. Is there a macro that will separate all these templates and sav...

    Peter | Excel | Latest reply: Peter Oct 26, 2016
    0 replies
  • Set up automatic email after file is updated? Closed

    I have no code writing experience what so ever so I apologize upfront about my ignorance regarding VBA. Just wanted to see if someone could help me ou...

    kmo123 | Word | Latest reply: ac3mark Oct 26, 2016
    3 replies
  • VBA code for Inserting an Image Closed

    Hi guys, I am in an urgent need for a command or code to insert an image from any directory in my computer to a particular cell in Excel using V...

    adikademani | Excel | Latest reply: ac3mark Oct 26, 2016
    6 replies
  • If cell contains this text then.... Closed

    Hello, Basically I'm looking for a formula that would let me do something like this: If cell d1 contains ANY part of Apple (ie apple pie, apple ca...

    Nate | Excel | Latest reply: Mazzaropi Oct 26, 2016
    1 reply
  • Setting workheet object variable Closed

    Hello guys, I have defined WS as a woksheet and i want take an input from the user to select the worksheet using an input box. But I do not under...

    adikademani | Excel | Latest reply: adikademani Oct 26, 2016
    0 replies
  • convert date format to custom date format Closed

    If i try to convert date format to custom format again it went back and showing as date in tab. For example i have a date format like 26-10-2016 and i...

    venky | Excel | Latest reply: venky Oct 26, 2016
    0 replies
  • Excel VBA; Merging cells when criteria is met Closed

    Please I need help with the following, how to merge cells if certain criteria is met. when prefixes in column A match, cells in column B will merge ...

    Ann | Excel | Latest reply: Ann Oct 25, 2016
    0 replies
  • Insert Picture in Excel macro, after crop it, save it to a file Solved/Closed

    Hello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it and re...

    juancarlosmm | Excel | Latest reply: juancarlosmm Oct 25, 2016
    1 reply
  • Macro for comma on numeric keyboard Closed

    How could I create a macro to toggle the period "." key between a period and a comma ","? When typing numbers it would be nice to be able to use the ...

    dhend09 | Excel | Latest reply: dhend09 Oct 25, 2016
    0 replies
  • Pictures keep pasting over each other when vba code executes Closed

    Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...

    ssincerely | Excel | Latest reply: TrowaD Oct 25, 2016
    1 reply
  • change date format Closed

    Hello, I Want to change date format DD"MM"YYYY (1/2/2016) TO 1/FEB/2016 MS Excel 2003 Please solve my problem urgently Shatrughna unquote

    ALI | Excel | Latest reply: ALI Oct 25, 2016
    0 replies
  • Spell Number Closed

    I do not get the above function in my Excel 2016

    Akila | Excel | Latest reply: Akila Oct 25, 2016
    0 replies
  • If Function with Multiple statements including Vlook up Closed

    Hello, Id like for my formula to read if vlookup is found (H:H is found in the freedom report and column x matches text in AV1, say registered. ...

    jenn | Excel | Latest reply: ac3mark Oct 24, 2016
    4 replies
  • Rearranging analysed historic data into a new coding structure Closed

    Hello, I'm trying to rearrange historic data into a new coding structure. I have an excel spreadsheet, showing nominal codes analysing rows of...

    Mary | Excel | Latest reply: Mary Oct 24, 2016
    0 replies
  • Unable to restore emails from .edb file Closed

    I decided to migrate to a new Exchange server due to the crush of my old server. And now I am on the Exchange server 2010. But I understood (too late ...

    Cleseis | Outlook | Latest reply: captainashish Oct 24, 2016
    2 replies
  • How to transfer specific data from one sheet to another Closed

    Hello, I am not an expert in Excel and I would say that I am a beginner on this program. I am working on an enrolment spreadsheet. On Shee...

    lexileslie | Excel | Latest reply: lexileslie Oct 24, 2016
    0 replies
  • Need password Closed

    Hello, I for got my password Configuration: iPhone / Chrome 49.0.2623.91

    Reno Bandy | Word | Latest reply: Ambucias Oct 23, 2016
    1 reply
  • What and where is the "orb button" as mentioned in help? Closed

    Requested help on changing default action when entering info in Excel - response was "open excel and press the orb button". I can't find anything tha...

    raynershyne | Excel | Latest reply: raynershyne Oct 23, 2016
    0 replies
  • Copying values in cell based on a number/identifier in excell Closed

    Hello, I'm working on an excel file and need to copy several values from different cell in the same row to another sheet based on unique number/ident...

    jmambu | Excel | Latest reply: jmambu Oct 22, 2016
    0 replies
  • Date if function Closed

    Hello, I am looking for the formula to show the date if. Ex: I have been provided with the start date (10/4/2016) and i need to add 28 day's (=...

    Praveen | Excel | Latest reply: Mazzaropi Oct 22, 2016
    1 reply
  • Find words within cell & put text and color in adjacent cell Solved/Closed

    Hi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a diffe...

    EST | Excel | Latest reply: fazal1 Oct 22, 2016
    11 replies
  • Time Elapse Closed

    Hello, I want to use time elapse in excel showing the years, months, weeks and days from a start date. I want all my months to calcula...

  • What is the password for Volume Limit on iPod Solved/Closed

    On my ipod chatmoatic, I was trying to figure out what the problem was with my volume. So I came to this spot that says "Settings" then, "Volume Limi...

    minikemp | Word | Latest reply: appletech Oct 21, 2016
    45 replies
  • Multiple If Function with priority Closed

    Hello, I want and If function to have 2 criteria. Where one segment takes priority, I dont know how to do that. Currently I have =IF($R145="...

    jenn | Excel | Latest reply: Mazzaropi Oct 21, 2016
    4 replies
  • Conditional Formatting based on other cells Closed

    I'm relatively new to Excel and I was wondering how exactly to do the following: A1=BALL A2=CAT How do I make it so that when B1=A1, then B1 is...

    osiron23 | Excel | Latest reply: Mazzaropi Oct 21, 2016
    1 reply
  • Formulas Closed

    I'm trying to calculate my wages by entering the hrs worked each day, after 8hrs it is T.5 and DT after 10hrs. If I end up with a total of 3.2 or .2 ...

    gbatt | Excel | Latest reply: gbatt Oct 20, 2016
    0 replies
  • Copy certain cells from multiple sheets Closed

    Hi, I have lots of sheets that I need to copy specific cells and copy them to a summary sheet. I currently have this macro: Private Sub Command...

    SDizzle | Excel | Latest reply: SDizzle Oct 20, 2016
    0 replies
  • Find Partial Text Match between Two Columns of data Closed

    Hi Everyone, I am relatively new to Excel. I am in the process of comparing two columns of data to determine whether the data in each column relate...

    Randy | Excel | Latest reply: Randy Oct 20, 2016
    0 replies
  • Copy multiple rows from multiple sheets if certain cell is x Closed

    Hello, I have a purchase order document in excel that can have from 30 sheets to 500. In cell B14 on each sheet there is a code, if it is equal t...

    CeeZee | Excel | Latest reply: CeeZee Oct 20, 2016
    0 replies
  • Macro to copy paste columns of excel data to a new workbook Closed

    Hello, Consider the attached image. I have data like this for about 15 columns. I want to copy paste each column for 2 to 3 times in a different o...

    hriprsd | Excel | Latest reply: hriprsd Oct 20, 2016
    0 replies
  • Saving mails to a removable drive Closed

    Hello, I would like to know how I am able to save all the emails in my microsoft outlook to a removable drive. I tried exporting but it tells me tha...

    Scorp1967 | Outlook | Latest reply: captainashish Oct 20, 2016
    1 reply
  • Macros: Copy Invoice Details From One Sheet to Another Solved/Closed

    Would be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in excel, ...

    Jenny | Excel | Latest reply: vcoolio Oct 20, 2016
    6 replies
  • Auto Populate and Edit Spread Sheets Closed

    If Intersect(Target, Columns("H:H")) Is Nothing Then Exit Sub Range(Range("E" & Target.Row), Range("R" & Target.Row)).Copy _ Sheets(Target.Value).Ra...

    MKDC | Excel | Latest reply: MKDC Oct 19, 2016
    0 replies
  • Copy a row of data from one sheet to another Closed

    Hello, Trying to copy a row of data from a roster on a sheet into a new sheet when a cell states Line 1 ie When i type Line 1 etc i want excel to...

    Steve | Excel | Latest reply: Steve Oct 19, 2016
    0 replies
  • dates come in 2 different formats Closed

    Hello, I have a csv file which imported to excel gives me dates in 2 different formats. I need to have one single format so that we can analys...

    Asif | Excel | Latest reply: Asif Oct 19, 2016
    0 replies
  • changed psd file to pdf in error. how to change it back to psd? Closed

    Hello, I saved psd file with no extension, and then changed it to pdf by mistake. Now, when I try to change it to psd in a browser, it still keeps i...

    Rachel | PDF | Latest reply: Ambucias Oct 19, 2016
    1 reply
  • Multiple sending of messages Closed

    Outlook 2010 repeats sending messages with attachments greater than 1 or 2 megabytes until stopped but Outlook tells me that the message has failed.

    Albicat | Outlook | Latest reply: Albicat Oct 19, 2016
    0 replies
  • Conditional Format Cells Based on Another Cell and Own Cell Closed

    Hi, I'm trying to conditional format cells based on text in another cell and it's own cell. In Column A, the cells would contain either "hit" ...

    Elaine | Excel | Latest reply: x Oct 19, 2016
    1 reply
  • Different Calculation Based on Cell Text Closed

    Hello, I am self-employed and currently doing my taxes. I'm trying to set up my spreadsheet to make it as efficient as possible and am wondering if...

    JoshJStride | Excel | Latest reply: JoshJStride Oct 19, 2016
    5 replies
  • how to open my corrupted rtf document Solved/Closed

    Hello, Can anyone please investigate me how to open my corrupted rtf document? When I try to open it I am getting: Loading error Any suggestions h...

    MontesanoGra | Office Software | Latest reply: MontesanoGra Oct 18, 2016
    4 replies