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.
