Forum Discussion
Copy and paste on new sheet
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 ...
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.
@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 #?