Hi ,
am trying to consolidate in Consol Tab , sum of two cities data for each of P&L Line items ( all rows Basically ) with two data validation :
1. IF the figures are in USD , it should basically divide City 3 Data by exchange rate in Cell B3 of Consol Tab and add tabs City 1 Forecast & City 3 Forecast
2 Also , the second data validation is If year is changed in Cell E1 , then it it should total for 12 months of that year only from two tabs City 1 Forecast and City 3 Forecast .
Am trying to use offset function along with IF and SUM Function across the Consol tab to data validation work but this is not working.
Kindly help at urgent level
Bookmarks