<--- Go Back Go back to main site

Topic: VBA & Excel Name: Anoxic Date/Time: 01/12/10 8:08:17 AM Message: Yeah, so I'm working on a sucking up project for my supervisor. We have a schedule for the month, and we're trying to calculate the amount of money the department spends on overtime every month. Right now, I have an Excel spreadsheet. I have the date set using the Date formula (=date(2010, 2, 1); and a day using the workday formula(=workday("the date below"), and formatting the cell to read ddd instead of outputting a number. I hope this makes sense. Anyways, I'm trying to figure out a macro to find all the days are Sat or Sun and copy the columns into a new spreadsheet. I tried to ask some "experts" on a forum, but the "expert" told me they'd need 30 bucks to program it for me... Any assistance would be appreciated! Delete

ID: 1 Name: Xruptor Date/Time: 01/15/10 11:48:15 AM Message: In order to process the data correctly I would need an example spread sheet Anoxic. Just email an example and I'll see what I can do for you Delete

ID: 2 Name: Xruptor Date/Time: 01/15/10 11:49:17 AM Message: Btw if you don't have my email, then just use this form http://www.manaflux.com/contact.php to send me your email OR you can text me Delete

Add A Reply Name: Response:

<--- Go Back Go back to main site