Hello all,
How do I go about with collecting data from a number of workbooks into a new workbook ShowInvoiceData.xlxm.
I've got in every Invoice workbook two cells Date and Invoice Number which I would like to show in a list in ShowIvoiceData workbook. Then I shoud be able to select a Invoice Number and doing so the corresponding Invoice workbook will be openend.
Every week a new invoice workbook will be added in the folder Invoice and once I open the ShowInvoiceData workbook the macro should automatically activated and the list should be updated with new created Invoice workbooks.
I'm new to VBA but I hope I get some ideas from yous
Thank you
Marcel
How do I go about with collecting data from a number of workbooks into a new workbook ShowInvoiceData.xlxm.
I've got in every Invoice workbook two cells Date and Invoice Number which I would like to show in a list in ShowIvoiceData workbook. Then I shoud be able to select a Invoice Number and doing so the corresponding Invoice workbook will be openend.
Every week a new invoice workbook will be added in the folder Invoice and once I open the ShowInvoiceData workbook the macro should automatically activated and the list should be updated with new created Invoice workbooks.
I'm new to VBA but I hope I get some ideas from yous
Thank you
Marcel
