How to repeat numbers in different cells?

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

Guest

If I fill in a number in one cel I want it automaticly repeated in another,
specified cel. How can I do that?
 
If you type the number in A1, you can use:
=A1
or
=if(a1="","",a1)
in a cell on that same sheet

In a different sheet:
=sheet1!a1
or
=if(sheet1!a1="","",sheet1!a1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function 3
how do you 3
drag and drop linked cel 3
Getting a Cell Value into a Macro! 2
JLatham I need help again 15
Split hours and minutes in two different cells 4
Cel Content 3
i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!? 3

Back
Top