2nd request

[Waynecu1]

Does anybody know how to format/ enter identical numbers in 2 differant cells ?

Exsample I want to be able to place in say cell A1 the number 72 then
have it automaticly placed in cell c366. I have tried differant for formulas and even a marcos & pivot tables . But it is not coming out the way I like it too in otherwords when I type in 72 Like to see it in Cell c366.

Thanks for any help

 

[Gerald Higgins]

In cell C366...

=a1

This will repeat the value in A1.
It won't automatically copy the formats from A1.

 

[Gerald Higgins]

Obviously I should have checked Waynecu1's other posts before making my last post.
This looks like a duplicate of this thread, in which VoG suggested exactly what I suggested.
http://www.mrexcel.com/forum/showthread.php?t=539278

Waynecu1 - if this is not what you want, what exactly do you want ?
You need to be more specific than just ask for any other ideas.

 

[Waynecu1]

Well excuse me! ! Sorry I asked I thought this was a forum to help but your post comes across a a little condescending and you would have been better off not stating I have a "weird problem"

 

[Scott Huish]

I don't see where anyone stated that you had a "weird problem", but you should continue your question in the same thread instead of making multiple ones for the same problem. How does the suggestion given not help you?

See Rule #21 in the forum rules: http://www.mrexcel.com/forum/showthread.php?t=127080