when you attempt to paste values into a filtered table. Excel pastes in a contiguous block, ie does not skip the lines that are filtered out, so you end up pasting your data into wrong rows.
Example:
In worksheet I have created two Filter Column one for Product and another for Value, I have filter out Product on there name basis (Product=a).
wanted to copy values from another cells and paste on to those cells where "Product=a". while doing so it will paste data into hidden cells also. which was not expected. looking to paste data onto visible cells only.
So is there anyway we can paste data into visible cells only???
Thanks in Advance....
Bookmarks