Hello
When I filter on something and then copy and paste in a column - sometimes it copies over the hidden filtered section also, how do I prevent this from happening?
Cheers
Thanks, but the problem is that I want to retain all the data.
Example of my problem:
Filter on dates in Feb, then insert in a new column, called "action" the words "priority1"
Then filter on all dates in Mar, insert the words "priority 2".
And so on.
Problem is when I remove the filter all the rows that were in the last filter say "priority2" even the rows that were hidden in the filter.
This did not happen in Excel 2003 only in Excel 2007 (have tried on other peoples' PCs and this does not happen on theirs.
Try sorting by date first, if the dates are in no order then when you are inserting priority2 (I am assuming you are entering in one cell and scrolling down) it overwrites the hidden rows. Why not use an IF statement?
Insert a new column, then in it enter =IF(a1="Feb","Priority1!,if(a1="Mar","priority2",""))
Adjust the formula to your cell reference and text values
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
