• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Paste Special Filter Data

N

neeraj2050

Member
Greetings!!


Into my file I have data in a column(i.e formulas). After getting that column filtered I want to get filtered data Paste Special. But it is not being allowed.

Attachment enclosed

May I get your suggestion


Regards

Neeraj Kumar Agarwal
 

Attachments

  • Paste Special Filter Data.xlsx
    9.3 KB · Views: 5
where to paste. Give specific cell ref.

Try With Below instruction.
  1. Select the entire range you want to copy.
  2. Press Alt+; to select the visible cells only. You will notice that the selection is cut up to skip the hidden rows and columns.
  3. Copy the range – Press Ctrl+C or Right-click>Copy
  4. Select the cell or range that you want to paste to
  5. Paste the range – Press Ctrl+V or Right-click>Paste
 
Last edited:
Hi !
neeraj2050 said:
May I get your suggestion
Click to expand...
As paste special works on my side …

Maybe you have to much data, so select part by part,
not entire filtered column …

Or for sure you did not crystal clear well explain what you wanna do !
​
 
Please find the attachment once again I have highlighted the requirement into F column.

I want to have the same data into D column
 

Attachments

  • Paste Special Filter Data.xlsx
    9.3 KB · Views: 5

Now from your last attachment it is just about a normal Copy/Paste,
nothing special !

So as i yet wrote, better is to crystal clear explain the purpose !
​
 
You must log in or register to reply here.
Back
Top