Terminé

UOM Calculator for charging -- 2

We pick orders for different customers. I need to work out when a customer orders a certain amount of a particular product how many pallets, cartons, inners and eaches were picked to get to this quantity.

Example :

If you look at the 1st tab ( 3PL Sale Line Extract ) LINE 1 - customer ordered Item No. 855236 (column N) and we picked 5306 units (column R).

Now if you look at the 2nd tab ( Product UOM ) and look at line 49. You can see the same Item no. 855236 and can see how many units are on a full pallet, how many units in a carton, how many units in a inner and an each is 1 unit.

For this item no. 855236 the below amount are in each unit of measure :

Units on a pallet is 4800

Units in a carton is 240

Units in a inner is 10

Units in a each is 1

So to picked 5306 units I would have picked :

1 full pallet = 4800 units

2 cartons = 480 units

2 inners = 20 units

eaches = 6 units

TOTAL = 5306 units

I need to be able to them get full tally for every single product picked on the day. So ever line on the 3PL Sales Line Extract tab needs to reference the Product UOM tab and then tally the total in the last tab UOM Charging.

I need the formulas to cover to line 5000 on the 3PL Sales Line Extract Tab (incase we have busy days and a lot is picked ) & the formula on the Product UOM tab to cover to line 1000 ( incase new products get added to the range ).

Each day I want to paste the new data into the 3PL Sales Line Extract Tab and run a macro which automatically tallies the total of pallets, cartons, inners and eaches picked for the day in the UOM charging tab.

IMPORTANT : I need this is the next 2-3 hours so speed is of the essence for this job.

I hope this is enough information

Compétences : Excel VBA, Excel Macros

en voir plus : have 2 hundred thousands pdf documents that need to be typed up into word format one is 10 pages and the other is 8 as this is a, we are a beauty clinic that has been open in indonesia for 6 years we are specialising in permanent hair removal treatment, we are a beauty clinic that has been open in indonesia for 6 years, weight conversion calculator, r410a charging calculator, how to calculate refrigerant quantity, refrigerant charge calculator spreadsheet, conversion calculator, metric to imperial calculator, refrigerant calculation formula, refrigerant charge guide, calculator ipad 2, We are looking for a small square (10cm each side) 3 fold (6 page) flyer outlining our general services. Images and logo provide, We are launching a large scale drone racing competition, the formula one of Drone racing, Our aircraft will feature 300 - 800 hp, We are a popular Tabletop Games company that needs a new logo design based on a provided mockup. The logo should be of a 1:1 asp, We want to refresh our website and change to Magento platform coming 6 month, We want to refresh our website and change to Magento platform coming 6 month., We run a golf website (golfhuahin.dk) that needs a facelift as well as being turned in to a fully responsive site that we will a, magento 2 we can't place the order., how can we best help you get your job done

Concernant l'employeur :
( 0 commentaires ) Sydney, Australia

Nº du projet : #27550918

Décerné à:

nelumindralal

Hello, Is that the below arrangement by manually? 1 full pallet = 4800 units 2 cartons = 480 units 2 inners = 20 units eaches = 6 units TOTAL = 5306 units Contact me and discuss, I can do it I look forward to heari Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% AUD en 1 jour
(2 Commentaires)
1.7

3 freelances font une offre moyenne de 53 $ pour ce travail

finecodervw

Hi, As I understand you need Excel automation to calculate how many pallets, cartons, inners etc. were picked to get the quantity. I am well versed with Excel formulas and macros. It would help to do a quick discussi Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(6 Commentaires)
3.9
katalinmih

I have formula.I have formula.I have formula.I have formula.I have formula.I have formula.I have formula.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0