We're currently using Google Sheets to offer a online tracking system for one of our customers.
So for example, in columns A B C, we would enter specific details, and our customer would complete Columns D E F with their finishing details.
However, we don't allow the customer to edit our columns, and visa versa (we don't edit the details in theirs). In Google sheets, this is easy to do. You basically just protect the columns, and allow certain people editing access.
I want to do the same thing, but in Excel Online. I can't find out how to do it?? I've found a guide on how I could do it within, one company... Lock Cells to Certain People But Give Access to others in a Live Excel Online Worksheet
But this wouldn't work with two companies, because I wouldn't have their details in my Group / Usernames.
Is there another way of doing this? Or am I clearly missing something?
Company A completes columns A B C (and only views columns D E F)
Company B completes columns D E F (and only views columns A B C)
Neither company, can edit the others data.
I really want to move away from Google Sheets (because it's very slow on large databases), but this is the only hurdle from preventing me.