Hi, I’d be forever grateful if someone could create the appropriate macro code for me.
i basically want to be able to paste values+transpose and have it autofill down five rows, from columns G-R. I’d need this to be a loop so that i can continuously paste new sets of data in this same way on different rows (ie newly copied data would be pasted values+transposed across the same columns but starting on a different row and autofilled down 5 rows).
any help would be appreciated!
i basically want to be able to paste values+transpose and have it autofill down five rows, from columns G-R. I’d need this to be a loop so that i can continuously paste new sets of data in this same way on different rows (ie newly copied data would be pasted values+transposed across the same columns but starting on a different row and autofilled down 5 rows).
any help would be appreciated!