im currently trying to reduce paperwork and the number of workbooks for our small company. is it possible to have one worksheet with all information on it such as job orders, invoices, customer information but not all columns are visible to certain users?
e.g. workbook A contains all data
but user 1 can view and edit columns 1-5
user 2 can only view and edit columns 1-4
user 3 can view columns 1-4 but can only edit column 3
im hoping this could be done by assigning passwords for each column as i am not very tech savvy and know nothing about networking,database and the like
would appreciate any help