VB code needed to transpose.....

[Zakkala]

Hi there,

I need to take the data from a worksheet called 'filtered' and transpose it onto another worksheet (so that data in column A on 'filtered' will be across row 1 on the new worksheet etc). The amount of data on 'filtered' will be variable.

Does anyone know some code that will do this?

Cheers.