Home » Forums » Open Source Learning Center » Question and Answer

Repeating cells

Submitted by NatalieMcDonnell on 6 July, 2012 - 11:04

I am trying to input a date into a cell and I want it to repeat the date in cells below. I want it to repeat the first date I enter into the column in the same box in different tables. EG

01/08/12 in cell B3

and then I want this date to repeat in cell B13, B18 for example. Then when I type

03/08/12 in C3 I want it to repeat in C13 and C18.

Thanks

Nat

‹ +cell() function How to Populate a spreadsheet from a Userform ›
»

select cell B13 and type the

Submitted by Mjl on 6 July, 2012 - 15:56.

select cell B13 and type the following
=$B$3 and hit enter
Go back and select cell B13 and select copy (or hit the "ctrl" and "c" keys
Go to cell B18 and then do a "paste special" and select "formula"

Repeat this process for C13 and C18, by typing
=$C$3 in cell C13

Hope this helps

Marty

»