Since there's only 7 sheets and the names can be in any column, I think I would
just do 7 of these:

Select the range
edit|copy
go to the new sheet (next available row)
edit|paste

(repeat 6 more times)


jourdan 1 wrote:

how do i take 2 columms of information 1 being names and the other being
shifts example 6-2 and putting them all on 1 seperate sheet i have 7 sheets 1
for each day.Also the names are not always in the sames colomms or even on
the sheet at all.please help

--

Dave Peterson