Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Nov 10, 2022
Solved

Filtered List - Cant Copy from one column to another

Hello Experts, I have had this issue of not being able to copy data from one column to another if the list is filtered. I want to be able to copy the entire range and paste it into the same rows in t...
excel
  • Patrick2788's avatar
    Patrick2788
    Nov 10, 2022

    Tony2021 

     

    Flash Fill. In the gif, I use the menu command, but you could also do the shortcut ctrl+e.

     

Patrick2788's avatar
Patrick2788
Silver Contributor
Nov 10, 2022

Tony2021 

 

Flash Fill. In the gif, I use the menu command, but you could also do the shortcut ctrl+e.

 

Tony2021's avatar
Tony2021
Iron Contributor
Nov 10, 2022

Patrick2788 

ahh yes the flash fill.  Awesome.  Thank you very much.  

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Nov 10, 2022
    You're welcome! The only drawback to using Flash Fill is the columns have to be neighboring each other. In your example it works out.
    • Tony2021's avatar
      Tony2021
      Iron Contributor
      Nov 10, 2022

      Patrick2788 

      HI Patrick, I am having a tough time making it work. My columns are next to eachother in the attached but I still cant get flash fill to work. Do you happen to see why?

      In my real data set the columns are actually not next to eachother. Do you know of a work around?  I could put the columns next to each other I guess since it would still be better than manually copying and pasting one by one. 

       

      thank you
      Please see attached

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Nov 10, 2022

        Tony2021 

        Thank you for the followup and the sample workbook.

         

        I was able to reproduce the same error you received. That particular error seems to be nowhere to be found online so I'll post it here in the hope it may come up when someone searches for it:

         

        We didn't fill in values because the display formatting for some of the cells in the active column is using a different level of precision than the underlying value

         

        The part Flash Fill doesn't like is the large decimal (7 numbers right of the decimal).  Through some trial and error, I got it to work but only when I truncated the decimal down to 1.  There's no issue with the cell formatting - it's all about the value in the formula bar.  I've attached my sample workbook.

Resources