excel 2013

  1. C

    Solved Identify latest record

    Hi :) I have a table with the columns: Name, Date. [[Excel 2013]] There are multiple instances of the same name, along with different dates, eg: John Doe 19/02/19 John Doe 18/02/19 John Doe 17/02/19 i need to identify the latest date for that person. I would like another column...
  2. R

    Linking checkbox to Date and Time Picker

    Hi everyone, This is my first post on here. I'm not particularly familiar with VBA but think I will need to use it to accomplish what I want. I've created multiple date and time pickers for different stages of completion that the user is supposed to select which then gets assigned to another...
  3. H

    Solved Excel and Emailing AGAIN!

    Good day, First I'd like to say...This site is a great learning resource! Learned so much about VBA and Macros in just two days. Now the issue. I found two great codes that I will 'splice' together to get what I want...
  4. E

    Have 2 formulas in one cell and want to choice of which

    Hi there, I have 2 formulas in one cell and want a choice in which will populate. EX. =DATEDIF(F12,TODAY(),"d") & "-" & DATEDIF(F12,G12,"d") I want it to choose first formula if G12 does not have a date. REVISED: I am working on an on time delivery. I have the date the customer requested...
  5. I

    Recover Corrupted Excel Files (password protected)

    Hi, I have encountered this problem which is bugging me for days now. I was just creating back ups of my files to a different location of my PC (diff. partition, to be exact), the usual copy and paste. After a few minutes, I got this error that says 123.xlsx cannot be copied because the file...
  6. C

    issues with Excel formulas

    I have a pricing spreadsheet that I am working with and sometimes when I try and do a sum of three different column totals which have already been individually added up =sum(B2, C2, D2) as an example, Sometimes, I will get a blank cell after hitting the enter button and sometimes I will not...
  7. S

    Excel 2013 - Help/advice on creating macro to send mail

    Hello all, Am hoping someone may be able to help me with a task I am trying to complete. I have a work book that I need to edit on a daily basis, and I ideally want to be able to send an email to specific email address when a date is input. I have attached a copy of the workbook for perusal...
  8. E

    Trying to send email when a cell gets to a certain value

    I have searched the web for this and everything i see involves writing code. I have done anything like this so i need some help. I have a inventory sheet that has formulas in it to count down as items are used, these numbers are inserted. then the calculations take over. Here is a sample: item...
  9. L

    Solved Email when close to expiry date

    Hi all, I had a thread open a few months ago in regards to sending an email everytime an excel sheet is open to let colleagues know of expiry dates that are 90 days away (or ones that have already passed expiry. I have this currently written up in VBA, however it's not bringing up number of...
  10. cwwozniak

    Entering Chinese Text in Excel 2013

    The company I work for is in the USA and is running a US version of 64 bit MS-Windows 8.1 Professional on desktop computers. We are running MS-Office 2013. Several people exchange MS-Excel files with the factory in Taiwan. A few people are finding it cumbersome to edit or enter Chinese text into...
Top