Search Results for ‘excel 2010’

I'm updating a spreadsheet that currently manually logs employee vacation time. It's formatted in two cells like this: 20D | 0.00H (meaning 20 days, 0 hours; the "D" and "H" are added automatically in the formatting) As vacation days are reduced, let's say by 4.75 hours one week, then I...

Good afternoon , i am Tssash and i am currently working on a project to sync excel to outlook calender . This is my coding so far ( down below ) , i am currently wondering how do i stop duplicates of previous row of exisiting events/appointment.?? Much help would be appreciated , thank you

Good afternoon, It's been some time since I've posted on here. I have a spreadsheet which has a number of sheets and one that collates stats from a huge list of data. I use a formula, which looks through the data and returns a number based on number of visits in a month: =SUMPRODUCT(('All...

I am currently using the formula =SUM(B3*140%) to get a mark-up of 40% when entering a price, but I would like to round this up to the nearest £0.50. Please see spreadsheet attached. Is there anyway to add this formula along with the current one?

Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...

Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...

Hi All, I need to create a Gantt chart that shows how long it is taking to approve construction drawings. I have attached a schedule of the drawings in question with each one having its own reference number and a issue and review date for each revision. I need the Gantt chart to show the time...

Hi, This is my first post, So if I need to change anything, let me know. I could not find anything on this subject when I was searching. I have a user saving documents locally (Local Save As) When this (or any other) dialog box pops up, it does in the background. This causes Excel to...

I am trying to write a macro that will allow me to print either only the first or second page of the 30 or so Sheets I have in an open workbook. I found how to print the second page of an open sheet and how to print all pages of the workbook but I need help combining the two! I am using this for...