Excel Macro Input From Clipboard Data

Hi!! I am in search of an Excel Macro program(s) to accomplish the below. Prospective candidates should have a decent command of the English language and experience in programming Excel macros. Only serious bidders and reasonably priced bids will be considered. Timely and successful completion of this project can lead to future projects. Your questions and suggestions are welcome. Thanks for your interest and bid. I need TWO EXCEL MACROS to insert standard name and address informaton. And also, to parse and paste the data I have in the clipboard, into two Excel workbooks. The FIRST MACRO will write to [login to view URL] (see attached) only. 1) If empty, fill in cells B1 (current date) through B9 with name and address information (to be provided) In the clipboard, I will have a string containing: 'MerchantSKU',’ASIN’,'Quantity','item-condition' Code. (Example 1: 01292013_182,B0002DSQ1A,41,25) 2a) Parse/Paste from the clipboard the 'MerchantSKU' to the next available cell in Column A (beginning at A13). 2b) Parse/Paste from the clipboard the 'Quantity' to the same row cell in Column B. 2c) From clipboard data (Example 2: 01292013_182, B000O78614,47,18)(Example 3: 2014-01-06-104, B000SINSXU,3,9), I have pasted the output that I want to attached files. ------------------------------------------------------------------------------------------------------------ The SECOND MACRO will write to [login to view URL] (see attached) as per 1) & 2) below. 1) If empty, fill in cells B1 (current date) through B9 with name and address information (to be provided). In the clipboard, I will have a string containing: 'MerchantSKU',’ASIN’,'Quantity','item-condition' Code. (Example 1: 01292013_182,B0002DS22A,11,20) 2a) Parse/Paste from the clipboard the 'MerchantSKU' to the next available cell in Column A (beginning at A13). 2b) Parse/Paste from the clipboard the 'Quantity' to the same row cell in Column B. 2c) From clipboard data (Example 2: 01182013_052, B000O98123,4,22)(Example 3: 2014-01-06-119, B000SINEET,2,4). I have pasted the output that I want to the attached files. The SECOND MACRO will ALSO paste from the clipboard (and also a user prompt) to [login to view URL] (see attached) as per 3a – 3i) below. 3a) Parse/Paste from the clipboard the 'MerchantSKU' to the next available cell in Column A. 3b) Parse/Paste from the clipboard the 'ASIN' to the same row cell in Column B. 3c) Print “1” to the same row cell in Column C. 3d) Prompt User for 'price' and enter into the same row cell in column D. 3e) Parse/Paste from the clipboard the 'item condition' code (1,2,3,4, or 11 ) to the same row cell in column G. 3f) Print 'item note' into the same row cell in Column M (depending upon the 'item-condition' code used in 3e) above – Column G). This is a short, three sentence paragraph that differs for each of 5 ‘item-condition’ codes (1,2,3,4,11), and will be provided. 3g) Print string “AMAZON_NA” into the same row cell in Column N. 3h) Print string “A_GEN_TAX” into the same row cell in Column O. 3i) From clipboard data (Example 2: 01182013_052, B000O98123,4,22)(Example 3: 2014-01-06-119, B000SINEET,2,4), I have pasted the output that I want to the attached files.