Office Software Forum

Ask a question
Search
Close
Results 1551 - 1600 of about 16,500
  • Excel Help with comparing one file to another Closed

    Hello, I am trying to see if file matches another file to make sure the account hierarchy is correct. I have manually checked some and they are cor...

    Patricia Banks | Excel | Latest reply: Mazzaropi May 25, 2017
    3 replies
  • Extract year from alphanumeric serial numbers. Closed

    Hello, Cell A1 = SX17010006 Cell A2 = SX17010006 Cell A3 = SX16120001 Cell A4 = SX15070004 I need a formula which read first four alphanumeric...

    Mike | Excel | Latest reply: Mazzaropi May 25, 2017
    3 replies
  • Matching Names to Id Numbers Closed

    Hi, I have a list of 1,200 students. They have won awards. I want to match the students who won awards with their student id numbers. Is there a...

    Kelley M Likes | Excel | Latest reply: Mazzaropi May 25, 2017
    1 reply
  • Macro - filling a workbook form with data in another workbook Closed

    Hi there, i'm looking for some help with a macro. I have 2 workbooks, one is a form with several cells that need to be filled out (FORM.xlsx) and the ...

    Trevor | Excel | Latest reply: Trevor May 24, 2017
    0 replies
  • Combining and copying cells if a condition is met Closed

    Hi, I want to create a VBA script that does the following: Looks at values of column 5 (column E) of Sheet2 (values are Y or N). If the value is Y...

    QuestionAske... | Excel | Latest reply: QuestionAsker2525 May 24, 2017
    0 replies
  • Pull information from one sheet to another Closed

    Hello, I have a sheet called "Master Client List" that contains 4 columns of data: Counselor Name, Client Number, Client Last Name, Client First Na...

    clintcollins920 | Excel | Latest reply: ac3mark May 24, 2017
    1 reply
  • Turn off "Enter Network Password" Closed

    How do I turn off "Enter Network Password" in Outlook 2007. Using Windows 7. At present it is happening when I try to use my VPN

    maxlaw | Outlook | Latest reply: ac3mark May 24, 2017
    1 reply
  • Excel Find & Paste Formula Closed

    Hello, I have a list of product name in cell A containing country name and I wanted to bring put that country name into an adjacent cell. Do you...

    fasih | Excel | Latest reply: fasih May 24, 2017
    0 replies
  • Macro to create a new workbook from a worksheet Closed

    Hello, Please can somebody help me with the below query? I would like to create a macro which copies all of the data and formatting from a spec...

    simonrhi | Excel | Latest reply: vcoolio May 24, 2017
    3 replies
  • Copy rows to new sheets if condition is met Solved/Closed

    Hello , please help... I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The colum...

    I.Gal | Excel | Latest reply: vcoolio May 24, 2017
    7 replies
  • How to "Teach" Excel to Learn Names? Solved/Closed

    Greetings to all, I'm desperate to find a solution to my tedious work. So, each day i will go through hundreds of records and change product names...

    HoomanCz | Excel | Latest reply: HoomanCz May 23, 2017
    2 replies
  • Search for a value in column and copy to different sheet Solved/Closed

    Hi I want to search for an employee ID in column EID and copy the whole record into another worksheet within the same workbook if the EID is found...

    raghuprabhu | Excel | Latest reply: raghuprabhu May 23, 2017
    3 replies
  • IF then using multiple cells and words Solved/Closed

    Hello, D3,D4,D5 that all need to say either 'Compliant' or 'N/A', for result in E3 to say "yes", else "No". Please help. System Configurati...

    Matt Louisiana | Excel | Latest reply: Matt Louisiana May 22, 2017
    4 replies
  • Need help with conditional formatting Solved/Closed

    Good morning, I am trying to change the color of a cell(A) if another cell (D) contains text. The text will contain both a date and other text. Can...

    LeslieAnne | Excel | Latest reply: x May 22, 2017
    8 replies
  • VBA to find specific text and cut and past into new worksheet. Closed

    Hello, I am struggling to find anything to help me with my VBA code that I am currently trying to write. I need it to find specific text (Technica...

    DonalK | Excel | Latest reply: TrowaD May 22, 2017
    3 replies
  • macro exception Closed

    while running macro its throwing an exception 'The range does not exist'. so how to resolve this error.

    deepsikha | Excel | Latest reply: deepsikha May 22, 2017
    0 replies
  • Conditional Formatting HELP! Closed

    Hello, I am trying to change the color of a cell(A) if another cell (D) contains text. I can't remember (or find) how to write the if statement fo...

    LeslieAnne | Excel | Latest reply: LeslieAnne May 21, 2017
    0 replies
  • Copy Employee IDs to same cell in multiple worksheets. Closed

    Hello sir I have 400 sheets in workbook in first work sheet from I2 to I400 i have employee numbers Which i want to copy automatically to all 399 s...

    Srinivas | Excel | Latest reply: vcoolio May 21, 2017
    1 reply
  • Macro to Find, Copy and Insert Closed

    Greetings, Despite being completely new to macros, I'm attempting to create one that will search a range of values, and insert a row directly under...

    Reimertoad | Excel | Latest reply: Reimertoad May 20, 2017
    1 reply
  • Copy data in one excel file to multiple excel files Closed

    Hello friends, I have an excel field with 3 fields as below: VendorID - Name - Email ID - with nearly 5000 records. I want to get some ...

    punardeep | Excel | Latest reply: punardeep May 20, 2017
    0 replies
  • Automatically Copying Row When Sheet Is Opened Closed

    Hello, I'm trying to figure out how to copy an entire row from one sheet, to another sheet automatically. But, I only want the rows to copy when o...

    contigo | Excel | Latest reply: contigo May 20, 2017
    0 replies
  • How to copy data from sheet1 to sheet2 Solved/Closed

    Hello, I have a worksheet, there are 2 sheets. What I need is to do is copy all the column and rows from sheet1 and paste it to sheet2. The copy butt...

    Deepak | Excel | Latest reply: nisa May 19, 2017
    10 replies
  • Renaming multiple sheets in a workbook Closed

    Hello, I have workbook with more than 50 sheets.. I would like to rename all sheets with workbook name. Something like workbook.sheet1,workbook.shee...

    rev | Excel | Latest reply: vcoolio May 19, 2017
    1 reply
  • Macro to create a new workbook from a worksheet Closed

    I would like to create a macro which copies all of the data and formatting from a worksheet into a new workbook with pasted values.

    simonrhi | Excel | Latest reply: simonrhi May 18, 2017
    0 replies
  • Help with Excel +Sheet1!XY function please Closed

    Hello, I'm using Excel to monitor some data from my class, but I'm a fairly novice user. I've been using +Sheet1!XY to copy data from one shee...

    hjdx | Excel | Latest reply: TrowaD May 18, 2017
    1 reply
  • How do I change +Sheet1!XY for each sheet? Closed

    Hi, I've been using +Sheet1!XY to copy data from one sheet to another, from the same row in Sheet1 - row 8 On the next sheet I need to to copy t...

    hjdx | Excel | Latest reply: hjdx May 18, 2017
    0 replies
  • only Rupees Closed

    Hello, I need only rupees not paisa. Can you help. System Configuration: Windows / Chrome 58.0.3029.110

  • Compare 2 columns in 2 sheets and populate 3rd column in sheet 1 Closed

    Hello, I have following sheets. I want to populate Sheet 1 column B with value in columnB in sheet 2 where sheet 1 CA value matches with Sheet2 CA ...

    umishrikotkar | Excel | Latest reply: umishrikotkar May 17, 2017
    0 replies
  • Sort and assign VBA Closed

    Hello, I am trying to sort a column of Y and N i have in a chart on worksheet 1 in VBA. The list changes hourly. Once I determine who has a Y or N,...

    tblazers1 | Excel | Latest reply: tblazers1 May 17, 2017
    0 replies
  • Conditional Formatting based on 2 other cells. Closed

    Hello, I have a couple of things I need help with. First off: I would like to format a cell anywhere in Column D if: 1. There is any cell...

    mjely | Excel | Latest reply: mjely May 17, 2017
    0 replies
  • need to create a macro to insert row from sheet1 into sheet2 Closed

    Hello, I need to create a macro that will insert data from sheet1 into sheet2 based on the value in column D. The number of rows of data will var...

    mag4973 | Excel | Latest reply: mag4973 May 17, 2017
    0 replies
  • word 2016 Closed

    I have this new computer with word 2016 unable to display images. My 2010 file is transferred to word 2016 .How do I rectify this problem?

  • copy rows to new sheets if condition is met Closed

    I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The column "AL" contains several ...

    I.Gal | Excel | Latest reply: I.Gal May 17, 2017
    0 replies
  • copy rows to new sheet if condition is met (using macro) Closed

    I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The column "AL" contains several ...

    I.Gal | Excel | Latest reply: I.Gal May 17, 2017
    0 replies
  • Excel VBA that act like Template wizard? Closed

    Hello, im kinda new to excel and vba itself. Recently i've been using Template Wizard to create a template and storing it into the database. But i fi...

    ZQ | Excel | Latest reply: ZQ May 16, 2017
    0 replies
  • convertiom Closed

    Hello, i want to convert MY DOB in to words DOB: 11-08-1999

    AKHIL | Word | Latest reply: AKHIL May 16, 2017
    0 replies
  • air tv and windows Closed

    will powerpoint run on apple tv

    kedolby | PowerPoint | Latest reply: ac3mark May 16, 2017
    1 reply
  • Have to repeat list Closed

    Dear all Please help out have to repeat two list in one list. Query: List A List B A 1 B 2 C 3 D Results List C A 1 A 2 A 3 B ...

    kashif.aali | Excel | Latest reply: TrowaD May 16, 2017
    1 reply
  • Excel formula for percentage Solved/Closed

    Hello, I am trying to get a formula to calculate the percentage of cell O3 from cell N2. The format is what percentage is my expense (O3) from my ...

    Paula | Excel | Latest reply: tanu May 16, 2017
    4 replies
  • Copy filtered data to sheet 2 Closed

    Hello, i have a main sheet with say column Item name and BATest. i need to filter data of BATest and if Data is Analog input (for eg) then correspo...

    RSK | Excel | Latest reply: TrowaD May 15, 2017
    1 reply
  • Drag formula down depending on number in particular cell Closed

    Hello, System Configuration: Windows / Chrome 57.0.2987.133 I don't know if it is possible but here we go :) I have data from columns A ...

    Gerben69 | Excel | Latest reply: TrowaD May 15, 2017
    1 reply
  • If Statement Excel Closed

    Hello! Im a complete green at excell, maybe i just dont understand how the if statement work or im not that smart as i think :P The thing i want...

    KoTTen | Excel | Latest reply: vcoolio May 15, 2017
    1 reply
  • how to convert ounces (oz) to milliliter Closed

    Good morning to all, can someone please tell me how to convert ounces (oz) to milliliter s (ml). Thanks JPortillo

    JPortillo | Excel | Latest reply: vcoolio May 15, 2017
    1 reply
  • Font Change with another cell entry Closed

    Hello, I have "text" in cell G18. However, I want the font color to change based on any currency amount entered in cell J18 System Configuratio...

    mwspurlock | Excel | Latest reply: mwspurlock May 13, 2017
    0 replies
  • create macro on one sheet to update on another sheet Closed

    Hello, Trying to create a macro that will update data onto another sheet. Further this other sheet will be spending on the file path that the user ...

    Kyle f | Excel | Latest reply: Kyle f May 12, 2017
    0 replies
  • Outlook to Excel Tracking Closed

    Hello, Is there a way to track the emails from outlook shared drive to excel as and when they arrive? we have a list of branches and a standard fo...

    Monikaajg | Outlook | Latest reply: Monikaajg May 11, 2017
    0 replies
  • Powerpoint.The file cannot be opened Closed

    Hello everyone. When i attempt to open a .ppt presentation in PowerPoint, i receive the following error message: The file cannot be opened because p...

    manoloprec | PowerPoint | Latest reply: jacksomathew May 11, 2017
    4 replies
  • Finding sort based on gene name Closed

    Hello, I have 2 gene lists with corresponding expression from 2 different cell lines, I am trying to compare the expression of each gene in the tw...

    SunnyD | Excel | Latest reply: SunnyD May 11, 2017
    0 replies
  • The date does not show up as entered. Date format. Closed

    I am working with excel 2007 and the dates I enter show up completely different than the data I input. For example: I enter 050116 (no separators) ...

    Mymunchkins2 | Excel | Latest reply: TrowaD May 11, 2017
    1 reply
  • Future date based on text result and previu Closed

    Hello, I'm not very good at this and am struggling to find the correct formula to calculate future dates but with multiple variables and cells as ...

    Littlemouse71 | Excel | Latest reply: Littlemouse71 May 11, 2017
    6 replies