Items 2-10 are done in Excel and if you have never done any VBA programming, you'll have to get out the books. We only use this approach when we want the spreadsheet data to be custom formated (special colors, formulas, multiple sheets, etc) AND the data dump into Excel will occur many times. Otherwise we just create a CVS file and import into Excel.
And yes, the only reason we do this is when we are going to produce a bunch of spreadsheets with different data (but the same formating/logic).
Items 2-10 are done in Excel and if you have never done any VBA programming, you'll have to get out the books. We only use this approach when we want the spreadsheet data to be custom formated (special colors, formulas, multiple sheets, etc) AND the data dump into Excel will occur many times. Otherwise we just create a CVS file and import into Excel.
And yes, the only reason we do this is when we are going to produce a bunch of spreadsheets with different data (but the same formating/logic).
