(Solved) – How do i copy, transpose and add new sheets


I have the following data from my sheet1:

i want to make at VBA that can:

1: create a new sheet for each row there is.

2: then it should copy and transpose the numbers into every sheet, so in this example i would end up with 4 sheets, like so:

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *