Office Software Forum - solved topics

Ask a question
Results 351 - 400 of about 2,640
  • Solved
  • Excel formula - Add days to date based on drop down selection Solved/Closed

    I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...

    Sabernethy | Excel | Latest reply: Mazzaropi Aug 17, 2017
    3 replies
  • How to auto-populate values from certain cells into a new sheet Solved/Closed

    Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...

    Roadknee | Excel | Latest reply: vcoolio Aug 12, 2017
    18 replies
  • Highlight only one column which has greater value Solved/Closed

    Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...

    Awais Munir | Excel | Latest reply: Mazzaropi Aug 11, 2017
    3 replies
  • Office 2007 files will not open Solved/Closed

    Hi.. I am Dipu Michael from India. I am using the software office2007 in windows7.For the checking purpose I installed 0ffice 2003 in my system. Afte...

    dipumichael | Office Software | Latest reply: xpcman Aug 10, 2017
    1 reply
  • Enter current time in a cell by clicking it Solved/Closed

    Hello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to fil...

  • True or False Value based on 3 difference cells' criteria Solved/Closed

    Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...

    KEVB | Excel | Latest reply: ac3mark Jul 26, 2017
    1 reply
  • Repeating a simple macro loop up to 1,500 times Solved/Closed

    Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...

    shassall | Excel | Latest reply: TrowaD Jul 20, 2017
    5 replies
  • Excel external data connection not working properly Solved/Closed

    Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...

    kvil | Excel | Latest reply: kvil Jul 19, 2017
    1 reply
  • Convert PST to MBOX for importing into Thunderbird Solved/Closed

    I have a pst file which contains all my outlook mail backups. I want to convert .pst to .mbox for importing those mails into my Thunderbird account. ...

    gregnudelman86 | Outlook | Latest reply: jhonnyeng Jul 14, 2017
    4 replies
  • Create a date from 3 different cells Solved/Closed

    Hello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...

    Trowa | Excel | Latest reply: Udeni Jul 13, 2017
    11 replies
  • Macro to insert multiple rows between existin Solved/Closed

    Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...

    informme808 | Excel | Latest reply: Pedro Jul 11, 2017
    7 replies
  • Copy and past the not equal value using macro Solved/Closed

    Hi guys!! Please help me with this. I'm trying to compare two sheets in excel. If it is NOT a match then copy the entire row into a new third sheet. ...

    ctran123 | Excel | Latest reply: Sam Jul 10, 2017
    3 replies
  • Script is really slow and sometimes crashes Solved/Closed

    Hi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...

    josh07429 | Excel | Latest reply: vcoolio Jul 7, 2017
    5 replies
  • Need help with script or formula Solved/Closed

    Column A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...

    josh07429 | Excel | Latest reply: josh07429 Jul 5, 2017
    5 replies
  • Matching cells but exclude blanks Solved/Closed

    Hello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...

    Tom9o | Excel | Latest reply: Hira Jul 4, 2017
    11 replies
  • Rounding up time Solved/Closed

    Hi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...

    josh07429 | Excel | Latest reply: nickname missing Jun 30, 2017
    1 reply
  • VBA compile Error: Do without Loop Solved/Closed

    Hello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...

    Arisfish | Excel | Latest reply: ac3mark Jun 28, 2017
    1 reply
  • Problem with script in Excel Solved/Closed

    Hello, I have a problem with my script. What I want is IF the value in column J is equals to "0" then I want the column H to be blank. Ex. J1 ...

    josh07429 | Excel | Latest reply: josh07429 Jun 26, 2017
    6 replies
  • Cell colour containing specific info Solved/Closed

    Hi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a differ...

    JohannGC | Excel | Latest reply: JohannGC Jun 23, 2017
    6 replies
  • Validate copied data in excel Solved/Closed

    Hi, I have a below scenario one row is copied and pasted, this pasted row needs data validation such that total of each cell shouldn't exceed the r...

    chint99 | Excel | Latest reply: chint99 Jun 22, 2017
    2 replies
  • Multiple worksheet data input Solved/Closed

    hi TrowaD, I am an on the job trainee at a company, i was ask to encode data from our furnace but its too much time consuming for me to encode all...

    vintacu | Excel | Latest reply: vintacu Jun 20, 2017
    2 replies
  • Conditional format based on text in same row Solved/Closed

    Hi all, New to this forum. I'm running Excel 2016 on Win7 -- my spreadsheet has results of inspections in columns E, G, and J. The possible valu...

    joshcamp | Excel | Latest reply: Mazzaropi Jun 20, 2017
    3 replies
  • How to manage hours and rounding in Excel Solved/Closed

    Hello, I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E...

    Theresa | Excel | Latest reply: Theresa Jun 19, 2017
    2 replies
  • Removing " false" value in "IF" Solved

    Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C11="Evening",200,IF(C11="Gaze...

  • Formula Solved/Closed

    I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...

    Jmccall2016 | Excel | Latest reply: x Jun 15, 2017
    7 replies
  • Convert date of birth in word Solved/Closed

    Hello, pls tell me formula for convert date of birth in word in excel

    kailash | Excel | Latest reply: Ambucias Jun 10, 2017
    1 reply
  • Comparing values of two Excel sheets Solved/Closed

    Hello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...

    issa | Excel | Latest reply: dh Jun 10, 2017
    2 replies
  • Copy/paste a range 'n' times. Solved/Closed

    Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...

    V_angel54 | Excel | Latest reply: vcoolio Jun 9, 2017
    3 replies
  • Conditional Format Solved/Closed

    Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has

    Azion | Excel | Latest reply: Azion Jun 6, 2017
    3 replies
  • Vlook up Solved/Closed

    Hello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help

    Sri | Excel | Latest reply: Sri Jun 6, 2017
    2 replies
  • Spreadsheets viewing formulas Solved/Closed

    How do I view hidden formulas on spreadsheet

    johncooke | Excel | Latest reply: TrowaD May 29, 2017
    3 replies
  • VBA send email via Outlook using loop; No response when run Solved/Closed

    Hello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the r...

    x.dominicraj | Excel | Latest reply: TrowaD May 29, 2017
    9 replies
  • How to convert the tamil pdf file to tamil word file Solved

    plz give the solution

    varathalakshmi | Word | Latest reply: HELLO May 29, 2017
    11 replies
  • VBA code in my command button doesn't work Solved/Closed

    Hello, I have a sample table below, I was trying different VBA code in my command button but doesn't work well. Column G is already programmed t...

    ips999 | Excel | Latest reply: vcoolio May 28, 2017
    1 reply
  • VBA column Solved/Closed

    Need to know how to added data in column field if column is not empty then go to another column and paste data

    sunilherode | Excel | Latest reply: Ambucias May 28, 2017
    2 replies
  • Format font colour to change Solved/Closed

    Hello, Using Excel, I have a range of cells K2-K15 that contain numeric values and I want the font color to change in any of those cells that are g...

    jandc111 | Excel | Latest reply: jandc111 May 26, 2017
    2 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
  • 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
  • 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
  • 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
  • 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
  • Trying to simplify data in Excel through VBScript Solved/Closed

    Please help desperate novice: In Excel, I have 5 columns: Bob Dad 12 13 blank Sue Mum 34 56 22 Gill Daughter 23 67 34 Jock Son 24 55 blank ...

    ColGood | Excel | Latest reply: TrowaD May 8, 2017
    3 replies
  • How do I use conditional formatting in Excel Solved/Closed

    Hello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...

    newbie | Excel | Latest reply: Mazzaropi May 6, 2017
    3 replies
  • Excel VBA - Find and Expand matching cell entries Solved/Closed

    Hello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...

    RabbitWarren | Excel | Latest reply: x May 2, 2017
    1 reply
  • How to populate information on multiple sheets at once Solved/Closed

    Hi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...

    JPSpark | Excel | Latest reply: TrowaD May 2, 2017
    14 replies