I have an excel sheet with 20 categories, each on a different sheet in the workbook, the first sheet is called "Order", the other sheets are categories based on classification of food, Meat and Fish, Fruits & Veg, Frozen Foods, Diary etc. Each category/sheet has the same data/columns, (Product ID, Product name in English, Product name in French, Unit/Size, Quantity, Comments) Ideally the first column (Product ID) should be hidden.I need that when a quantity or comment is entered, that the entire row is copied to the first sheet "Order". And I need some type of control/restriction in place so that I can add or remove rows to each sheet but a "user" cannot edit that data.
145 freelanceria on tarjonnut keskimäärin 85$ tähän työhön
Dear sir, I read your requirement, i would like to work on this project and can complete with 100% accuracy with in the timeframe, waiting for your reply about this project Regards Habibullah