Previous Topic Next Topic

Copy the exact content from one cell using a formula

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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
6 Apr 2013 à 10:33
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Sims 2!! Custom content pleasee helpp me!! :(
smiley cupcakee xx :] -
Levy -

25 responses