Need code that will allow me to copy/paste daily total (extracted data) for each team into another Excel workbook with a table similar to the one above. I have 11 sheets, one per discipline, that contain anywhere from one up to fifteen teams each (all with different bug totals per day). This data can only be extracted by discipline, and comes out looking like this:
I have to do this 11 times, so it’s already tedious enough. Then, each discipline has up to multiple teams; so it’s a ton of copying pasting. Note: there are days when Team 5 of Discipline 1 has zero bugs, so the extracted data looks like this where Team 5 is omitted:
Is there a way for me to paste values for only those teams that are included in the extracted data? Moreover, can Excel do a search by team name, then look for the next blank cell in the row for that team and paste (i.e. Team 1, 28-Mar, since 27-Mar has data)? I’m a serious VBA beginner, but I’m hoping someone can give me a jump start on this to save me some time while I learn VBA. This report is taking too much time to do, and it seems VBA is the only way to accomplish this? Whatever the case, I currently don't know how to get it done except manually.
I hope this makes sense. Thanks in advance for any amount of help you can offer.