Hello VBA Experts,
I have very limited understanding of VBA but i studied in uni about C, Java, php etc to tweak little bit of VBA.
My intention is, i got one folder full of Excel invoices generated by one Master Excel File. I added another sheet and this master sheet need to make table with three columns "
Date|Invoice No| Invoice Amount
My VBA code need to work on this sheet and fetches these three cell values from each excel sheet of different invoices.xls
I found one code on youtube, that works on something similar but my efforts are fruitless with partial success.
But looks like my limited knowledge will take forever to solve it, will appreciate if someone can help me on this, many thanks.