Forum Discussion
Volunteer sheet leader list names in 2 sheets
mathetes I'm not sure how to explain. I have 2 sheets. Both have tables. I am pulling names, and dates from one to another. However, I discovered that the rows do not stay aligned with the data pulled from the first sheet if you organize from A to Z in columns on the second sheet table. It adjusts the column but does not keep the rows intact. I want an auto-filled Excel workbook to assist volunteers with their enormous list of people. I don't know if I can share a Zoom link and have you or anyone join me to troubleshoot. I am an audio learner.
Is it possible for you to create a copy of these two sheets, without real names (needn't be as large as the real thing either)? Should be large enough to illustrate the challenge, the purpose, etc.
Then post that copy on OneDrive or GoogleDrive, pasting a link here that grants access to it.
Otherwise, you and we are limited to your verbal descriptions, and as you have experienced, it's hard to describe, especially if you're relatively new to Excel.
OK. First step done. I see the sheets, but I had suggested there be enough (false names) data to illustrate the task and the difficulty.
What you posted is mostly blank. So please describe what goes into each sheet, which one(s) are pulling from which, and what this sorting difficulty is that you mention. And so on. How do these get used?
- Thank you for helping.
I put data in the columns that I want to auto-populate into the next sheet for leader training. From there the rest is manual. The challenge is when a user filters the columns in the leader training section, only that column changes. The rows are not consistent with the same leader.
I am using this for tracking the membership in my region as will other leaders that track their region memberships. There are several sheets not uploaded as they did not pose challenges for me.
