excel funtion to make number automatic at packing list

[pencari]

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 number	packing pack
200	20
201	15

<tbody>
</tbody>

Example
packing list 1

Number	PAcking 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

Number	PAcking 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

 

[svendiamond]

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?

 

[pencari]

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

 

[svendiamond]

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.

 

[pencari]

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.

sorry for my bad english... i have attached the example
thx for the help sir...

https://app.box.com/s/fajqo95av64r7u4le8ym

here is the book1

im not sure that i can post attachement in here