Office Software Forum

Ask a question
Search
Close
Results 1601 - 1650 of about 16,600
  • 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
  • A macro to create new, copy and name worksheets based on a list Solved/Closed

    Greetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list that ...

    chottabeem | Excel | Latest reply: vcoolio May 11, 2017
    35 replies
  • Need Help creating an IF THEN scenario Solved/Closed

    Hello, I am looking for some help with a problem. I have a big list of items within Excel and I am wanting to consolidate the big list of items do...

    blakerwilson | Excel | Latest reply: vcoolio May 10, 2017
    12 replies
  • Comparing and merging excel files Closed

    Good afternoon, Each month, my client sends me an Excel file of their updated widget list. The client's file is 26 columns in total. My file is cl...

    LookingForAn... | Excel | Latest reply: LookingForAnswers May 10, 2017
    0 replies
  • date format for excel 2016 Closed

    Hello, I need to change the date format to dd/mm/yyyy in excel 2016... so that when I save as a .txt file and the date should appear in the follo...

    wayl | Excel | Latest reply: ac3mark May 10, 2017
    1 reply
  • Introduce color gradient of col A based on the value in col B Closed

    Hello, I am looking for a small help. I have 2 columns A and B, I have text written in A and numbers in % in B. Based on value in B, i want to add...

    Preethi | Excel | Latest reply: ac3mark May 10, 2017
    1 reply
  • trying to populate columns F, G, H, I and J Closed

    I've attached a photo for some clarity. I am trying to populate columns F, G, H, I and J based on the info from columns L, M and D. I've tried P...

    longsa23 | Excel | Latest reply: ac3mark May 10, 2017
    3 replies
  • comparing two files, exclude header from selection Closed

    Hello, please help with the comparison of two excel sheets using macro. The one I used is - Sub All_Diffs_Highlighted() Dim wb1 As Workbook...

    supritha | Excel | Latest reply: TrowaD May 9, 2017
    1 reply
  • A macro to copy/paste a cell and other cells in the same row Solved/Closed

    I have two wooksheets in a workbook. I need that a value of each cell in a range C3:C52 in sheet 2002 is being searched for in the range B2:B101 of th...

    tanja20 | Excel | Latest reply: TrowaD May 9, 2017
    3 replies
  • Excel Formula Parent/Child Heirarchy assistance required please Closed

    Hello and good morning, I respectfully would like to ask for assistance please with an issue I'm having to find an Excel formula to compare data f...

    jgroverm | Excel | Latest reply: TrowaD May 9, 2017
    1 reply
  • Weekly Data Imports to track status changes and new line items Closed

    Hello, What method would I use to import data into excel that contains line item numbers that increase each week? Additionally each week the numb...

    Chris | Excel | Latest reply: TrowaD May 9, 2017
    1 reply
  • commands "cut", "paste" are not highlighted Closed

    Hello everyone! Just need a little help here. I just installed Office 2007 on a new computer using Windows 7. It installed pretty well, the only thing...

    charlie349 | Word | Latest reply: Ambucias May 8, 2017
    1 reply
  • Populate a worksheet from an imported template. Closed

    Good Afternoon Currently in my spread sheet There is a Main page, on that there is a button called 'CREATE NEW CLIENT'. When clicked it runs this m...

    LukeSykes | Excel | Latest reply: TrowaD May 8, 2017
    1 reply