View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
unlucky unlucky is offline
external usenet poster
 
Posts: 2
Default Recording changed cells in the same sheet

What I need to do is this:

I have two column of data, the first has numbers and the second is
blank. If I change anything in the first column I need the old value
to appear in the second column automatically. What would be the
easiest way to accomplish this?