I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year.
My current plan, was to create a Template, then have a sheet for each person. This way I can request them to 'update' only the lines that are relevant to the Bulk Buy (these are staggered throughout the year). I can then use a report to pull in all the updates.
However, I don't believe that if I add new products to my Template that these will automatically be added to the sheets that have been created from the template. Which would mean I would have to manually copy the new lines across 29 sheets. I was wondering if anyone has any other ideas how I could potentially do this to save myself some time?
*Please note, my plan for the template is to to hierarchy the products in a list - with the columns being ID/Description/Price/Qty/Rebate/Current Supplier. I would be adding new Hierarchies as the product list grew.