Office Software Forum

Ask a question
Search
Close
Results 1251 - 1300 of about 16,600
  • Cut and paste using vba script Closed

    Hello, I'm looking for a VBA script for the following scenario, kind request to suggest a method. Ques: I've a series of columns Range (A:HZ) (...

    Sree | Excel | Latest reply: Sree Sep 14, 2017
    0 replies
  • flyer Closed

    how do i create a flyer

    semicod | PDF | Latest reply: semicod Sep 14, 2017
    0 replies
  • if then else Closed

    Hello, Please help me with a formula for Excel(?) in Open Office. I want to say....If =IF(G59=date;then_date;otherwise_0) I am trying to say i...

    Terryl | Excel | Latest reply: ac3mark Sep 13, 2017
    1 reply
  • Filters for Rows label coming as (blank) Closed

    Hello, I ran a Pivot on office2013 and some reason my filters for Rows label coming as (blank) Any idea?please? System Configuration: Windows /...

    MA | Excel | Latest reply: ac3mark Sep 13, 2017
    1 reply
  • Need to calculate monthly avg and yearly miles from odometer Solved/Closed

    Good afternoon, I am having an issue figuring out how to get excel to calculate the yearly mileage and monthly avg by just monthly odometer reading...

    jamishore | Excel | Latest reply: vcoolio Sep 13, 2017
    5 replies
  • Auto-populate info. from master sheet to multiple sheets Solved/Closed

    Hi, I have been working on an excel sheet for the past month and have not found a solution that would do what I need it to do. I'm sure there have ...

    kvil | Excel | Latest reply: TrowaD Sep 12, 2017
    15 replies
  • Conditional formatting on multiple rows with different names Closed

    Hello, I have 4 names in column A SEGMENT - ADULT ORG SEGMENT - CORE SEGMENT - LIGHT SEGMENT - PROACTIVE HEALTH I want to use a conditi...

    Harsh Sutaria | Excel | Latest reply: Harsh Sutaria Sep 11, 2017
    0 replies
  • How to transfer data automatically in Excel? Closed

    Hello, I have a work sheet called installment chart, I want to transfer data of different cells from installment chart to an other work sheet call...

    musharafpk2017 | Excel | Latest reply: musharafpk2017 Sep 11, 2017
    0 replies
  • How to remove all duplicates found in Sheet 1 and Sheet 2 Closed

    Hello, I have an excel sheet and I need some help in writing formula. The excel has Sheet 1 with old data, Sheet 2 with new data and contains s...

    ladystark | Excel | Latest reply: ladystark Sep 11, 2017
    0 replies
  • Find word within cell & put value in adjacent Solved/Closed

    Hello, I'd like to scan a column for a certain word (e.g. "apple") and put a code (e.g. "A") on the cell next to it each time it finds it. In this ...

    Mr.G | Word | Latest reply: BogelBot Sep 9, 2017
    39 replies
  • Copy cells entered in sheets to form a single list in another Closed

    Hello, I have a cells in sheets in Excel that I wish, as data is entered, to copy to another sheet and build a list from these entries. i.e. as data...

    AlanCollyerEB | Excel | Latest reply: AlanCollyerEB Sep 9, 2017
    0 replies
  • Macro record doesn't paste on the next row Closed

    Hi, how to copy data from one sheet to a table on an other sheet using macro records , i faced a problem when i click the button it's working good but...

    adelvoira | Excel | Latest reply: adelvoira Sep 9, 2017
    0 replies
  • MS Office product key Closed

    I am in the process of downloading microsoft office. a product key is required how do I get it

    محمد الشحات | Office Software | Latest reply: Ambucias Sep 9, 2017
    1 reply
  • Enter Data into main worksheet and have it update separate WS Closed

    I have a workbook that I would like to enter all my data into one main worksheet "2017 Job Cost Analysis" and have that data automatically populate al...

    jamishore | Excel | Latest reply: jamishore Sep 7, 2017
    10 replies
  • WHAT WILL BE THE FORMULA Closed

    Hello, if A1>A2 THEN C1+C2 AND IF A1

    deepsubhamoy | Excel | Latest reply: Mazzaropi Sep 7, 2017
    1 reply
  • Excel for Mac 15.37 copy row to another sheet Closed

    Hi, Im sure this question has been asked before but I can see it anywhere, please accept my apologies if this has already been answered. I have o...

    tfxuk7 | Excel | Latest reply: tfxuk7 Sep 7, 2017
    0 replies
  • Lock a cell based on another Cell in the entire sheet Closed

    Hello, I have drop down selection (Yes/No) in Column A, and I need to lock corresponding cell in Column B if the result is "No" in Column A. Please ...

    Karun | Excel | Latest reply: ac3mark Sep 6, 2017
    1 reply
  • How to get the yearly mileage and monthly avg from odometer only Closed

    How can I get excel to calculate the yearly mileage and monthly avg by just monthly odometer readings? I Here is my worksheet: https://www.dropb...

    jamishore | Excel | Latest reply: jamishore Sep 6, 2017
    0 replies
  • Conditional formatting depending on another cell Closed

    Hi! I have an excelsheet with a namelist in e.g. cell A2:A10 and next to it are numbers. I am looking for a way to format the namelist if B2:B10 >0. I...

    maaikevs | Excel | Latest reply: maaikevs Sep 6, 2017
    0 replies
  • Where to get the product key which was downloaded Closed

    where to get the product key which was downloaded

    venkat2604 | Office Software | Latest reply: Ambucias Sep 6, 2017
    1 reply
  • About Excel. Closed

    Hello, Total number of 5 sheets in Excel should be counted on automatic 6th sheet.

    Gunjan Verma | Excel | Latest reply: Gunjan Verma Sep 6, 2017
    0 replies
  • Date of brith in words 05/06/2016 Closed

    Hello, date of brith in words 05/06/2016

    vkstoda | Excel | Latest reply: themorgan Sep 6, 2017
    1 reply
  • Update data from one sheet to the next. Solved/Closed

    The macro I want just takes data from one tab and adds it to another like an update. i suspect that the macro will take some time to make as the updat...

    raymondald | Excel | Latest reply: ac3mark Sep 5, 2017
    3 replies
  • Microsoft Office recovery Closed

    I've been using MS Office on my lenovo laptop ever since. But recently my windows crashed and i had to reinstall the software. Upon rebooting, i lost ...

  • PowerPoint can't embed Truetype font Closed

    Hello, I am facing a challenge in Power Point. When I try to save a file with embeded fonts is gives an error: Cannot embed Truetype font: … (fo...

    Margarita | PowerPoint | Latest reply: Margarita Sep 5, 2017
    0 replies
  • Working in word, trying a file Closed

    When you try to open the file .doc (with a finished thesis!!!) crawls this message: Word experienced an error trying to open the file. Try the fol...

    withers | Word | Latest reply: Ambucias Sep 4, 2017
    1 reply
  • Transferring data into separate work books Closed

    Hello, I was hoping to get some advice on the best way to transfer data from one work book to another. Both works books are collecting the same da...

    Edd721 | Excel | Latest reply: Edd721 Sep 4, 2017
    0 replies
  • Inserted 5 cells in one sheet, automate it in 10 differen sheets Closed

    Dear, I am a very beginner in Macros. Could you please help to automate my task. I have inserted 5 different cells in a sheet and would like to...

    priyamani01 | Excel | Latest reply: priyamani01 Sep 4, 2017
    0 replies
  • Transfer activity data to new sheet with yes/no criteria. Closed

    Hello, I need to prepare the excel summary with the help of Master sheet. If the drop down in master sheet is yes, than that option should be copy...

    Viren | Excel | Latest reply: vcoolio Sep 4, 2017
    1 reply
  • IF function for time value Closed

    Hello, i have data of time in this format : 8/8/17 4:35 AM i want a formula to determine if the time is after 14:15:00 PM is "PM". any data...

  • Help with adding columns for state totals Closed

    Hello, I have a worksheet that shows clients (col A) by state(col B) with total spend (col E). I have all states abbreviation in col H and woul...

  • Want the coding to paste some data to another sheet Closed

    Hello, I want to copy one data to another sheet. But I want the data to be pasted one after another as many time I submit it System Configurati...

    Bhavesh | Excel | Latest reply: ac3mark Sep 1, 2017
    1 reply
  • MS Office home use Closed

    Hello, If I was to purchase MS Office Suite 2013 for my Laptop computer, do I get a key so I can also install it on desktop computer home both 201...

  • Locate 7 digits after 'dell#' in one column and have it replicat Closed

    Hi I am trying to locate 7 digits after 'dell#' in one column and have it replicate those digits to another cell.

    Cat | Excel | Latest reply: Mazzaropi Sep 1, 2017
    1 reply
  • How to look up a value within only a subset of another column? Closed

    Hello, Thanks in advance for any help! This is my data: X 1 3 X 2 4 Y 1 5 Y 5 4 Y 3 2 And I want to know, does the value in C1 ('3') ...

    Rachel | Excel | Latest reply: Mazzaropi Sep 1, 2017
    1 reply
  • How to use X or Y as variable in particular cells Closed

    Hello, i want use X or Y as variable or unknown, such that when i varies the value of X or Y it should automatically be updated in cells where it is p...

    liancotta | Excel | Latest reply: liancotta Aug 30, 2017
    0 replies
  • Google Sheets to keep up with High School Football Scores Closed

    Hello, Ok I am creating a google spreadsheet to keep up with High School Football Scores. I would like help with a formula that allows me to color...

    cjradio | Excel | Latest reply: Mazzaropi Aug 30, 2017
    1 reply
  • Arrow keys not working on spreadsheet Closed

    I have unlocked the scroll lock, but no movement on arrows. I tried a Word Document, the arrow keys worked perfectly..Any ideas??

    RonWilliams | Excel | Latest reply: RonWilliams Aug 30, 2017
    0 replies
  • Conditional formating - apply on more cells Solved/Closed

    Hello, i'm not so familiar with conditional formatting, so I would like to ask something: I'm making a doc where Column A has number values, column ...

    Biljana | Excel | Latest reply: Raj Aug 30, 2017
    32 replies
  • IF and OR Functions Using a Date Closed

    Hello, I am trying to make a formula that says IF Cell is dateA then the answer is Blue If cell is dateB then answer is Green If A9=(2017,9,9)...

    lisa Boland | Excel | Latest reply: Mazzaropi Aug 30, 2017
    1 reply
  • Automatically transfer data from multiple sheets to one sheet. Closed

    Hello, I have a price book in Excel with multiple sheets. Sheets are formatted differently except for first three columns (QTY,PartNo,Price). I ...

    Lisa Allen | Excel | Latest reply: vcoolio Aug 30, 2017
    6 replies
  • How to get the numbers of days a case has been open in Excel? Closed

    I want show the number of days a case has been open in an Excel field. Example: a case was open in 01/01/2017 and has not been closed as of today. H...

    Sam | Excel | Latest reply: Sam Aug 29, 2017
    0 replies
  • Transfering course information to a seperate tab in Excel Closed

    Hello, I originally posted this in 'Office Software', but since I am moving towards playing around with VBA code and not getting much information,...

    ddoctor543 | Excel | Latest reply: ddoctor543 Aug 29, 2017
    0 replies
  • Date format not being accepted Closed

    I have 2 date columns but no matter what I do they are not being acknowledged as being dates. I opened the same file on my laptop and had no problem ...

    clf2005 | Excel | Latest reply: clf2005 Aug 29, 2017
    0 replies
  • Date format Closed

    Hello, i downloaded one excel sheet containing dates in format December 13th, 2011 . i want to change its date format . i tried changing in form...

    ayeshaali11 | Excel | Latest reply: eunice3301 Aug 29, 2017
    1 reply
  • Change date format Closed

    How do i change the below date format into mm/dd/yyyy? 15-12-2015 22-07-2015 22-07-2015 your response is highly appreciated

    jjolori | Excel | Latest reply: eunice3301 Aug 29, 2017
    1 reply
  • Sending alerts from Excel for expired contracts to email Closed

    hello, I have a excel sheet (Office 2016) where I register contracts, now I want to set an alert for expired contracts which will then be send via ...

    Bonnie | Excel | Latest reply: Bonnie Aug 29, 2017
    0 replies
  • MS Office 2010 product key Closed

    i have downloaded microsoft office 2010 free version and it is asking for product key. now where i can find the product key????

  • Auto populate sheets dynamically based on specific criteria Closed

    Hello, I have a spreadsheet for upcoming projects that will each have a figure budgeted in upcoming specific financial year or years. Financial ye...

    Brian0808 | Excel | Latest reply: Brian0808 Aug 28, 2017
    0 replies
  • Transferring data from one worksheet into another Closed

    Hello, VERY new with Excel and have a question I'm sure you'll find basic. I have two worksheets. In one worksheet, column G has text in it and in...

    TJLamb0518 | Excel | Latest reply: TJLamb0518 Aug 28, 2017
    0 replies