Copy and paste on new sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1534430%22%20slang%3D%22en-US%22%3ECopy%20and%20paste%20on%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534430%22%20slang%3D%22en-US%22%3EHi.%20I%E2%80%99m%20hoping%20you%20can%20help%20with%20this.%20I%20have%20a%20master%20excel%20spreadsheet%20with%20formulas.%20I%E2%80%99ve%20added%203%20columns%20in%20the%20front%20to%20add%20notes.%20I%E2%80%99m%20trying%20to%20filter%20out%20certain%20columns%20but%20it%E2%80%99s%20not%20filtering%20(assuming%20the%20formulas%20are%20incorrect).%20I%E2%80%99m%20recreating%20a%20new%20spreadsheet%20with%20all%20the%20info%20in%20it%20except%20for%20my%20notes.%20Now%20I%20have%20to%20extract%20the%20notes%20to%20the%20new%20sheet%20but%20it%20must%20align%20with%20to%20all%20the%20info%20I%20have%20in%20the%20previous%20sheet.%20Can%20I%20do%20this%20or%20will%20I%20have%20to%20copy%20and%20paste%20one%20by%20one%20based%20on%20a%20policy%20%23%20or%20client%20info%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1534430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1534632%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20on%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F734396%22%20target%3D%22_blank%22%3E%40Chopstik%3C%2FA%3E%26nbsp%3B%2C%20based%20on%20what%20you%20said%20about%20recreating%20the%20spreadsheet%2C%20it%20sounds%20like%20the%20structure%20(rows%20and%20columns)%20are%20identical%20except%20for%20the%20first%203%20columns.%20In%20that%20case%20you%20can%20just%20copy%20the%20notes%20columns%20and%20paste%20special%20-%26gt%3B%20comments%20and%20notes%20option%20to%20do%20what%20you%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheAntony_0-1595295249638.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206691iA9E99C3AF174E6DB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22TheAntony_0-1595295249638.png%22%20alt%3D%22TheAntony_0-1595295249638.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1534732%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20on%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534732%22%20slang%3D%22en-US%22%3E%40theanthony%20thanks.%20I%20will%20try%20that%20to%20see%20if%20it%20works.%20I%20pretty%20much%20need%20to%20transfer%20all%20the%20notes%20over%3B%20however%2C%20there%20are%20new%20policy%20number%20which%20doesn%E2%80%99t%20have%20notes.%20Will%20I%20able%20to%20move%20all%20the%20notes%20into%20the%20new%20spreadsheet%20and%20it%20will%20match%20up%20to%20the%20policy%20%23%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1534793%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20on%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F734396%22%20target%3D%22_blank%22%3E%40Chopstik%3C%2FA%3E%26nbsp%3B%2C%20I%20can't%20really%20tell%20without%20seeing%20the%20actual%20excel%20file.%20Can%20you%20upload%20a%20sample%20with%20any%20confidential%20information%20removed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi. I’m hoping you can help with this. I have a master excel spreadsheet with formulas. I’ve added 3 columns in the front to add notes. I’m trying to filter out certain columns but it’s not filtering (assuming the formulas are incorrect). I’m recreating a new spreadsheet with all the info in it except for my notes. Now I have to extract the notes to the new sheet but it must align with to all the info I have in the previous sheet. Can I do this or will I have to copy and paste one by one based on a policy # or client info?
3 Replies

@Chopstik , based on what you said about recreating the spreadsheet, it sounds like the structure (rows and columns) are identical except for the first 3 columns. In that case you can just copy the notes columns and paste special -> comments and notes option to do what you need.

 

TheAntony_0-1595295249638.png

 

@theanthony thanks. I will try that to see if it works. I pretty much need to transfer all the notes over; however, there are new policy number which doesn’t have notes. Will I able to move all the notes into the new spreadsheet and it will match up to the policy #?

@Chopstik , I can't really tell without seeing the actual excel file. Can you upload a sample with any confidential information removed?