2 Layers of Data in same cell

[HelplessInSeattle]

Hi - i'm trying to create a spreadsheet for resource allocation that has 2 layers - 1 layer with all the resources sits underneath and is "locked" - and then l want be able to create a duplicate layer over the top, but where each cell can be moved around, and when it is moved, the underlying text shows - so for instance moving the cell or tile to an "allocated column, l can see it in the allocation column, but can still see it in the full list, but might just be in RED to indicate it is not where it should be. I've searched everywhere but can't find any info on this.

 

[bobsan42]

I am not sure I completely understand your idea, but it sounds similar to something I have done - mapping a PV field.
For the purpose I used 2 sheets. One hidden containing reference numbers, and one visible for visual purposes - showing additional data as comments, showing/setting status/type or anything. But then I had another sheet with a data table where all the necessary and available information was consolidated.

But maybe some additional information from you may help understand your idea better - what is the purpose, how you want it to look and behave, code or no code ...

for example if you have two sheets (Sheet1 and Sheet1_1), you can use a formula like this:

=INDIRECT(MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,999)&"_1!"&CELL("address"))

to display on sheet1 the value of the corresponding cell in sheet1_1