Copying from one sheet to another sheet

could you just right click on the tab and use the move or copy, then use copy tab to the other workbook? (don't forget to use the create a copy unless you actually want to move it.)

wow, I see what you are trying for. So you are trying to get the first attachment to look like the second attachment?
Either way I think that will take VBA. It might possibly be done with a formula but I can't come up with a formula for it. If it was my data I might try to do is put it in Access then do a crosstab query. I'll be watching this post to see if someone can devise a formula for it. Good luck!

Yes, thats what Im trying to do. hoping somebody can help me.

Also Cross posted to the link below:

https://chandoo.org/forum/threads/co...er-shee.39789/
https://www.excelguru.ca/forums/show...-another-sheet

Sorry for not updating the links immediately.

Thank you