ExcelBanter - How to repeat numbers in different cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to repeat numbers in different cells? (https://www.excelbanter.com/excel-discussion-misc-queries/133054-how-repeat-numbers-different-cells.html)

HWDijkhuizen

How to repeat numbers in different cells?

If I fill in a number in one cel I want it automaticly repeated in another,
specified cel. How can I do that?

Dave Peterson

How to repeat numbers in different cells?

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)

HWDijkhuizen wrote:

If I fill in a number in one cel I want it automaticly repeated in another,
specified cel. How can I do that?

--

Dave Peterson

All times are GMT +1. The time now is 02:24 AM.