I'm trying to set up a recap of general information in a workbook based on
each of the individual invoices that are created on separate worksheets. The
data is in the same location on each sheet. Is there a way to create a list
(recap) of the invoice number, date, and po# for each sheet (there are
anywhere from 20 to 100+) without manually entering into each line the
separate sheets? and then setting up so that when I add an additional
invoice, it will automatically add to the recap listing?
It's a somewhat simplistic workbook - each invoice that I'll billed out -
but I'm in need of this list as a secondary reference to locate invoices by
their PO #'s.
The automatic addition when an invoice is added would make it perfect! I'm
just not thrilled with manually adding hundreds of invoices to a list.
I'm a bit of a novice when it comes to the intricate formulations here -