Transfer data to specific tables according to year

Hello everyone
I have sheets("Data"). In Column A I have dates but dates are recorded as text like that
910 >> mean October 2009 - 1001 >> means January 2010 - 1408 >> means August 2014

In sheets("Output") I need to transfer data according years to the proper table as illustrated in Output sheet

910 >> mean October 2009 - 1001 >> means January 2010 - 1408 >> means August 2014

why? Excel works really well with proper dates.

Where is this data coming from?
Have you considered using a helper colum to create real dates from this?

Ok Mr. FDibbins
you can use helper column .. but how to transfer to these tables?

hmm OK lookinfg at your data again, I think all you need is this in C2, copied down and across...
=IFERROR(INDEX(Output!$B$2:$N$50,MATCH(Data!$B2,Output!$A$2:$A$50,0),MATCH(Data!C$1,Output!$B$1:$N$1,0)),"")

Thanks for help but I need to transfer data from Data sheet to Output sheet in the existing tables

Thats what that does.

If you put that in C2 on Output, and copy down/across, it produces the same values as your sample

First why to put this formula in C2 and not in A2
Second I expect results for 2009 to be in rows 2 :5 and the results for 2012 to be in rows 7:12 and there are sum formulas in between every two years ..

OK, I was basing my answer on the sample you provided in OUTPUT sheet, on the data you had in column B (Date)

Are you saying that you wont have the values in column B in OUTPUT? Because that looks to me to be a relatively simple progression

Hi Yasser,

Try this:

Please Login or Register  to view this content.

Mr. xladept
Thank you very much for this magic solution
It's exactly what I need ....
You're very helpful and awesome

Hi Yasser,

You're welcome and thanks for the rep!

Mr. xladept
I tested the code and find that the code insert rows automatically in results sheet if there are more rows
I need to delete the empty rows and to put the sum formulas by code ?
Sorry for bothering you again

Hi Yasser,

Try this - I also changed the code to get all the Columns labeled "Header".

Please Login or Register  to view this content.

Thanks again and again Mr. xladept for this great solution.
In fact I need this report to be reformatted by code ..
I will attach my basic entry and need to get the results with borders inside and outside and the results to be with no colors .. Just the totals for every year to be colored as illustrated ..
As for sum formulas I need to get only the values ..

Hope it is clear
Thanks advanced

Hi Yasser,

Try this:

Please Login or Register  to view this content.

Thanks a lot Mr. xladept
I'm so sorry for not clarifying my request well forgive me please
your last code is wonderful .. for totals for all the years and the whole total at last ..
But I need to insert rows of details for every year (these rows shouldn't be colored (No Fill) and with inside and outside borders for the whole table at the end
Thanks for your time and effort. I appreciate your geat and wonderful help

HI Yasser,

Try this- but you can't run it twice

Please Login or Register  to view this content.

And - Thanks for the rep given before!

I really can't believe myself
You are awesome .. Thanks a lot for this masterpiece
Thank you very much
Regards

You're welcome and thanks for the rep!