| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot copy data range reference
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? "Suleman Peerzade" wrote: Hi Jenny, go to menubar Edit|goto|Special|Visible cells only. This should sort your problem -- Thanks Suleman Peerzade "jenny" wrote: 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named range as chart data reference (error) | Charts and Charting in Excel | |||
| Copy data from pivot table using relative reference | Excel Discussion (Misc queries) | |||
| Reference Data Range based on cell contents | Charts and Charting in Excel | |||
| Reference / Copy Dynamic Data | Excel Discussion (Misc queries) | |||
| Data range reference in a cell | Charts and Charting in Excel | |||
Threaded Mode
