I have workbook that contains a sheet that was imported via MS Access report called DataBook, with formatting being conserved. I would like to know, either by code or equations, if I can auto fill a pre-determined excel template, called BOMBook, with data that is in DataBook. I was originally just copying and pasting, but now I need to have the data loaded in automatically or via macro. Not too familiar with macros.