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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to do a Date Macro In Excel
Skip Not sure what I did wrong. Please see attached. http://www.mediafire.com/?mgwq2s7s26m5mwd- llolsen
- Post #12
- Forum: Microsoft: Office
-
How to do a Date Macro In Excel
YOU ROCK! Thank you so much!- llolsen
- Post #11
- Forum: Microsoft: Office
-
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.- llolsen
- Post #8
- Forum: Microsoft: Office
-
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...- llolsen
- Post #5
- Forum: Microsoft: Office
-
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...- llolsen
- Post #3
- Forum: Microsoft: Office
-
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- llolsen
- Thread
- Replies: 12
- Forum: Microsoft: Office
