Forum Discussion
Sorting data across linked sheets
Hello! I am looking for advice, I am hoping someone can help. My spreadsheet is created to be used so all the data entered into the main sheet is then pulled onto a second sheet via index and vlooku...
Alajandra I have the same problem.
for a number of reasons, it's not practical to have a single master dataset.
For context, I have a spreadsheet with patient names, and several columns of clinical data which are not relevant to my colleagues in the admin/ reporting department. 4 or 5 columns pull through from my sheet to theirs, and they have several additional columns in their sheet which are not relevant to mine.
When I sort/ filter my sheet, the columns from my sheet sort in theirs, but their own columns don't, jumbling their dataset. To clarify, I am in no way an excel expert and I need the simplest possible fix. Thanks!