thanks, i know its hard when I'm been slapped on the wrist for uploading an example documant and you cant see what im on about and i'm not the best at typeing stuff out online without rambling or repeating and can be consufing but I think you got me the help i need and I can now explain to people I'm working with what functions and what i need to get there.

Im just trying to automate as much as my excel work as I can, and find its a great way of learning macros and more in depth and new functions.