Data populating

[Mohandas]

I need to get data from data sheet for all the other sheets based on region and sku as criteria

There is any formula to get it

Thanks

 

[narunfca]

Dear Mohandas,

In sheet A- HYD&TEL

Insert a row after heading and type the month and year in the format yyyymm i.e, 201501 for Jan 2015 etc.,

That row may be hidden for avoiding it from the view.

Type the following in cell F3.
=SUMIFS(OFFSET(DATA!$AF$5,0,(LEFT(F$2,4)*1-2015)*12+RIGHT(F$2,2)*1,2294,1),DATA!$B$5:$B$2298,"HYD & TEL",DATA!$H$5:$H$2298,$E3)

Copy the formula and paste in all cells in the same row representing month and not the average.

Copy that entire row from column F and paste the same in rows where the data has to be captured.

Repeat for all sheets by replacing the name of the city instead of "HYD & TEL".

Enclosed the working file filling up sheet A- HYD&TEL. Other sheets deleted due to size restriction for upload.

 

[Mohandas]

Dear Mohandas,

In sheet A- HYD&TEL

Insert a row after heading and type the month and year in the format yyyymm i.e, 201501 for Jan 2015 etc.,

That row may be hidden for avoiding it from the view.

Type the following in cell F3.
=SUMIFS(OFFSET(DATA!$AF$5,0,(LEFT(F$2,4)*1-2015)*12+RIGHT(F$2,2)*1,2294,1),DATA!$B$5:$B$2298,"HYD & TEL",DATA!$H$5:$H$2298,$E3)

Copy the formula and paste in all cells in the same row representing month and not the average.

Copy that entire row from column F and paste the same in rows where the data has to be captured.

Repeat for all sheets by replacing the name of the city instead of "HYD & TEL".

Enclosed the working file filling up sheet A- HYD&TEL. Other sheets deleted due to size restriction for upload.

Than