I have searched all day trying to find an answer to this question and can't find exactly what I'm looking for. I'll see if I can attach an example of what I'm trying to do.
Sheet1 has a list of names in column A.
I have turned that list into a table.
Sheet2 needs to mirror that list of names, again in column A.
To do this, I labeled cell A2 on Sheet2 =Sheet1!A2 and then proceeded to click the bottom right corner of the cell and drag down to fill the area needed to mirror the entire column of the indexed table.
NOW... here's my predicament...
I fill in information in the rows next to the names that are mirrored from Sheet1 on Sheet2. My problem arises when I add or delete names from Sheet1. It reflects immediately on Sheet2, which is great, but only column one moves - meaning that the information I have put next to the names on Sheet2 is now no longer next to the correct name. This also happens if I add a name to the bottom of the list on Sheet1, and then sort them A-Z.
What I need is for the rows on Sheet2 to be locked to the first column, so when the name in the first column moves up or down, the information next to it follows it. And if I delete a name from Sheet1, I need the name on Sheet2 AND all the information next to it to also be deleted.
Does this make sense? It sounds so easy but I can't find an answer anywhere! I'm about to pull my hair out!![]()
Bookmarks