Hi,

I happened to make a file (a real estate DCF if it helps you understand) were I spread data and results over multiple tabs and the file is too tough to navigate now (my director thinks so anyways). I'd like to be able to just copy and paste some data into a single tab but I can't since most tabs are dependent on each other trough formulas (Lookup, If, SUMIF and so on). Is there a way I dont know about to copy and paste without messing up all the dependent cells in the other tabs or needing to change every formula?

My first language isn't english, so don't hesitate if you need me to clarify.

Thank you,
LF