Hello. I need a macro that will take hours by day (columns) by service (rows) per client (sheet) and summarize the data into one database of rows containing client, service, date, and hours. The "Summary of Charges" should only include service hours > zero. I am attaching a sample file. I have little to no experience with vba so I don't even know where to begin. I can copy code.
this code requires that the summary and the total tabs to be in front
Please Login or Register to view this content.
Last edited by rcm; 06-19-2014 at 11:52 AM. Reason: redundant code
hi pfi, welcome to Excelforum, option, please check attachment, run code "test"
RCM, worked beautifully! The only change I had to make was the text month/year to a date format. Thank you so much for both replies! I didn't need to try the other one. Thank you so much!
you are welcome please mark it as solved....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks