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 [url removed, login to view]' for a small sample of what i need converted and the output required.
I also attached 'sample conversion [url removed, login to view]' 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