repopulating data in a spreadsheet, without having to fix formulas

[DylantheD]

Hey Excel Gods!!
some of you might recognize this sheet, still working on it.
i have been having a few issues, when i delete the data out of columns A-M, and copy in new data, it makes all my formulas in the R/H side stuff up. I'm trying to figure out an easier way, but the data provided, i need the highlighted cells, and so, have to copy the raw information from another spreadsheet. Doing this, formulas have the dreaded #ref! in them.

Anything you awesome legends can do to help would be wonderful.
two images, as they are rather large.
let me know what information you need, i might be able to provide!

 

[Alex Blakenburg]

How you delete the data matters. Clear Content won't impact your formula, nor will delete entire rows.
Have you considered using Excel Tables ?
You can then delete the rows and the formulas will automatically repopulate when add rows back in.

 

[DylantheD]

Thanks Alex!
I have not tried using Excel Tables much, was starting to learn them! as for Clear Contents, that's a good point also.
If the data i need has highlighted cells, will they stay with when i paste new data in them?

Appreciate the help!!

 

[Alex Blakenburg]

Clear Contents does not remove the previous formatting. If you do want to remove that just use "Clear".
When you paste in the new data and and want to keep the highlighting you either need to use a straight copy paste or do copy paste values followed by a copy paste formats.

I am a fan of using tables, it is worth having a play with that.