excel 2010

  1. T

    How to stop Duplication on excel macro ??

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

    Solved Help with formula

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

    Solved Multiple Formula's In One Cell | Excel

    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?
  4. Adman8

    VBA Script for sending automatic reminder mails

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

    VBA Script for sending automatic reminder mails

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

    Excel gant chart for irregular repeated tasks

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

    EXCEL 2010 : Hangs - Dialog boxes appear in the background

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

    Printing every other page of an entire workbook

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