I want to enter a word in a cell and have it duplicate in another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like that when I put in a word in a cell, it would automaticaly go in
another cell or even on another page without having to type it in every time.
I enter a lot of same data in cells.
 
If you type your text into cell A1, then the other cells (on the same sheet)
should have a formula like =A1. A cell on the other sheet needs to put the
sheet name of the cell you're typing in first, like =Sheet1!A1. If the sheet
name has spaces or other funky characters, enclose it in single quotes like
this: ='My Work Sheet'!A1.

- Jon
 
just type in = then the cell reference you are referring to.

So if you are entering the word in cell A1, type =A1 in the cell where
you want to duplicate it

Tony
 
Back
Top