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...
mathetes
Thank you so much for your thoughtful insights. You are exactly right, if I stick to instructing people to only sort from sheet two there are no issues. The rationale behind inputting the table numbers on the second sheet is that the intended purpose of the second sheet is to only pull over data for guests who RSVP yes, so people can easily see a compiled list of only those guests, and then assign table numbers. I am sure you are right and there is a better way to accomplish this, but to answer your question, that was the motivation behind the current arrangement.
Thank you so much for your thoughtful insights. You are exactly right, if I stick to instructing people to only sort from sheet two there are no issues. The rationale behind inputting the table numbers on the second sheet is that the intended purpose of the second sheet is to only pull over data for guests who RSVP yes, so people can easily see a compiled list of only those guests, and then assign table numbers. I am sure you are right and there is a better way to accomplish this, but to answer your question, that was the motivation behind the current arrangement.
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!
