thank you the doc man this is actually the site i was referring to , ive downloaded there sample transposing tool, which is kinda what im after but i cant seem to get the code to work with my tables , im not bad with VBA but again self taught so anything new is like reading another language i am...