Copy on filtered list

V

Vinaya

Hi,

I have been trying to copy data on a filtered list. However, it does not
seem to be working. I have even tried copying on 'visibsle cells only'
but that also is not working.
Any solution?

Regards,
Vinaya.
 
V

Vinaya

I filtered out data for a particular customer. Now when I tried changing
this data by copying over it( data which is in the same format as the
filtered list), it copies the data as if the data hasnt been filtered.
It copies over even those data which are hidden.
Hope that not confusing!
 
J

John

Perhaps you can try:
1) Edit -> Copy (or Ctrl+C)
2) Edit -> Paste Special -> Value

Hope this helps.

John
 
G

Gord Dibben

Vinaya

You cannot copy onto visible cells of a filtered list.

You could copy the visible cells to a new sheet then copy your editing changes
on top of that.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Merging from an Excel file with graphics 1
Filtering data from a non-continuous list 3
Space at end of multi page list to accommodate new entries 1
Macro to copy table of contents to a new doc 0
Copy addition formula of non-consecutive horizontal cells 2
How to paste this down? 3
Help with multi-level list 0

Top