cannot copy data range reference

[jenny]

After I filter, I was trying to copy the filter data to another sheet, it
prompts me with a msg:" Mrcosoft Excel cannot create or use the data range
reference because it is too complex..."
If I click OK and start paste to another sheet, I'll paste the overall data,
not only the filter data.
Why?

 

[sambhaji kuryal]

Dear Jenny,

After you filter your data select the visible data range and press Alt
Key+Semicolon Key so that it selects only visible data and then press Ctrl C
for copy and paste it in other empty sheet so that it pastes only filter data
and NOT the entire data on the sheet.

This MUST work.

Regards,

Sambhaji Kuryal

 

[JMay]

When you highlight and copy already auto-filtered data, Excel normally copies
only the visible rows; If you are experiencing a problem (with message),,
hummmm.

If your like me often your just looking for a QUICK FIX so you can get the
work out. If so in this case you could try - highlighting the filtered range
- Edit, Goto, Special Cells, click on the option Visible cells Only,,, Now
do the Copy and paste. Does that work for you?

 

[Suleman Peerzade]

Hi Jenny,

go to menubar

Edit|goto|Special|Visible cells only.

This should sort your problem

 

[jenny]

Hi Sambhaji Kuryal,

Thanks, but this doesn't help me. I'm still encountering the same issue when
I tried the method below.
Is it because total rows of my filter data is more than 15K?

 

[jenny]

HI Suleman Peerzade,

Thanks, but this doesn't help me. I'm still encountering the same issue when
I tried the method below.
Is it because total rows of my filter data is more than 15K? Any other
solution?

 

[SBV Ali]

Excel 2007 Irony

i know the reply is a bit late. but would be of help to people who are searching for solution to this problem. Excel 2007 restricts the copy of filtered data upto 15043 rows hence if you wish to work on filtered data it is restricted to 15000 rows. its ironic that exel 2007 gives you 10 lac rows but lets you work in only 15000 rows.