I think you can make those things in Excel with Macro recorded. After that you can check and use the code of macro which can guide you how to copy...