Automation in excel

thank you guys. it works now. i can proceed now.