View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cferoiu cferoiu is offline
external usenet poster
 
Posts: 9
Default lock cell whit first value

I try google translate:
I have not created the column C based on its column B to create according to
my post above.
This is a dynamic table, the values in column C change regularly, and in
column B we need the first values that appear in girdle under condition C
posted first. I do not want to exchange all the worksheet protection.


And another thing: it can make a macro simply to observe that condition:

if A [n ]<"" then B [n] = n??


Thanks for your time