Is there a way to quickly select multiple cells to equal one other
cell?


--
MRSV
------------------------------------------------------------------------
MRSV's Profile: http://www.excelforum.com/member.php...o&userid=30642
View this thread: http://www.excelforum.com/showthread...hreadid=503071

Hello MSRV,

Not certain what you want to do. Can you give an example?

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=50307

I am trying to create a template where I can use one cell to input
variable and then have that variable automatically populate in man
other cells. To do this one by one would be to = a cell to the cell
want to input the variable in. I happen to have many cells that I wan
this variable to populate in and I was wondering if ther is a globa
command to accomplish this. I hope this did not confuse you more

--
MRS
-----------------------------------------------------------------------
MRSV's Profile: http://www.excelforum.com/member.php...fo&userid=3064
View this thread: http://www.excelforum.com/showthread.php?threadid=50307

Hello MRSV,

There isn't a global command to do what you want. To do this would
require writing some code for the Worksheet_Change event. It would work
lke this. When the contents of the cell change the event code fires and
then saves the current cell's data into the other cell's you specify.
The down side is you have to hard code the cells you want changed into
the macro code. Would this be a workable solution?

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503071

Hi Leith,

Thank you very much for taking the time to investigate my query. I have
been hacking away at each cell indvidually as I awaited responses and
think that the best way forward is to stay the course.

Thanks again,
Steve


--
MRSV
------------------------------------------------------------------------
MRSV's Profile: http://www.excelforum.com/member.php...o&userid=30642
View this thread: http://www.excelforum.com/showthread...hreadid=503071