Hello - I have two sets of data that I have been manually matching up in order to find their variance. It takes forever since I do this multiple times a day! Is there a Macro or Formula that will match up these two sets of data?
Sometimes the data doesn't repeat so the formula/macro would need to shift the cells down to line everything up.
I attached the raw data and the report I create as an example. Thanks for the help!
Last edited by qualk23; 06-25-2013 at 12:43 PM. Reason: simplified
Hi qualk23,
try it
Please Login or Register to view this content.
Thank you sooo much. This just saved me hours of work daily!!
Hi Nilem,
I need to adjust the macro you created for me slightly. It is not calculating some of the data correctly.
The Daily AVG needs to be the Total Room Revenue Divided by total Room Nights. The Total ADR Variance would need to be the Daily AVG's subtracted from one another.
In the Macro I found the correct section to adjust, but I can't figure out how to get them to reference the different cells:
r(j, 4) = "=SUM(R[" & i & "]C:R[-1]C)"
r(j, 9) = "=SUM(R[" & i & "]C:R[-1]C)"
r(j, 13) = "=SUM(R[" & i & "]C:R[-1]C)"
I attached the sheet with highlighted cells.
Thank you!
Hi qualk23,
change this part of the code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks