Appending an Excel database
Posted on 2014-02-07
A workbook was created, with the assistance of gowflow, that creates a database from selected workbooks, with each workbook containing three seperate worksheets, and is then combined into a single workbook with three worksheets of the same type of data as the indidividual workbooks.
The end result is one database type workbook that has the data from multiple workbooks, by worksheets. Usually there is one created for each day.
In completing a reformatting process, would like to have the current day's "data rows of interest", within the three worksheets, which are all bolded, minus the headers, and have them append this "database" as the report is completed.
The name of the file that contains the data from each days report is called: Daily Report File.xlsx