Hi Paul

Yes u are right. The item 4 , item 5, item 6 should belong to column G-k.
when there is only 1 sheet which show item 1-6, then we handle by our
hand easily. when there is over 100 sheets which show similar things. then
we need VBA code to help us.

Tks
Tom
merry christmas and happy new year