Forum Discussion

JoydV's avatar
JoydV
Copper Contributor
Dec 19, 2023

Volunteer sheet leader list names in 2 sheets

Connecting cells from one sheet to the next while allowing both sheets to be filtered in 2 tables.  Want the rows to maintain same data.

7 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    If you're expecting a substantive reply, you might consider offering some substance to respond to.
    • JoydV's avatar
      JoydV
      Copper Contributor

      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.

      • mathetes's avatar
        mathetes
        Gold Contributor

        JoydV 

         

        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.