excel funtion to make number automatic at packing list

pencari

New Member
Joined
Dec 19, 2014
Messages
3
hi, mrexcel forum guys, sorry for my rudeness because my 1st posting is asking..

btw,im trying to make excel data, that gather from another sheet

the example

database
invoice numberpacking pack
20020
20115

<tbody>
</tbody>

Example
packing list 1

NumberPAcking List
(auto)1(auto)2 Pack
(auto)2(auto)2 Pack
(auto)3(auto)2 Pack
(auto)4(auto)2 Pack
(auto)5(auto)2 Pack
(auto)6(auto)2 Pack
(auto)7(auto)2 Pack
(auto)8(auto)2 Pack
(auto)9(auto)2 Pack
(auto)10(auto)2 Pack
invoice number(which im using index & match function) 200

<tbody>
</tbody>

example 2
packing list

NumberPAcking List
(auto)1(auto)2 Pack
(auto)2(auto)2 Pack
(auto)3(auto)2 Pack
(auto)4(auto)2 Pack
(auto)5(auto)2 Pack
(auto)6(auto)2 Pack
(auto)7(auto)2 Pack
(auto)8(auto)1 Pack
invoice number(which im using index & match function) 201

<tbody>
</tbody>

im tryng to make that automatic , but im struggle with what function that i use...

can someone have an idea?
please share...

sorry for my bad english
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
I'd be glad to try to help you out... I'm not sure what part what you want to be automatic. What does your INDEX/MATCH formula look like?
 
Upvote 0
I'd be glad to try to help you out... I'm not sure what part what you want to be automatic. What does your INDEX/MATCH formula look like?


the auto part is the number of packing...

if i have 20 pack, so automatic 10 packing, with each 1-10@ is 2 pack..

when i have 15 pack, automatic 8packing, with 1-7 @ is 2 pack and the last 8 is 1 pack

sorry for the index match formula..

just ignore it
 
Upvote 0
I don't understand what you need. Maybe post a sample spreadsheet or attach a spreadsheet with very obvious markers for what you want to be done.
 
Upvote 0

Forum statistics

Threads
1,215,491
Messages
6,125,098
Members
449,205
Latest member
ralemanygarcia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top