I have a worksheet in which i have a format in place to enter prices collected from diff suppliers.
Col A has the field titles...eg. Name of factory, Contact person, Min Order Qty, Rate /pc, Pcs in a carton, CBM per carton, Weight per carton etc.
Col B onwards, the data has to be entered, with Col B for Supplier1, Col C for Supplier 2..and so on.
The data entry is upto row 10.
from row 20 onwards, i have put my formula to calculate cost of cargo, commission, taxes, margin etc...to arrive at my final pricing. This ends at row 30. So i have hidden rows 20 to 30, and password protected my sheet.
this file is given to 5 of my team members to collect data from their suppliers. So I may get prices from 1 supplier, Member1 may get from 4 suppliers, Member2 from 3 suppliers etc. Also, the same format is saved as another file, if the item to be sourced changes.
Once i get their final files by email, i unprotect each file, and copy the columns into my worksheet.
Is there a better way to do this in excel? Using shared workbooks for instance? But then, i am unable to protect the workbook. Also, if everyone enters data into col B...it gets overwritten.
any suggestions?
Bookmarks