Thread: Column Coding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
climate climate is offline
external usenet poster
 
Posts: 91
Default Column Coding

Dear Experts
My data on sheet1 is classified to many groups, any group has special values
on column C and column B. also, any group seprate with 5 blank row than other.
I need to a macro, when run it, write a code under any group at column H
based on numbers or special value of column C and columb B and then add 5000
to it.
Example for first group: special values on column C is 1 and special value
on column B is 10. expected code under column H for this group will be
(1105000).

any help will be appreciating
regards