Copy the exact content from one cell using a formula

Closed
mzkatt21 Posts 1 Registration date Friday April 5, 2013 Status Member Last seen April 5, 2013 - Apr 5, 2013 at 01:17 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 6, 2013 at 10:33 AM
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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 6, 2013 at 10:33 AM
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
0