View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How can I change two cells (with same info) at once?

Maybe just link one to the other and always change just the source cell.

In F1 enter =A1

Change A1 only to change both.


Gord Dibben MS Excel MVP

On Wed, 10 Sep 2008 18:06:01 -0700, April
wrote:

I know I've done this before, but can't remember how. I have two cells which
will have the same info on the same sheet. I am changing this info every day.
How can I change them both at once?