I am provided with a data dump out of my system. The first tab called Source Data is what the data dump will look like. As you can see, some people can punch in and out during the same day. I want to add up the total hours and dollars for work done in the same day and make it one line item.
I created a pivot table in the Converted Sample page that is hidden and then linked the data into a cleaner looking table.
I need a VBA code that will take the Source Data and copy it to another worksheet so it looks like the Converted Sample Data. Should be very easy to do.
Bookmarks