Hi there,
I have in one worksheet an excel table, where i have data in four columns,
lets say Name, Surname, Team, Subteam. I need in other worksheet
create a header. The header is name and surname of 1 employee
in one cell. so eg.
Jan Schmidt T1 ST1
Ken Hans T1 ST2
Barbie Doll T2 ST1
and so on..
so in first cell i need to have Jan Schmidt, in secod Ken Hans in third Barbie Doll and so on.

I don't know how to select the table data into a range or somethig,
where i can iterate on each row and select and output data, i need
an excel table, because when new employee is added, the macro should
automatically add new person in header.

Any help would be appreciated.

Thanks,
Kuba