Need assistance building a spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1751885%22%20slang%3D%22en-US%22%3ENeed%20assistance%20building%20a%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1751885%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20built%20a%20very%20simple%20spreadsheet%20that%20has%20all%20the%20data%20together%2C%20but%20would%20like%20some%20of%20that%20to%20copy%20to%20additional%20pages%20in%20the%20same%20workbook%2C%20depending%20upon%20the%20data%20in%20one%20cell.%20For%20example%2C%20columns%20are%20name%2C%20DOB%2C%20etc.%20If%20I%20enter%20Yes%20in%20a%20particular%20cell%20in%20one%20of%20the%20rows%2C%20I%20would%20like%20that%20whole%20row%20to%20copy%20to%20additional%20page%20in%20the%20workbook%20and%2C%20in%20turn%2C%20be%20removed%20from%20that%20additional%20page%20if%20that%20same%20cell%20is%20changed%20from%20say%20yes%2C%20to%20no.%20I%20am%20a%20complete%20novice%2C%20so%20this%20may%20not%20even%20be%20possible.%20Any%20help%20would%20be%20greatly%20appreciated.%20Trying%20to%20make%20my%20new%20position%20more%20efficient.%20Hoping%20this%20makes%20sense.%20Please%20feel%20free%20to%20ask%20any%20questions%20for%20clarification.%20Thanks%20in%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1751885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1752171%22%20slang%3D%22de-DE%22%3ESubject%3A%20Need%20assistance%20building%20a%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1752171%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F822681%22%20target%3D%22_blank%22%3E%40Kim_Gandy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWith%20your%20permission%2C%20if%20I%20may%20recommend%20you.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EInclude%20a%20file%20(without%20sensitive%20data)%20in%20your%20request.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EDescribe%20your%20project%20in%20relation%20to%20this%20file.%3C%2FSPAN%3E%20%3CSPAN%3EThis%20means%20that%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EIt%20is%20also%20always%20advisable%20to%20specify%20the%20operating%20system%20and%20Excel%20version%2C%20as%20possible%20commands%20and%20setups%20could%20differ%20greatly.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20for%20your%20patience%20and%20understanding%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EI%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I've built a very simple spreadsheet that has all the data together, but would like some of that to copy to additional pages in the same workbook, depending upon the data in one cell. For example, columns are name, DOB, etc. If I enter Yes in a particular cell in one of the rows, I would like that whole row to copy to additional page in the workbook and, in turn, be removed from that additional page if that same cell is changed from say yes, to no. I am a complete novice, so this may not even be possible. Any help would be greatly appreciated. Trying to make my new position more efficient. Hoping this makes sense. Please feel free to ask any questions for clarification. Thanks in advance! 

1 Reply

@Kim_Gandy 

With your permission, if I may recommend you.
Include a file (without sensitive data) in your request. Describe your project in relation to this file. This means that you can get a solution that is tailored to your needs much faster.

It is also always advisable to specify the operating system and Excel version, as possible commands and setups could differ greatly.

Thank you for your patience and understanding

Nikolino
I know that I don't know (Socrates)