View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cardan cardan is offline
external usenet poster
 
Posts: 112
Default Changing a Number in a Column Using Arrays

I am trying to change a number in the left column to the number in the
adjacent column. My setup looks like this.


Number to Change Change to this Number
182001 182000
182002 182000
193002 193000

Code New Code (from the Change to this Number column)
181000 181000
182000 182000
182001 182000
182002 182000
193000 193000
193001 193001
193002 193000
193002 193000

Essentially, this is an accounting problem. I need to change certain
codes basically into a "rollup". I tried the array function but not
sure if I am using it correctly. The "Code", "The Number to
Change" and the "Change to this Number" are entered manually.
Any suggestions? Thank you!