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

Copy the exact content from one cell using a formula
How to move contents from one cell to another - Guide
How to Pull content from 4 cells to 1 cell ✓ - Forum - Excel
Excel vba clear contents based on cell value ✓ - Forum - Excel
To easily copy the content of one cell to several other cells in your worksheet you can use ✓ - Forum - Excel
Excel clear cell contents if another cell changes ✓ - Forum - Office Software

1 reply

Answer 1 / 1

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

Subscribe To Our Newsletter!