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
4479
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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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