Extract the value of a cell without a cell reference

Your wording is a bit confusing, so I may be understanding correctly. If you are using a macro, as you indicate, then simply copy the values of the source cells and don't use cell references in the code.

Outside of VBA, it is impossible to not change the values of cells that reference other cells. You must either manually or with code, copy values or convert formulas to values.

Post a sample workbook and provide a clearer explanation of what you're trying to accomplish. Include examples of expected results in the sample workbook.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Make sure that you read the Rules & don't post a second question in a different Forum, doing so wastes members' time
Thread Closed.