Copy the exact content from one cell using a formula

[Closed]
Report
Posts
1
Registration date
Friday April 5, 2013
Status
Member
Last seen
April 5, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi,

I need to copy a cell into several other cells with the exact same data

ie: D3 auto copy to D7, D11, D15, D19 and so on and on and on

is there a formula I can put into these cells so it will auto fill once I need to enter the data?

Thanks

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
did you really meant "copy" or you are just looking for some mechanism to "display"
If display is your intention then use some thing like this in your d7 etc cells

=IF(D3="","",D3)

If copy is your intent, then you need a macro for that