For every unqiue value of run a FOR statement

[widodude]

All,

Firstly thanks to SNB for the original code.

I've got a macro which takes source data from 'Source' worksheet and transposes those values into a target sheet.

It currently works for a single user name (Column 2 of Source sheet) however if I add another value to that it won't transpose those values.

So I think I need to run the FOR statement for every unique value.

here is the code

Please Login or Register  to view this content.

I've also attached the xls sheet. Ignore 'checklist' sheet.

regards

Wido