Hi Excel Ninjas,
recently i work on excel template, and there is a challenge when i want to use a proper formula for the specific column (Total Sell Revenue) in Pick Up Report Tab. basically, what i want to do is a simple formula that can look up at Total sell revenue on Database Tab. However it will change whenever I update the total sell revenue on Actual Tab. We received final number coming from finance and we use it as the actual figures. Hopefully my explanation is clear enough. Could you assist me on how excel can do this. Attached is the sample report. Thanking you for your friendly assistant.
Regards,
keanur
recently i work on excel template, and there is a challenge when i want to use a proper formula for the specific column (Total Sell Revenue) in Pick Up Report Tab. basically, what i want to do is a simple formula that can look up at Total sell revenue on Database Tab. However it will change whenever I update the total sell revenue on Actual Tab. We received final number coming from finance and we use it as the actual figures. Hopefully my explanation is clear enough. Could you assist me on how excel can do this. Attached is the sample report. Thanking you for your friendly assistant.
Regards,
keanur
, thanks so much for your swift respond. I can do it now