07-17-2012, 04:51 PM
This task is complex and difficult to understand for other person like me.
Using ExcelSheet is the best way to work with Excel (fast and reliable), but often instead can be used key commands + copy/paste.
If you are going to automate Excel in the future too, I recommend to learn how to do it with ExcelSheet. Start from something simple, for example create a macro that gets or sets a cell.
I can help only with particular steps. Begin to create the macro, and ask for assistance (here) when you don't know how to do something. Choose any method - ExcelSheet or key/copy/paste.
Using ExcelSheet is the best way to work with Excel (fast and reliable), but often instead can be used key commands + copy/paste.
If you are going to automate Excel in the future too, I recommend to learn how to do it with ExcelSheet. Start from something simple, for example create a macro that gets or sets a cell.
I can help only with particular steps. Begin to create the macro, and ask for assistance (here) when you don't know how to do something. Choose any method - ExcelSheet or key/copy/paste.