Keep same format/template just update data,

Question

I'm looking to update an existing tab with updated information from another excel spreadsheet. So basically, I want to keep the same formatting and look of existing template but just want to update it with up-to-date information every month. There are currently formulas (sumifs and vlookups) in the current template that lookup data to another file/tab. Ideas on best way to do this?

FinnCharlton · Answer

@FA40 , you can use the Output Data tool to do this. If you select the "Overwrite Sheet or Range" option, you can overwrite a certain range of cells within an Excel sheet:

Here, the range A1:G7 will be overwritten with new data, the rest will be untouched. Hope this helps!