Testing Author Royalities 1.xlsm
Still kinda new to the VBA programming. Got a bunch of help so far. Basically what I am trying to accomplish to make individual royalty sheets for each Author.
So far I am able to create a new worksheet for each Author, name it correctly, and paste in what books the Author wrote (starting at A51). Now the tricky part comes into play.
I need to look at each Book name and then compare it to the "REPORTS" wooksheet Column A, when there is a match, it needs to copy certain Columns from the matched Row. Once it is finished with that, in needs to keep checking, since there can be multiple entries of the same book name, the difference will be in the "transaction type", so it needs to copy the certain columns on that row and paste them into the new worksheet on the next line down.
Hopefully you can see the Example WorkSheet that I would like to finally have. called "Anderson,Jeff" It shows that he had written 1 book called "Go the Distance" A51 and that it actually had 2 different transaction types E16 and E17.
Unfortunately, the "REPORTS" will always be changing, books come in, books go away... Same with Authors, so the program has to be dynamic.
I will always start with the first 3 worksheets. "Reports" "Authors" and "Royality Blank"
Thanks for any help on this.