Keywords needed- Import data then Macros insert specific data into format

I would like to research and write the code myself, but I am having a difficult time putting in the correct keywords to get the instructions I need.

Task- Import data with 35 fields. I want to then create a macros to turn the data into a form (another, specifically titles spreadsheet) which only includes 8-9 fields, in a specific, formatted order, to submit to my sales force.

Keywords that have not worked are 'transfer data from one spreadsheet into another', 'convert spreadsheet into form', and many other variations of the like.

Suggestions? I have been running a family business for the last 8 months and have become very rusty with my VBA. (even though I still considered myself a novice, who want to learn myself)

I have attached a spreadsheet illustrating the before and after.

Thanks.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

Try something like this

Please Login or Register  to view this content.