Adding passwords to different sheets in Excel within teams
I have a joint team who use Excel, there is a sheet for everyone to add their details on, is there a way that there could be passwords for each sheet, i.e. for each user in their own space. So that it can still be read by all but only edited on the sheet by the individual and or the teams owner?
Separate lines on Sheets depending on condition
greetings everyone i'm newbie here i need to separate rows on Sheets depending on condition let me explain i have 3 columns 1-UserName 2- CustomerName 3-Cost i need to separate rows on Sheets depending on column User name So that each user on a separate page fetch their customer data on his pages and page name will be UserName