I would like a simple visual basic routine that will:
1. Look at a range in an Excel spreadsheet, copy the _first_ row of data, transpose it and insert it into a named range in a second spreadsheet. The second spreadsheet will perform a calculation on the data and put result data into another named range in the second spreadsheet.
2. The VB routine will then copy the result data in the second spreadsheet, transpose it, and paste it into the _first_ data row in a named range in a third spreadsheet.
3. The VB routine will then will go back to the first spreadsheet and copy the data in the _second_ data row, transpose it, and paste it into the named range in the second spreadsheet. The second spreadsheet will again perform the calculation on the data and put the result data into the other named range in the second spreadsheet.
4. The VB routine will then copy the result data from the second spreadsheet, transpose it, and paste it into the _second_ data row in the named range in the third spreadsheet.
5. This routine will continue until all rows of data in the first spreadsheet have been processed and all results are in the third spreadsheet.
6. Finally, the programmer must tell me how to change the name of the second spreadsheet so I can use different (second) spreadsheets as need be.
## Deliverables
1) A complete and fully-functional working program in executable form as well as complete source code of all work done.
2) Program must be in ready-to-run condition.
3) Program will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 98, Windows 2000 and/or Windows XP. It will perform it's operations on a set of three Excel spreadsheets.