In Progress

Build excel template to pull data from a table

I need to build an excel template that pulls data from one tab to the other. The data in tab 1 is based on a calculation and is horizontal. The data needs to pull vertically into tab 2 based on a calculation & info in tab 1.

Tab 1 has style's and their corresponding size box. Each size box has an array of individual sizes inside. For example, I ordered 10 units of box #12222; however, box #12222, has 1 size 5, 1 size 7, and 1 size 8 inside. Therefore, if broken down, I am ordering 10 size 5, 10 size 7, and 10 size 8. This is already calculated and broken down in tab 1 with formulas. What I need help with is pulling data from that table to populate the size breakdown within each box and total units ordered of that size into tab 2, fields in red vertically.

Skills: Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic

See more: excel template import data visual basic, create excel template import data, write excel file dataset data table, excel macro pull data cell, creating excel template importing data, vba excel charts show data table, excel macro pull data internet, open xml excel data table template csharp, excel macro pull data, excel template survey data, excel template synthesis data, excel template website data entry, creating excel template export data, excel macro pull data from website, excel vba pull data from a website, excel vba pull data from a website youtube, excel vba pull data from access, excel macro pull data from another workbook, excel vba pull data, populate excel template with data

About the Employer:
( 0 reviews ) New York, United States

Project ID: #19920233

Awarded to:

dgled

Hi, I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, sc More

$60 USD in 1 day
(78 Reviews)
7.0

5 freelancers are bidding on average $51 for this job

lightingdavid

Hello. I 'm expert in "Visual Basic, Data Processing, Data Entry, Excel, Microsoft Office" and I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description care More

$50 USD in 1 day
(89 Reviews)
5.8
DianaO8

I’m available from Wednesday to Sunday for two weeks, therefore I can manage to develop what you need on excel.

$83 USD in 8 days
(0 Reviews)
0.0
TBryantJr8675309

Sounds very straight forward. Population of one tab with data from another, could create a macro for you to pull the data with, or simply have it as a constant running formula.

$35 USD in 2 days
(0 Reviews)
0.0
Tesleem1

Perfect error-free work guaranteed Relevant Skills and Experience Microsoft Office suite package. A very computer savy freelance writer

$25 USD in 3 days
(0 Reviews)
0.0