Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. llolsen

    How to do a Date Macro In Excel

    Skip Not sure what I did wrong. Please see attached. http://www.mediafire.com/?mgwq2s7s26m5mwd
  2. llolsen

    How to do a Date Macro In Excel

    YOU ROCK! Thank you so much!
  3. llolsen

    How to do a Date Macro In Excel

    Date range is on a per employee basis. It is the days they were in a specific country. I know I would have to modify the statement for the different dates but it would be faster than me clicking on = and capturing each payment for the date range per person.
  4. llolsen

    How to do a Date Macro In Excel

    First column represent EE# Pers.No. Pmt date Amount 10000472 09/17/10 3,230.77 10000472 10/01/10 3,230.77 10000472 10/15/10 3,424.62 10000472 10/29/10 3,553.85 10000472 11/01/10 1,925.00 10000472 11/15/10 3,850.00 10000472 11/30/10 0 10000472 11/30/10 4,029.67 10000472 12/15/10 4,235.00...
  5. llolsen

    How to do a Date Macro In Excel

    For example, the below is a copy of data from worksheet for one person: 09/17/10 3,230.77 10/01/10 3,230.77 10/15/10 3,424.62 10/29/10 3,553.85 11/01/10 1,925.00 11/15/10 3,850.00 11/30/10 0 11/30/10 4,029.67 12/15/10 4,235.00 12/30/10 4,235.00 I need sub-total macro that will sum amounts...
  6. llolsen

    How to do a Date Macro In Excel

    I have a worksheet with payment dates per employee - I need a Macro that at sum the amount per person with a date range of month (first two digits of date field). can anyone help? thanks

Part and Inventory Search

Back
Top