Use VBA to copy sheet number of times based on cell?

[ColdWater]

I have a simple excel sheet, 8 cells:

PO#
###
Item #
###
Pieces
##
Carton #

Is there a vba formula that will copy all of the cells and paste into seperate sheets based on the pieces cell? For example if there are 8 peices, then it would output 8 sheets and increment the carton # from 1 through 8 on each sheet?

[Norie]

Something like this perhaps.

Please Login or Register  to view this content.