+ Reply to Thread
Results 1 to 14 of 14

Automatic invoice charges based on date selection

Hybrid View

  1. #1
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Automatic invoice charges based on date selection

    There is a mistake in the formula on the Dates worksheet in A20. The existing formula is referring to a non date cell.

    The formula should be:

    Formula: copy to clipboard
    ='Main Inv'!H13


    There is no way to test the rest of the workbook as it is linked to data not available.

    I hope this solves your problem.
    Last edited by newdoverman; 11-21-2013 at 12:35 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Automatic date, but after a dropdown selection is made, not before
    By FlyFisherman in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-18-2013, 08:43 PM
  2. Automatic selection of Date from dropdown list
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2013, 08:57 AM
  3. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  4. Automatic date selection in Excel 2007, VBA?
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2011, 09:06 PM
  5. summing charges based on date range
    By keith0628 in forum Excel General
    Replies: 1
    Last Post: 07-20-2007, 11:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1