Cell Mapping
Is there a way to quickly select multiple cells to equal one other cell?:confused: -- MRSV ------------------------------------------------------------------------ MRSV's Profile: http://www.excelforum.com/member.php...o&userid=30642 View this thread: http://www.excelforum.com/showthread...hreadid=503071 |
Cell Mapping
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 |
Cell Mapping
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 |
Cell Mapping
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 |
Cell Mapping
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 |
All times are GMT +1. The time now is 05:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com