Hey everybody,
I am trying to compare the total sum from tab “Upload” column “P” (pls see attachment) with sums from tab “Master” in range J47:U59
While column “P” in tab “Upload” stays fixed, the sum to be compared against in tab “Master” will vary in accordance with the entry in cell C6 in tab “Ctr”.
Therefore, what the code should do is to compare the period in range J6:U6 in tab "Master" with the entry in cell C6 in tab “Ctr” and evaluate the sum of the corresponding month in range J47:U59 against the sum in column “P” tab “Upload”.
For example:
When the entry in Cell C6 tab “Ctr” = 01.05.2015 (format: May 2015), then the corresponding month in tab “Master” is 01.05.2015 (format: Mai). Therefore the sums to be compared are 85.200.710,81 (range N47:N59 tab “Master”) against 85.200.710,81 (range column “P” tab “Upload”)
In this case the code should display in a msgbox something like “No delta detected in the reporting month - May 2015 –“.
If no delta was detected, then the msgbox should display something like “Delta detected in the reporting month - May 2015 – Delta: #,##0.00”
I've been trying to do that on my own but I wasn't successful.
Therefore, your support is highly appreciated. Thanks a lot in advance!
regards
Bookmarks