Hi Experts,
I have set of data where sheet 2 have a Rate Card table for various services and geographies...sample have 10 service lines for four geos.
Sheet 1 have a table for each geography catering all the services. From some other database I get number of heads serving that particular area. And sheet 1 produce revenue data for each geo for each service for each month.
Now problem is, apart from defined services, if I want to add new service line, I have to add that particular service line to each geo.
I was wondering if by any means, the addition of service line to rate table will add service line row for each geo automatically ie if I add new service line "11" to rate card table, the service line "11" row should be added to all geos automatically...
Kindly help..
Bookmarks