Experience Level: Intermediate
I require a visual basic programme that links a main stock spreadsheet to individual product batch sheets. The Main spreadsheet contains the basic information of availability whereas the secondary sheets contain the details about what quantity was taken out at what date. The secondary sheet should be accessible by clicking on the product number (PO number) of the main sheet. The secondary sheet for a new product batch should automatically be created from an excel template. The updating of the secondary sheet should automatically update the main sheet. All the data should be editable even without macro intervention or disruption if possible. Quotation required asap.
There are no clarification messages.