tuxy
09-06-2008, 07:54 AM
I have an excel file containing a list of record(500). Every record has a number that identifies the total qty of labels that should be printed Example:
A Data , Data , Data etc....3
B Data , Data , Data etc....4
C Data , Data , Data etc....2
I'm trying to create a macro that starting from the sheet above generates a new sheet with the following layout:
A Data , Data , Data etc....1/3
A Data , Data , Data etc....2/3
A Data , Data , Data etc....3/3
B Data , Data , Data etc....1/4
B Data , Data , Data etc....2/4
B Data , Data , Data etc....3/4
B Data , Data , Data etc....4/4
C Data , Data , Data etc....1/2
C Data , Data , Data etc....2/2
I cannot figure out how to performe this..........
Please someone can suggest me an example code?: pray2:
At present time I?m doing this job manually and with an avarage of 500 part number is a big deal...............:banghead:
A Data , Data , Data etc....3
B Data , Data , Data etc....4
C Data , Data , Data etc....2
I'm trying to create a macro that starting from the sheet above generates a new sheet with the following layout:
A Data , Data , Data etc....1/3
A Data , Data , Data etc....2/3
A Data , Data , Data etc....3/3
B Data , Data , Data etc....1/4
B Data , Data , Data etc....2/4
B Data , Data , Data etc....3/4
B Data , Data , Data etc....4/4
C Data , Data , Data etc....1/2
C Data , Data , Data etc....2/2
I cannot figure out how to performe this..........
Please someone can suggest me an example code?: pray2:
At present time I?m doing this job manually and with an avarage of 500 part number is a big deal...............:banghead: