Hi
I want merging amount in column G or E and headers are matching with column D for each sheet .
in column A will be sheet names under cell(C4) and from B4:H4 should match for column D for each sheet and should merge amounts , if the cells B3,C3 are empty and if the cells B3,C3 contain DATES then will just merge amounts locates between two dates. I posted the result in SUPPOSED RESULT sheet for two conditin (two dates or not) and the real result should be in REPORT sheet
and should be clear data from B5:H110 when brings data
when merge amounts for BUYING,SELLING,RESTTR,RESSR sheets are existed in column G should sum based on matching column D for each sheet with the headers in REPORT sheet and populate sheets names in column A in REPORT sheet . as the others sheets should sum for column E
attachment:
Dropbox
thanks
I want merging amount in column G or E and headers are matching with column D for each sheet .
in column A will be sheet names under cell(C4) and from B4:H4 should match for column D for each sheet and should merge amounts , if the cells B3,C3 are empty and if the cells B3,C3 contain DATES then will just merge amounts locates between two dates. I posted the result in SUPPOSED RESULT sheet for two conditin (two dates or not) and the real result should be in REPORT sheet
and should be clear data from B5:H110 when brings data
when merge amounts for BUYING,SELLING,RESTTR,RESSR sheets are existed in column G should sum based on matching column D for each sheet with the headers in REPORT sheet and populate sheets names in column A in REPORT sheet . as the others sheets should sum for column E
attachment:
Dropbox
thanks
