I would like to have a new sheet generated on open of workbook with sheet name generated in
sequence (i.e. main sheet has common data then each new sheet is named WMR#1... WMR#2.... etc.) ... but
populated with common data to all sheets i.e. Ship to data!
Or maybe not on open but on button click to generate new sheet!
Is there something of a template out there that I could then customize??
WOW... this is GREAT! I got is working before but yours is
so much more simpler! Now I just need to figure out how to lock some
of the cells so on the new sheets they can not change them...i.e the
cell that holds the WMR Number!