Hello there,
I am new to Excel Macro Programming. I need help to create a template that will help out with compiling production records.
1) The first master worksheet will let the user key in the number of pallets and the rolls per pallet that the job requires.
Eg. " let No. Of Pallets = X. No. of Rolls/Pallet = Y."
2)By doing this, the macro will create X more number of worksheets labelled "Pallet 1.....X" with a template with Y number of rolls. I have attached the necessary template for a clearer picture.
3)After which, there will be another worksheet to compile all the data into another sheet to calculate the grand total of the values keyed in.
In the attachment,
there are 3 worksheets
a)Mastersheet > where the X Y and Customer's name is keyed in.
b)Default Template > which will be cloned X number of times with the Label
c)Packing list > a list to compile all the data from the X Pallets and Y Rolls to find the grand total of respective values (length,weight)
The basic idea is to make it easy for the machine operators to use parts (a) and (b) and for the administrative staff to easily obtain necessary information from (c).
It would be great if anyone could help me out with the macro programming or guide me in a good direction to start writing the code.
Thanks and Regards,
Yi Sheng Chan
Bookmarks