Search Results for ‘excel 2013’

Hi. Im currently using a Visual Foxpro program made by our government for filing our taxes. An error message keeps popping up everytime I try to generate an Excel report (please see attached pic for reference). Im not entirely sure what the error means but so far I've tried uninstalling the...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...