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.
5 freelancers are bidding on average $51 for this job
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.