I have data I download every month that is just the numbers with no formatting or anything, but it downloads the same way every time. What is the easiest way to set up a workbook with formatted sheets that will automatically insert the information once I download the data. I was thinking that I can always save the data sheet as the first sheet in the workbook that has the formatted sheets and have a formula in the columns (monthly columns) that will automatically pull from the same place in the data sheet. Does that make sense? Do you think there is another/better/easier way to do it?
I have attached a sample of the data download and of the formatted workbook. There will be about 50 homes total (though it will grow by about 10 homes a year). I will need to track this monthly.
Bookmarks