Office Software Forum - solved topics

Ask a question
Results 451 - 500 of about 2,650
  • Solved
  • Data auto change on multiple status in one column Solved/Closed

    Hello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...

    -Hta- | Excel | Latest reply: Mazzaropi Mar 3, 2017
    10 replies
  • Question on VBA code Solved/Closed

    Hello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...

    Griever666 | Excel | Latest reply: Griever666 Feb 28, 2017
    2 replies
  • Formula help - if cell contains a number, +1. Solved/Closed

    Hi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...

    Crozzers | Excel | Latest reply: Mazzaropi Feb 28, 2017
    3 replies
  • Covert date of Birth Solved/Closed

    Dear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...

    sushim1399 | Excel | Latest reply: sushim1399 Feb 27, 2017
    2 replies
  • Need help with Macro to generate Monthly Overview Solved/Closed

    Hi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...

    ZhengPeng | Excel | Latest reply: ZhengPeng Feb 27, 2017
    12 replies
  • Conditional Formatting Solved/Closed

    I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...

    cmenzies | Excel | Latest reply: Mazzaropi Feb 27, 2017
    3 replies
  • Transfer data from one sheet to another Solved/Closed

    Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...

    Anita80Olivier | Excel | Latest reply: vcoolio Feb 24, 2017
    3 replies
  • Date formats Solved/Closed

    Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...

    jbeasley | Excel | Latest reply: ac3mark Feb 22, 2017
    3 replies
  • Adding number of days in filtered excel sheet Solved/Closed

    how to add number of days to columns in a filtered excel sheet

    rashiken | Excel | Latest reply: rashiken Feb 22, 2017
    0 replies
  • complicated auto populate possible or not and if so how. Solved/Closed

    Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...

    jmp2009 | Excel | Latest reply: vcoolio Feb 22, 2017
    9 replies
  • Copy row by x times where value x is cell value of the range Solved/Closed

    I need to scan each value in a column A and use the value in that column to copy the current row x times to another sheet. The second sheet is to be u...

  • iso 27005 Risk Value Solved/Closed

    Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...

    christossol | Excel | Latest reply: Mazzaropi Feb 21, 2017
    5 replies
  • copy a row from one worksheet to another, based on criteria Solved/Closed

    Hello, I'm trying to copy rows from my "master" worksheet to another sheet based on criteria in column A. Can I do this? Please help, thanks...

    wy | Excel | Latest reply: vcoolio Feb 20, 2017
    15 replies
  • I want to send 120 e-mail with 120 attachments Solved/Closed

    Hello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want ...

    issahamameh | Excel | Latest reply: medo42002 Feb 19, 2017
    35 replies
  • Totaling Hours by Code Solved/Closed

    I'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...

    nowlanandrea | Excel | Latest reply: Mazzaropi Feb 17, 2017
    7 replies
  • change data status in one same column Solved/Closed

    Hello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...

    -Hta- | Excel | Latest reply: Mazzaropi Feb 17, 2017
    4 replies
  • IF statement - Solved/Closed

    Hello, I'm attempting to create an IF statement. IF a type = 1 then add the total of a corresponding cell to the total amount. =SUM(IF(B24:B51="1...

    Le0n2 | Excel | Latest reply: Mazzaropi Feb 16, 2017
    3 replies
  • Lookup across whole workbook (muliple sheets) Solved/Closed

    Hello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. ...

    mad | Excel | Latest reply: Mark Feb 10, 2017
    6 replies
  • Data in Cells Appearing in other Pages Solved/Closed

    Hello, I am having a problem with entering data into a cell on one page (tab) of a spreadsheet, and having that data show up in the same cell(s) on ...

    tdinsc | Excel | Latest reply: tdinsc Feb 9, 2017
    0 replies
  • Autofill Master sheet Solved/Closed

    I am trying to automatically fill in a table (with whole rows from A-N) on a master sheet (sheet 1) based on whether the data in column H of the table...

    qwertyAlex | Excel | Latest reply: vcoolio Feb 9, 2017
    1 reply
  • If cell contains a certain text, add the numbers of another cell Solved/Closed

    Hello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...

    mmbitar | Excel | Latest reply: Mazzaropi Feb 6, 2017
    1 reply
  • Need formula for comparing differences of two columns. Solved/Closed

    Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...

    oduana777 | Excel | Latest reply: oduana777 Feb 4, 2017
    3 replies
  • Copy ActiveChart properties to cell (from graphics) Solved/Closed

    Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...

    mendokzeni | Excel | Latest reply: mendokzeni Feb 2, 2017
    2 replies
  • Copying Conditional Formatting with Formulas Accross Rows Solved/Closed

    Hello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...

    Wearrien | Excel | Latest reply: Wearrien Feb 2, 2017
    2 replies
  • Multiple IF formula in one cell, date comparison Solved/Closed

    Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...

    She.Charm | Excel | Latest reply: TrowaD Feb 2, 2017
    3 replies
  • Convert number to assigned names and joined with another names  Solved/Closed

    Hello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...

    Mariam | Excel | Latest reply: Mariam Feb 1, 2017
    4 replies
  • Excel Sheets automatic updates Solved/Closed

    Hello, I am trying to collect budget request from different departments and if all approvals fields are Approved, I want all data to be collected in...

    sumi | Excel | Latest reply: sumi Jan 31, 2017
    0 replies
  • Macro for merging data from multiple sheets Solved/Closed

    Hello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...

    Ashwathi V K | Excel | Latest reply: TrowaD Jan 31, 2017
    5 replies
  • how to convert Date into text. Solved/Closed

    Hello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...

    rk gupta | Excel | Latest reply: TrowaD Jan 30, 2017
    1 reply
  • Function button: Unhide cells between values and hide all other Solved/Closed

    Hello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...

    MartaGH | Excel | Latest reply: MartaGH Jan 25, 2017
    2 replies
  • Automatically transfer data from one sheet to another Solved/Closed

    Hello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...

    Lghtningt4u2 | Excel | Latest reply: vcoolio Jan 22, 2017
    5 replies
  • range of numbers Solved/Closed

    hello, I would appreciate help on the following problem :- If cell R1equals any number in the range 12 to 31 then I wish cell b1 to equal 2. Is ther...

    whatsit | Excel | Latest reply: Mazzaropi Jan 21, 2017
    3 replies
  • Add incremental number based on conditions in Excel Solved/Closed

    Hello, I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column bas...

    Rruwinda | Excel | Latest reply: Mazzaropi Jan 20, 2017
    3 replies
  • Outlook Can Receive but not Send with Certain Wifi Networks Solved/Closed

    Hello, I moved my PC to a new home and found that my Outlook can receive but not send when connected to the home's wifi. When I set up a hotspot on...

    JR | Outlook | Latest reply: ac3mark Jan 16, 2017
    1 reply
  • Generate excel workbooks based on excel list Solved/Closed

    Hello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...

    m_albges | Excel | Latest reply: rivera Jan 16, 2017
    23 replies
  • If Then Solved/Closed

    Im trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...

    timmiller109 | Excel | Latest reply: Mazzaropi Jan 14, 2017
    1 reply
  • Email with Multiple Attachments through VBA Solved/Closed

    Dear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column B Ro...

    Game Start Now | Excel | Latest reply: ac3mark Jan 10, 2017
    9 replies
  • IF and IS TEXT or IS NOT Blank Solved/Closed

    Hello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...

    Jam | Excel | Latest reply: ac3mark Jan 5, 2017
    5 replies
  • Conditional Formatting range of date cells based on another cell Solved/Closed

    Hi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...

    cleaverr | Excel | Latest reply: cleaverr Jan 5, 2017
    7 replies
  • Search for a Keyword. Add Value from another cell. Solved/Closed

    I'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...

    adam73647 | Excel | Latest reply: adam73647 Jan 3, 2017
    2 replies
  • A IF(istext) formula that needs a trimming, please help? Solved/Closed

    Hello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...

    Bluntobject | Excel | Latest reply: TrowaD Jan 3, 2017
    1 reply
  • Worksheets into Workbook Solved/Closed

    Dear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...

    Game Start Now | Excel | Latest reply: Game Start Now Jan 2, 2017
    2 replies
  • Text from two different cells to give value shown in certain cel Solved/Closed

    Hello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...

    fgadmin | Excel | Latest reply: fgadim Jan 2, 2017
    4 replies
  • Conditional Formatting for Word and Date Solved/Closed

    Hello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...

    Tiffanypoche | Excel | Latest reply: Mazzaropi Jan 1, 2017
    3 replies
  • Auto copy and paste cell range to a separate sheet Solved/Closed

    Hello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...

    bnoboa | Excel | Latest reply: bnoboa Dec 30, 2016
    4 replies
  • Need to create multiple tabs based on data in table Solved/Closed

    Good Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...

    Kylana | Excel | Latest reply: vcoolio Dec 29, 2016
    6 replies
  • function in excel 2013 Solved/Closed

    Hello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...

    Saber Elajam | Excel | Latest reply: yg_be Dec 24, 2016
    1 reply
  • Nested IF functions using time values Solved/Closed

    Hello, can someone tell why this wont work. The time value functions work separately on their own, and I followed the excel help for nested if func...

    SharkMerry | Office Software | Latest reply: Harshada Chaudhari Dec 21, 2016
    5 replies
  • Cell format - COUNTIF then subtract from another cell Solved/Closed

    Hi, I have a spreadsheet with holidays on. I'm using =COUNTIF(D16:D380,"H") I want to then subtract this number from another cell - What do I need ...

    kieferschild | Excel | Latest reply: ac3mark Dec 20, 2016
    5 replies
  • If/Then Formula Help Solved/Closed

    Hello, I could use some help on the formula below. I need cells in one column (Y) to show specific text ("SEND") if cells in another column (G) has ...

    MrJags | Excel | Latest reply: MrJags Dec 16, 2016
    2 replies