Office Software Forum - solved topics

Ask a question
Results 551 - 600 of about 2,650
  • Solved
  • Conditional format to highlight cell based on date Solved/Closed

    hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...

    kieferschild | Excel | Latest reply: Mazzaropi Aug 26, 2016
    7 replies
  • VBA search column for matching string Solved/Closed

    I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a c...

    pidge | Excel | Latest reply: Juzer Aug 25, 2016
    5 replies
  • negative cells Solved/Closed

    Hello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become positive n...

    whatsit | Excel | Latest reply: Mazzaropi Aug 24, 2016
    3 replies
  • calculate no of days left from today to a future specified date Solved/Closed

    Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116

    raghs | Excel | Latest reply: TrowaD Aug 23, 2016
    2 replies
  • Compare columns and create list of duplicates Solved/Closed

    Hello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...

    CarlosIRL | Excel | Latest reply: CarlosIRL Aug 15, 2016
    2 replies
  • need help to macro my invoice number Solved/Closed

    Hello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...

    Janit | Excel | Latest reply: ac3mark Aug 12, 2016
    6 replies
  • search value error Solved/Closed

    HI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...

    Stu | Excel | Latest reply: Mazzaropi Aug 12, 2016
    3 replies
  • Nested If Statement not working Solved/Closed

    Hello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE =IF(AND(I6>=C7,I6=F7,I6=C7,I6=F7,I...

    Mimi | Excel | Latest reply: Mimi Aug 10, 2016
    2 replies
  • Macro - pictures to excel acc to name Solved/Closed

    Hi, I have an issue - I checked all forums I could, but with office 2013 and changed excel functions, I got lost. My excel has pictures names in...

    Northimn | Excel | Latest reply: Northimn Aug 10, 2016
    2 replies
  • Suddenly unable to send emails Solved/Closed

    I am able to receive emails just fine. Going to the webmail server on the web I can both send and receive emails. I've tried adjusting settings on my ...

    DaveBHastings | Outlook | Latest reply: DaveBHastings Aug 7, 2016
    4 replies
  • Conditional formatting based on two cells (date and comment) Solved/Closed

    Hi guys and dolls, I am hoping one of you clever people might be able to help me... I am trying to highlight a cell when 1. a date has passed ...

    jayelpe | Excel | Latest reply: jayelpe Aug 4, 2016
    2 replies
  • If multiple cells contain value then add value Solved/Closed

    Trying to think of the best way to sort this problem! . I have a spreadsheet with a list of customers that have purchased a vehicle. Along side in...

    Robert Bell | Excel | Latest reply: Rob Aug 3, 2016
    2 replies
  • odd and even cells Solved/Closed

    Hello, I am trying to link cell C1 to cell F6. But if cell C1 is an even number I need it to add 1 to that number ( cell C1) and put it into F6. If ...

    whatsit | Excel | Latest reply: YasserKhalil Jul 31, 2016
    5 replies
  • HELPP!! Simple MACRO help! Solved/Closed

    Hello, I would like to create a macro that will scan sheet one for cells that contain the word "Complete", Copy the whole row, and paste it into a...

    lsn11 | Excel | Latest reply: vcoolio Jul 26, 2016
    4 replies
  • outlook backup Solved/Closed

    Hello, how to take outlook backup one machine to another machine Plz reply me Thanks Configuration: Windows Vista / Firefox 47.0

    amolsankpal | Outlook | Latest reply: amolsankpal Jul 26, 2016
    5 replies
  • IF formula help Solved/Closed

    Hello, I am needing a formula like this =IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no") but if the cell B4 is blank. I need a blank " ". ...

    GF | Excel | Latest reply: GF Jul 22, 2016
    2 replies
  • Creating a payback calculator with rate change Solved/Closed

    Hey, having a bit of trouble, appreciate any help. I am trying to create a payback calculator where you input: Initial Investment Rebates Annual...

    jojosabadar | Excel | Latest reply: jojosabadar Jul 22, 2016
    7 replies
  • Conditional Formatting Based on Data in another Cell Solved/Closed

    Hello, I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either all...

    anniedavis1980 | Excel | Latest reply: ac3mark Jul 21, 2016
    4 replies
  • Excel has file big size Solved/Closed

    Hello, Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of th...

    RossHutton | Excel | Latest reply: RossHutton Jul 21, 2016
    4 replies
  • Conditional Formating: formula cell text change color Solved/Closed

    Hello, How do I get Text in a Cell to Change from Black to White, based on data? The cell already contains a formula to extract data from elsew...

    Marshall | Excel | Latest reply: ac3mark Jul 20, 2016
    3 replies
  • Conditional Formatting when a cell says "NO" Solved/Closed

    Hello, I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. W...

    Grace C | Excel | Latest reply: Mazzaropi Jul 18, 2016
    3 replies
  • If a cell has a certain value after certain date, color the row Solved/Closed

    Hello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A: Create BR...

    ManxMaggie | Excel | Latest reply: ManxMaggie Jul 18, 2016
    4 replies
  • Matching 2 values from one spreadsheet Solved/Closed

    Hello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to populat...

    sargiesan59 | Excel | Latest reply: sargiesan59 Jul 16, 2016
    3 replies
  • Change text in cell if other cells have any values Solved/Closed

    Hello, I am working on a spreadsheet where I have 5 important columns. Column B is the "Completed" category. Columns C, D, E & F will all contain ...

    C.J. Leffel | Word | Latest reply: C.J. Leffel Jul 15, 2016
    5 replies
  • How to count how many times a number appears in a spreadsheet? Solved/Closed

    Hey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadshe...

    kimipapineau | Excel | Latest reply: kimipapineau Jul 15, 2016
    4 replies
  • Excel formula Solved/Closed

    Hello, I am having trouble getting the right formula for: Column O is equal to column N if Column C contains the text "Mastercard." Nothing I'...

  • Recover corrupted PDF files Solved/Closed

    Hello, I'm trying to recover a folder with some critical data that was damaged or corrupted, likely by a virus. It’s a 10GB folder that contains P...

    StevenMiller | PDF | Latest reply: Ambucias Jul 13, 2016
    1 reply
  • comparing the two names respective of Upper & Lowercases letters Solved/Closed

    Hello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...

    KICK | Excel | Latest reply: ac3mark Jul 11, 2016
    7 replies
  • comparing 2 columns from 2 different spreadsheets Solved/Closed

    Hello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer numbers Spreadsheet 2...

    agauth | Excel | Latest reply: agauth Jul 8, 2016
    2 replies
  • compare two columns input value from another Solved/Closed

    Hello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...

    blmcamp | Excel | Latest reply: Maureen Jul 6, 2016
    2 replies
  • Highlight cell if another cell contains any text Solved/Closed

    Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...

    LvH | Excel | Latest reply: LvH Jul 4, 2016
    4 replies
  • EXCEL VBA: Application.FileSearch Error in Running Excel 2013 Solved/Closed

    Hello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to 2007).Up...

    g.cabal | Excel | Latest reply: TrowaD Jun 28, 2016
    6 replies
  • Copy paste special into last row of another worksheet Solved/Closed

    Hello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am ...

    Roy | Excel | Latest reply: TrowaD Jun 27, 2016
    3 replies
  • Microsoft Outlook keeps sending the message Solved/Closed

    Hello, I have Windows Vista with Office 2007. Microsoft Outlook has been working fine for 18 months but has suddenly developed a fault when sending e...

    Bill | Outlook | Latest reply: Emma Jun 21, 2016
    11 replies
  • Roster Management Spread Sheet. Solved/Closed

    Hello, Can anyone help with a spreadsheet to manage fatigue management. I have a work project where I need 20 people and for both day and night ...

    ad1959 | Excel | Latest reply: TrowaD Jun 21, 2016
    1 reply
  • If certain 'type' is in col. K have whole row copy to new sheet Solved/Closed

    Hello, I am wondering if it is possible to have a whole row copy to a designated sheet based off of the value in a column. So for example if my ro...

    Dani | Excel | Latest reply: vcoolio Jun 21, 2016
    2 replies
  • Finding MAX value with criteria list Solved/Closed

    Hello Chaps I don't often ask for help here but this one has stumped me. For a dashboard of sorts... I have a list of values in column S. E...

    RayH | Excel | Latest reply: fdibbins Jun 20, 2016
    11 replies
  • Convert Single Column to Rows, into Matching Rows Solved/Closed

    Hi, I would really appreciate any help with an issue I currently have. I have a file which downloads as ASCII (text), and when opened in excel give...

    alansanderson | Excel | Latest reply: TrowaD Jun 20, 2016
    4 replies
  • Need help with counting value formula Solved/Closed

    Hello, I am brand new. I am trying to figure out a score based counting formula. I have columns with Name, Status, Rank and Value I want the v...

    QAA007 | Excel | Latest reply: QAA007 Jun 17, 2016
    3 replies
  • Extract data from one sheet to another Solved/Closed

    Hello, I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1...

    phanikr | Excel | Latest reply: Mazzaropi Jun 17, 2016
    1 reply
  • Copy a row from one worksheet to another, based on criteria Solved/Closed

    Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas alread...

    Amegolas | Excel | Latest reply: TrowaD Jun 16, 2016
    5 replies
  • Write text in adjacent cells if one cell value is ___? Solved/Closed

    Hello, My knowledge of excel is very basic, but I am interested to know if I can find an easier way to enter information. I'm a tea manufacture...

    teaguru | Excel | Latest reply: teaguru Jun 14, 2016
    2 replies
  • Help! Need to copy only some columns in rows that have X condtn Solved/Closed

    OK, Full disclosure, I am a Novice Excel user at best.....I have a Google Sheet Workbook that contains Google Form Responses (the Sheet name that thes...

    TallPoppy | Excel | Latest reply: vcoolio Jun 11, 2016
    5 replies
  • Use of '@' in formulae Solved

    Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Reta...

    Quarterp | Excel | Latest reply: Quarterp Jun 10, 2016
    6 replies
  • How do i change date format in ( Solved/Closed

    Hello, How do I change the date format from (dd/mm/yyyy) format to ( format? And how can I get today's date in dot format (

  • conditional Formating question Solved/Closed

    Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has ...

    sforde | Excel | Latest reply: sforde Jun 8, 2016
    2 replies
  • IF formula with dates Solved/Closed

    Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and en...

    CeskyWater | Excel | Latest reply: CeskyWater Jun 8, 2016
    2 replies
  • Creating master spreadsheet for mailing information Solved/Closed

    Hi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I wa...

    Notsonerdy | Excel | Latest reply: vcoolio Jun 3, 2016
    12 replies
  • Macro only for Alphabetic Sheets Solved/Closed

    Hello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks & Regards...

    smuneeb | Excel | Latest reply: smuneeb Jun 3, 2016
    2 replies
  • Excel VBA to open a EULA script when opening a spesific workbook Solved/Closed

    Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...

    DataRV | Excel | Latest reply: vcoolio Jun 2, 2016
    3 replies