Best wishes!!
I think I haven't clearly explained in my previous post. The clear picture is here:
I have a worksheet with cols A2:AP55. In this, I already defined three Allow users Ranges ((Range1 - A:P), (Range2 - R:AC), (Range3 - AE:AP)) and protected the sheet. So that the formula & data validations are protected. ColQ, ColAD consist of Formulas and it shows the values based on the previous columns respectively.
When I need to Clearcontents (I DONT WANT TO DELETE ROW) a row based on a value in a column, it removes the formula also. Thanks for Mr. Mikerickson for his code to clear only the contents keeping the formulas in tact.
Example:
In the above example, the TOTAL is a calculated column (QTY * RATE). Hence, for data entry purpose, I am to allow the users only to enter the values in blank cells. And other areas are protected.
In this case, the contents of Slnos. 2 & 4 are to be removed (using ClearContents & without disturbing formulas). And then the data should be sorted first by ADD and then by NAME columns.
As always, Any help is very highly appreciated.
Thanks in advance.
acsishere.
Bookmarks