How to insert number in differant cells

[Waynecu1]

Question I like to know how to enter numbers in differnat cell exsample say I want to enter number 72 in A1 then have it also enter into cell C366 automaticly ? Any ideas thanks

 

[VoG]

In cell C366 enter the formula

=A1

 

[Waynecu1]

Thanks Peter but that not what I am looking for What I need is a formula to do this Exsample

Cell A1 number 72 then have same number listed automaticly in cell C366

 

[VoG]

That is a formula. Did you try it?

 

[Waynecu1]

Thanks will do !!

 

[Waynecu1]

Ok Peter I did as you requested but still not working the way I like it to any other ideas thanks

 

[Scott Huish]

Ok Peter I did as you requested but still not working the way I like it to any other ideas than

We don't know how you want it to work. Can you explain what you want in more detail? (This is all that was asked in your other post)

 

[Waynecu1]

OK maybe I'll try to explain it better

I want to be able to have formula to place data or text in 2 differnt cells automaticly so that I do not have to a lot of copy/cut paste

Exsample Let's say in cell A1 I enter the number 72 then also have the data /text 72 from A1 placed in Cell C366 I what I done in past was

data/text =A1 then I type in cell C366 =a1 so data that is in A1 will show up in Cell c366.

Would it better better to have a forumla to do this then and keep typing in formation over and over. Marco does work but I think a formula is better NO ?

 

[jasonb75]

Are you saying that you want the data from A1 to appear in C366 without you having to go to C366 and type =A1 ?

Not possible with formula!

 

[Waynecu1]

Re: How to insert number in different cells

What I have done in past was this

data/text placed in A1 then I type in say cell B1 =data/text from cell =A1



So you say this cannot be done with a formula and must be done manually ?