Copy cell value problem

[Andy128]

Ok- cell A1 has number in it, say 50. I need cells B1:B20 to mirror what is in cell A1. So when I change A1- all the cells B1:B20 change to. How do I do this?

This Board Rocks!! ray:

Andy

 

[Tom Urtis]

If it's really as simple as that (curious why you'd need 20 cells to show the same thing as A1), then select B1:B20, then type in =$A$1 and hit Ctrl+Enter.

There's probably something else to this though, so post back if you really need something different.

 

[Norie]

Andy

Could you not just put this formula in B1 and copy down to B20:

=$A$1

 

[Andy128]

Tom & Norie,

Thanks, that worked just fine. Tom- to answer your question about the repeat numbers. I had to create a table that has many matching nubers associated with just a few key files in order to use a vlookup function. There was just too many criteria to test to use an if statement. There may be an easier way to do it- but I am new to Excel. The way I have done it accomplishes the task though. Thanks again.

Andy