[xpost][/xpost]
xposted: https://www.excelforum.com/exc…or-boxes.html#post5383543
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