Hey everyone, long time lurker but first time poster here. I've been interested in VBA for quite some time but have been avoiding it mostly because I understand so little of it. Anyways, I am interested in taking data that I will need to update every other week and splitting in to multiple sheets that already exist. 'RAWDATA' will be updated with thousands of lines of employee data that relates to their billable hours. I then need 'RAWDATA' to be split by StaffID and distributed to the corresponding sheets. The reason I don't want the data split into newly created sheets everytime is because next to each corresponding StaffID sheet (ex '178') there will be a sheet (ex '178SUM') which will be a summary of that employee's billable units linked to the raw employee data with formulas translating the billable units into what they will actually be paid for that period.
I have explored quite a few threads here but haven't quite figured out how to apply them to my probelm. Also, I tried to use this as a guide but have failed so far...
http://chandoo.org/wp/2012/05/14/vba...ltiple-sheets/
I was hoping to use the code from the link above but the data for that link is in column C and my data is in column A. I wasn't sure how to fix their code to correspond to my data.
The attachment shows my desired result. In the final product I will have many more StaffID's but this is just the initial attempt.
Any help would be greatly appreciated!!! And hopefully, this can be a gateway into furthering my VBA education.
Thanks!
Bookmarks