Simple excel vba script for data between sheets and fromat

This project was successfully completed by koolsidz for $35 USD in a day.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
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 [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

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online