I want to know if it is possible to copy data in the same workbook from one sheet which compiles the entire months activity, to another sheet in the same workbook that has them separated by which team they are on.
Here is a sample of what I mean. I have sheets 1-3 by month, and I would like it if, as I enter information for a given month, that there is some kind of a macro that searches for the same name in the sheet that is separated by team number and inputs the information from the master to the one separated by team number.
Sample For Forum.xlsx
If someone could let me know if it is possible, I'd really appreciate it.
Bookmarks