In Progress

Simple excel vba script for data between sheets and fromat

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

Skills: Data Processing, Excel, Visual Basic

See more: excel data transfer sheets sample file, what its freelancer, what freelancer changes, visual basic cost, vba freelancer excel, simple description for freelancer, script sheets, reference freelancer, product data sheet freelancer, price for vba for excel, online for freelancer, new freelancer script, need for data processing, my excel online, me excel, manual freelancer, list of best freelancer online, i need excel freelancer, freelancer what its, freelancer reference, freelancer price range, freelancer online what i need, freelancer online version, freelancer online excel, freelancer new version

About the Employer:
( 2 reviews ) Honolulu, United States

Project ID: #1190161

Awarded to:


Excel Vba experience of 15 yrs. Please see PMB for more details. :)

$35 USD in 0 days
(112 Reviews)

2 freelancers are bidding on average $33 for this job


Hi, i can do this for you.

$30 USD in 1 day
(5 Reviews)