Hello. I have to update a file with income statement numbers each month. I have the line items hard coded and the summary lines calculated with a sum formula. Now I'm importing new month data with a vlookup from another file. I then hard code the numbers. The only problem is that it hard codes the summary formulas as well (I don't won't to have to select each subsection and copy pasta that). Is there any way to get around this with a macro or some other way? Thanks.