packing list serial number generator for boxes

​i want to pack books in boxes based on the total count route wise,area wise and subject code wise
the excel sheet has the following columns
centrecode,routeno,areano,subjectcode,subjectname,noofpackets



for example
1006 1 1 n23 history 80 --> after this a new column has to be created where the total no of boxes required must appear,serial number of six digits from- to,it must be the continuity of numbers for each centrecode


can some one help me to do this using vba , i am new to vba but i need to do this to stay in my present job.
this is very urgently required

i am very sorry for posting the same query in multiple sites but my activity is very urgent that is why i thought if any one of these forums can help me at the earliest it will be helpful to me
this is just an emergency situation for me to stay in my job.hope you will understand and so far i have not received any responses also for the same

conditions regarding the serial number generation


in the first row data
1006 1 1 01 GERMAN 16 14
there are 16 nos of 30s count and 14 nos of 10s count
so 16 times it has to generate 30s copies serial numbers (as shown in the output)
next 14 times of 10s copies serial numbers ( as shown in output)
this has to continue till end of file that is till the last row

THE SAME I HAVE TYPED IN THE ATTACHED EXCEL FILE

I have just typed the criteria in the excel sheet


each packet contains either 30 copies or 10 copies which is mentioned in the column number F and G ( 30s & 10s)
that is how the output table is created manually

if 5 packets of 10s count is available means 5 rows of serial number with packet number will appear
after that if 30s count is available for the same subject means that will follow next

I am trying all possible ways to get it but it is not happening that is why I need assistance from excel experts like you

kindly help me to solve this

hi
let me explain you

each row of data has got 30s count and 10s count of the subject,each packet can contain either 30 copies of the subject or 10 copies of the subject

for example first row in the excel sheet contains 16nos of 30s count and 14 nos of 10s count ( column F & G )

in our output we need to create 16 rows for 30s count and 14 rows for 10s count for the first row data

each row will have serial number like how it is given in the excel sheet output table

please let me know if you need further clarifications

i have made changes in the sample file for you to understand easily

Originally Posted by oeldere

This is a whole other question than the one you asked before.

It is normal practice to solve first question 1, and then ask for a solution in question 2.

Hi
May be I was unable to explain it properly in my previous posts but the process for the serial number generation is what I have explained in detail in the last attached worksheet

Now even if u just send me how to create the serial number generation means I shall try to manage somehow but I don’t know if my boss will accept to my solution tomorrow

If I am able to solve this means I will be continuing my job else I may be relieved

I don’t know how to create this in vba that’s why shared for help in the forum and I am able to see that only you have responded

Anyway if you can give me some idea on how to do this is also most welcome

Try

Please Login or Register  to view this content.

omg thanks to you and the almighty

the code works fine
thank you very much for understanding the query and solving it

Hi a small trouble in the code when i tried running it in the actual data
it shows error in this line saying object defined error
.Rows(2).Resize(n) = b

I just wrote the code for the workbook you attached, so no idea about your "actual data".

Hi

the actual data is also the same no of columns only but when i added a command button and copied the code,run it,showed the error
but the same code works in other new workbooks

hi
what i have done now is copied the actual data to a new workbook,added the code in it and able to see it works fine but I am wondering why the same code is not working the original data

Absolutely no idea...

no problem thank you very much for helping me

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.