Hi, this is my first post so thanks in advance for your help/guidance.
I am currently working on a operational requirements spreadsheet and want to streamline the information that is inputted into one sheet but have it duplicate automatically and remove any duplicate entries onto another sheet within the relevant sections where it should sit. Is this something excel can achieve and if so how would I go about doing it? The spreadsheet i'm using is held on the CPNI website and search operational requirements if you want to see it, as I can't hyperlink or anything as new.
Many thanks,
Bookmarks