Cell Mapping

[MRSV]

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

[Leith Ross]

Hello MSRV,

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

Sincerely,
Leith Ross

[MRSV]

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

[Leith Ross]

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

[MRSV]

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