Hey Everyone,
Here is my situation..
I have data in cell Sheet1:A1 that is referenced by 10 other cells on different worksheets. The references are all different (i.e some uses Sheet1:A1 in a formula, others are just =, some are relative references, some are fixed ad have the $).
I am changing the way the workbook works, and want all those 10 cells to now refer to Sheet 2:B2. What is the easiest way to make this change all at once?
Now I know some might say it's only 10 cells, don't be lazy...I am just using this as an example, I literally have a 1000 cells...so a short cut is very important.
Thanks,
Here is my situation..
I have data in cell Sheet1:A1 that is referenced by 10 other cells on different worksheets. The references are all different (i.e some uses Sheet1:A1 in a formula, others are just =, some are relative references, some are fixed ad have the $).
I am changing the way the workbook works, and want all those 10 cells to now refer to Sheet 2:B2. What is the easiest way to make this change all at once?
Now I know some might say it's only 10 cells, don't be lazy...I am just using this as an example, I literally have a 1000 cells...so a short cut is very important.
Thanks,