Forum Discussion
Extracting and pasting a row based on a value HELP!
I have attached a replica table. Essentially, what I am trying to do is to extract the entire row of data if it affects (in this example) the Directors and paste it into another table. This separate table contains all the details (reference, owner, description etc.) as the original except only for rows that impact the Directors. Also, I am unsure how to create this new table so that it updates from the original table --> like if IM-01 was decided to impact the directors, simply adding a Y underneath such column would update it.
As I said, my skills on excel are fairly basic but I hope I am being clear, thanks for your help 🙂 https://www.dropbox.com/scl/fi/kk8tgi3qwne6t3xj5b6dr/Example-Impact-Summary.xlsx?dl=0&rlkey=k4gahtnbalobplgwgqg8dqdri
If you have Microsoft 365 or Office 2021, you can use the FILTER function. See the attached version.
HansVogelaar Thankyou, but how would I make it so each table updates each other if either one is edited? At the moment if I edit the copied data, an error message appears
That would be too complicated. You'd be better off filtering the data on Sheet1, as in the attached version.