Michael Madigan wrote: > You might be able to do it in a macro, but I don't it can be done in 4 hours.
I agree. I think with all the tweaking, it'd take most developers 10 hrs at least. You've got to: 1) parse the rows by employee 2) set up the new worksheet to have columns for all of the categories in the employee's dataset...adding new ones where appropriate 3) cycle through the rows putting the amounts in the respective category column in the newly created output sheet 4) I neglected to mention...there's 3 tabs in this new output sheet--the AmEx charges (this data we're parsing), any out of pocket costs, then the summary tab which adds both together That's at a bare minimum. I'm going to email these steps to him and wish him luck, but I don't do macros anymore. I stopped doing that in 1998. ;-) -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com twitter: mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
