Hi all...I have been searching this forum for a few weeks now getting familiar with VBA and its capabilities. This is my conundrum...I wish to copy data from specific cells in one worksheet to specific cells in another. Due to proprietary information I am unable to post the workbook, but maybe someone here can help with this information.

First worksheet is a product configurator and contains cells A7, B7, merged cells (yeah, I know - not my idea) C7-E7, and F7 that I wish to copy to the specific cells in the second worksheet, which is a purchase quote.

Basically I'm taking a product number (A7), a price (B7), a product description (C7 - E7), and vendor part number (F7) and populating specific cells in the second worksheet, not in the same order. Then the customer will return to sheet 1, configure another product and add it on the next available row on the purchase quote. Bear in mind that the cells on worksheet 1 are populated via concatenation and I wish to copy the data in the cells and not the formula using a button.

Thanks in advance...