Help!
I am trying to copy cells to another sheet(sheet 2) that change when sheet 1is changed. For this I've just used "='Sheet 1'!D4" which works as long as sheet one stays the same but...
Sheet 1 changes daily with rows being removed. This means that when a row is removed on sheet 1 my sheet 2 comes up with an error. So say on Sheet 1 I remove row D and the content shifts up, row D in my sheet 2 comes up with an error message whereas I instead want it to remain copying Row D and just showing the new information.
Does that make sense? Maybe someone could help before my hair falls out
Bookmarks