Thanks, that helped a bit. But it seems that i need something a bit different. I mean the code works fine and does what i wanted, but when i use it again (press button), it links the previous buttons action to the latest sheet and doesnt leave it to the one i created earlier.
So I guess i would...
I havent used exel too much and even less VB, so my current code might be a bit messy as im building it bit by bit.
Anyways Im trying to make a button that creates a sheet, copies stuff from another sheet and pastes it in the new one, creates a button that takes user from the new sheet back to...
