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!
|