Simple excel vba script for data between sheets and fromat

IN PROGRESS
Bids
2
Avg Bid (USD)
$33
Project Budget (USD)
$30 - $250

Project Description:
I need a vba script to transfer data from one sheet to another sheet.
I attached a sample of what i need done. Mostly it is a formatting thing related to the way we upload our inventory to our online shopping cart.

Here is my best description (it may be more clear if you are looking at attached workbook.
I have 2 sheets of data in a workbook. Sheet1 has the product list (400 products) and inventory separated by sizes. Sheet3 has a price variation for items that cost more or less depending on size.

I need sheet2 generated. There are about 9 columns from sheet1 that are just placed in the correct columns on sheet3 (labeled gray and orange). There is a range of data that is the size and count of products in inventory (column x-be). For each instance of a value on sheet1 in the that range there needs to be a new row created on sheet2 incorporating a few required formatting changes - like adding the header and some some stuff "| Size | X-Small" to the end of column 2 sheet2. As well it summarizes the sizes that have values at column AW. Additionally there needs to be a reference to sheet3 data because so items cost more for larger sizes and that data needs to be incorporated in sheet2

See attached file 'Inventory to cart modified for freelancer.xlsx' for a small sample of what i need converted and the output required.

I also attached 'sample conversion simple.xlsm' a script created for me to automate the most complicated part - although its simplified version of what I need (and been using to make sheet2 manual) for reference

Skills required:
Data Processing, Excel, Visual Basic
Additional Files: Inventory+to+cart+modified+for+feelancer.xlsx Sample+Conversion+simple.xlsm
Hire bosuck
Project posted by:
bosuck United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 35
in 0 days
Hire dasmoeh
$ 30
in 1 days