Jraj1106 thats brill but i need it to bring the sheet down so the line is displayed near the top so when i have 10000 entries after clicking macro the line with the data on will show and i wont have to scroll down but loving the response thanks