I have about 100 invoices stored in different worksheets in the same
workbook. The invoices have the same format in terms of data location, but
contain different information. (they were created over time by copying the
same invoice and changing its information)
Is there any way to convert these invoices into an access database in a mass
production method?
What will happen to the formulas used to calculate the line totals and the
invoice totals?