How to copy cells conditionally in Excel? You have a huge list, you have highlighted them in colors (using some formula), you want to move over the IDs that are not highlighted. How can you do it?
There is really no copy method or function in Excel. One may say you can use VBA to copy cell over, but you can do that right in Excel, using some improvisation. Instead of spending effort on copying data, we are going to use IF formula in the column where you want to copy the cells. If it meets the criteria, it will be copied, if it did not, it will not be copied.
Example 2 – more complicated criteria
This example will copy cell overs to the new column if the ID in the original column does not exists in the column where you are looking at the IDs
Use the following formula in the cell where you want to copy the cell conditionally. Then drag this cell over the number of rows depending on how many rows of data you want to copy.