View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
beeblemonster beeblemonster is offline
external usenet poster
 
Posts: 11
Default how to copy as I type and then lock?

Hi!

I'm writing a very large excel file and I need certain columns to be copied
into another tab as I type them, or press enter after each cell.
It's the first two columns of the first tab and I need them to be copied tp
the second tab and then locked in the second tab, but open to edit in the
first tab.

I tried using a macro but I really screwed it up.
Please help!!!

thanks!