Office Software Forum

Ask a question
Search
Close
Results 1101 - 1150 of about 16,600
  • Conditional formatting dates Closed

    Hi I am trying to format a date column on my spreadsheet and just can't see to get the formula right Simplified, I have 2 columns, one with a deadli...

    AmyE | Excel | Latest reply: ac3mark Nov 22, 2017
    1 reply
  • Formatting cell Solved/Closed

    Hello, I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here so...

    sheeba | Excel | Latest reply: sheeba Nov 21, 2017
    3 replies
  • Using one value to populate multiple columns Closed

    Hello, Hi sir am in need of urgent assisstance. I need to populate one value into multiple sheets in excel foe multiple rows... Ex if i enter a va...

    Sapsz | Excel | Latest reply: Sapsz Nov 21, 2017
    0 replies
  • Macro that extracts info from changing number of worksheets Closed

    Hello, I'm trying to find a way to insert a summary of several worksheets (I'm calling them analysis logs), but want to make it in such a way th...

    alita1984 | Excel | Latest reply: vcoolio Nov 21, 2017
    3 replies
  • Drop down look up Solved/Closed

    Hello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...

    nminnis | Excel | Latest reply: vcoolio Nov 21, 2017
    14 replies
  • Automatically update master worksheet from other worksheets Solved/Closed

    Okay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...

    Saktivel | Excel | Latest reply: vcoolio Nov 21, 2017
    18 replies
  • Problem getting a sum of cells from one sheet to another Closed

    Hello, I'm trying to create two spreadsheets, one with daily totals on it and one with weekly and I'd like for the weekly totals to automatically ...

    tforceemp | Excel | Latest reply: tforceemp Nov 21, 2017
    0 replies
  • Help- conditional cell formatting Solved/Closed

    Hello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...

    campbellty10 | Excel | Latest reply: campbellty10 Nov 21, 2017
    2 replies
  • Can't open office website for sign in Closed

    good day I just bought a new laptop HP pavilion with intel i3. I also purchased Microsoft office 365 for one year from best buy. I want to register ...

    swensonp | Office Software | Latest reply: swensonp Nov 21, 2017
    0 replies
  • Transfer data to individual sheets from Master sheet. Closed

    Hello, I am currently building a worksheet to track where cars are at a certain time. I have three places the car could be (west bullpen) (East Bu...

    Thomanni | Excel | Latest reply: vcoolio Nov 21, 2017
    1 reply
  • Sum a columns depending on pattern Closed

    Hi, I need help in adding the mileage of cars. the rule is simple.. start adding the miles from cells that contains "Movement Start" until "Movemen...

    josh07429 | Excel | Latest reply: josh07429 Nov 20, 2017
    0 replies
  • Transfer data from one sheet to another sheet in designate area Closed

    Hello, I'm working on create a hold record document for our company to label things we need to put on hold. In sheet 1, I have columns for Hold nu...

    Yehong | Excel | Latest reply: Yehong Nov 20, 2017
    0 replies
  • Copy Paste to another sheet with conditions Closed

    Dear all, I wanted to copy all the data inside this "form" through the button "send". As you can see I also have two list boxes and I only wa...

    joanavpf | Excel | Latest reply: joanavpf Nov 20, 2017
    0 replies
  • Group Duplicates and move to new worksheet Closed

    Hello, I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this dai...

    sassylilma | Excel | Latest reply: vcoolio Nov 19, 2017
    4 replies
  • date formatting Closed

    Hello, how to convert dates between 1-Jan-17 to 7-Jan-17 single date as 7-Jan-17 using formula System Configuration: Windows / Chrome 62.0.3202...

    tanvi | Excel | Latest reply: tanvi Nov 19, 2017
    0 replies
  • If then statement for switching numbers Closed

    How do I use the excel to basically score a survey! I want my code to say if qs: # 1 has score 1 then its 4 , if 2 then its 3 , if 3 then it's 2 , if ...

    MA91 | Excel | Latest reply: MA91 Nov 17, 2017
    0 replies
  • Trying to update date range every month Closed

    We have a spreadsheet I'm creating for a recon that we can just input the new date every month (last day of each month) and end up with a description ...

    SizzleBacon | Excel | Latest reply: SizzleBacon Nov 17, 2017
    0 replies
  • Move Rows of Data into New Worksheets Closed

    I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this daily. Move...

    sassylilma | Excel | Latest reply: sassylilma Nov 16, 2017
    0 replies
  • Consolidating Data Closed

    Hello, I have an excel worksheet that I am attempting to publish easily by automating the recovery of certain data. My goal is to add the text of ...

    tjgibbs | Excel | Latest reply: tjgibbs Nov 16, 2017
    0 replies
  • auto populate from master to individual sheets Closed

    Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that I ...

    MG918 | Excel | Latest reply: vcoolio Nov 15, 2017
    1 reply
  • Make a macro run when data entered in a cell Solved/Closed

    Hello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...

    SandsB | Excel | Latest reply: Rajiv Nov 15, 2017
    36 replies
  • Need help with #value! Closed

    Hello, Hello, I need a formula that will change answer based on selection from drop down box (the formula that I used keeps giving me a #valu...

    Seryn | Excel | Latest reply: Mazzaropi Nov 15, 2017
    1 reply
  • Conditional sum function in Excel Closed

    hi, i have 2 sheets in matrix format ,One having travel time between different zones and other having values of number of trips between different zo...

    ANNA | Excel | Latest reply: ANNA Nov 15, 2017
    0 replies
  • Need help with #value! Closed

    Hello, I need a formula that will change answer based on selection from drop down box B33 can be any number from 0-10, it has a drop down box w...

    Seryn | Excel | Latest reply: Seryn Nov 14, 2017
    0 replies
  • How to format text with a Macro? Closed

    I have a simple event based "macro" that populates my header with information. The question I had was: How can I have the header populate thi...

    LeedMe | Excel | Latest reply: LeedMe Nov 14, 2017
    0 replies
  • Excel Formula/VBA Assistance Closed

    Good Morning, I would appreciate some advice/assistance with formulas and VBA code. http://ge.tt/3wxXEJn2 I am trying to create an equipment ...

    SFRIAR616 | Excel | Latest reply: vcoolio Nov 14, 2017
    3 replies
  • Word 2010 showing dots instead of spaces Solved/Closed

    Hello, when I press space tab in the keyboard, a dot is printed in the Microsoft word 2010. How can I fix this problem? faithfully you Con...

    mehdiei | Word | Latest reply: Hugh Nov 14, 2017
    10 replies
  • Worksheet_SelectionChange event not working Solved/Closed

    Hello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...

    Omi Kat | Excel | Latest reply: Omi Kat Nov 13, 2017
    2 replies
  • auto populate from master to individual sheets Closed

    Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that...

    MG918 | Excel | Latest reply: MG918 Nov 13, 2017
    0 replies
  • give a response by comparing 2 times (in different columns) Closed

    I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours (7 AM...

    sailingdemon | Excel | Latest reply: sailingdemon Nov 13, 2017
    1 reply
  • import jpeg into cel Closed

    Making database for artist archive. Best way to import image files? Sizing is part of issue - how to import a small jpeg and have it conform to cel?

    LaZocalista | Excel | Latest reply: LaZocalista Nov 13, 2017
    0 replies
  • Working out the difference in times between two columns Solved/Closed

    I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...

    sailingdemon | Excel | Latest reply: sailingdemon Nov 12, 2017
    5 replies
  • How to load data from various sheets into one master sheet? Closed

    Hi Guys, Hope for an expert in excel who can help!!! I have a spread sheet that contains: 1st sheet is master file with the number plate number...

    Natasha | Excel | Latest reply: vcoolio Nov 12, 2017
    1 reply
  • SKU011.CAB Solved/Closed

    when I go to open ms word or ms excel computer ask for sku011.cab file. I have no cd of office 2003. please help

  • Excel macro to insert two rows. Closed

    Hello, System Configuration: Windows / Chrome 61.0.3163.100 I have similar problem as this. Just that, I wanted to insert row in different ...

    VIVIANNA TOR... | Excel | Latest reply: vcoolio Nov 12, 2017
    1 reply
  • Convert in to rs in word Closed

    3456755332578097 convert in to rs in word

    Ashwini More | Excel | Latest reply: xpcman Nov 11, 2017
    1 reply
  • How to use the Spellnumber function in Excel? Closed

    Hi. Please giud me how to use formula in excel for spell number for Indian currency .

    mon_123 | Excel | Latest reply: mon_123 Nov 11, 2017
    0 replies
  • Inserting day of week along with date Closed

    Hello, I found an previous post with same question that is closed and it was helpful except for the format. I am looking for an outcome of: Su...

    jmoricone | Excel | Latest reply: jmoricone Nov 10, 2017
    2 replies
  • Multiple cell copy to a single cell Closed

    Hello, I am trying to copy the contents of multiple cells in workbook A to a single cell in workbook B. This worked fine in the 2010 version but,...

    MikeR | Excel | Latest reply: ac3mark Nov 10, 2017
    1 reply
  • Emails not coming in Closed

    Hello, I am unable to go into my emails for the last week or so. System Configuration: iPad / Safari 8.0

  • How to copy columns to a specific column header and repeat? Solved/Closed

    Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...

    stylus33 | Excel | Latest reply: stylus33 Nov 10, 2017
    2 replies
  • Auto populate data from invoice. Closed

    Dear CCM.NET, Hope you are doing well. I am working for a yarn whole-seller company. I to keep record of various kinds of Yarn purchase, Yarn sell,...

    mustafakawsar | Excel | Latest reply: xpcman Nov 9, 2017
    1 reply
  • Changing format of date in Excel Solved/Closed

    Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...

    drizn | Excel | Latest reply: Dnbaugh Nov 9, 2017
    56 replies
  • Auto populate text and add total from one sheet to another Closed

    Hello, I am trying to work on a yearly spreadsheet that has tabs for each month. What we are trying to do is each month we update monthly tabs w...

    Mary | Excel | Latest reply: Mary Nov 9, 2017
    0 replies
  • Create new sheets, scrape in data, then create summary sheet Closed

    Hello Everyone, hope you are all well. I am trying to create a database to manage reviews of research papers for a project I am working on. Any he...

    Sidewinder | Excel | Latest reply: Sidewinder Nov 9, 2017
    0 replies
  • Can the index function in Excel set a range in different sheet? Closed

    Hello there, I need a small help. I need to know whether we can use the index function for setting a range in different sheets. I've u...

    abhininan | Excel | Latest reply: abhininan Nov 9, 2017
    0 replies
  • email sent out but not received Closed

    Hello, I just realized that i can receive and send out emails from my outlook but the emails sent out is not received but the emails sent through ...

    Kechberry | Outlook | Latest reply: Ambucias Nov 8, 2017
    1 reply
  • How to create New sheets by column with repeated values Closed

    Hi Have lines with various tables in rooms. Rooms numbers are in column, but sometimes room have 2 or more tables so room numbers repeats. Code s...

    Military1 | Excel | Latest reply: ac3mark Nov 8, 2017
    1 reply
  • Getting rows from one sheet to populate to another Closed

    Hi, I am working in Excel 2016. I have several separate rows of data on one sheet (lets call it my mother sheet) that I want to automatically popul...

    Ninabella84 | Excel | Latest reply: ac3mark Nov 8, 2017
    1 reply
  • max(if..? Closed

    hello, i have a table with 2 columns. the first column sometimes has text (any text), sometimes not! the second column contains the amounts. i wa...

    M_me | Excel | Latest reply: M_me Nov 8, 2017
    1 reply