D
Dylan
Is it possible to do a Vlookup on all excel docs in a folder, checking the
same sheetname and column for a value and add all the returned figures
together?
I'm trying to calculate a cumulative total from monthly payment applications
on a summary workbook.
I want create a look up on the project number on the first column of my
table and where it appears in column 2 in each of the payment applications,
get the value from column H of the same row and add the figures from all of
the workbooks together to get my total.
Two things I'm not sure about though.
1. Doing a Vlookup on multiple workbooks in a folder?
2. Adding the resulting amounts to get my total?
same sheetname and column for a value and add all the returned figures
together?
I'm trying to calculate a cumulative total from monthly payment applications
on a summary workbook.
I want create a look up on the project number on the first column of my
table and where it appears in column 2 in each of the payment applications,
get the value from column H of the same row and add the figures from all of
the workbooks together to get my total.
Two things I'm not sure about though.
1. Doing a Vlookup on multiple workbooks in a folder?
2. Adding the resulting amounts to get my total?