Macro to autofill document moving data from rows to cells.

[bender1212]

Hi all,
An excel novice really needs some assistance in making their life an awful lot less stressful.
I receive a monthly forecast from one of my retailers who takes in well over 1000 different products. One of the forecasts which can be seen below details the products (in rows) and the dates on which these are required (in columns.)

		w/c		08-Sep	15-Sep	22-Sep	29-Sep	06-Oct	13-Oct	20-Oct	27-Oct
JBA	Description	Measure	TOTAL	1415W26	1415W27	1415W28	1415W29	1415W30	1415W31	1415W32	1415W33
F8J052UKWHT	::Belkin UK USB Wall Charger No Colour	Orders Raised	624	0	624	0	0	0	0	0	0
F8J052UKWHT	::Belkin UK USB Wall Charger No Colour	Run Rate Forecast	150	0	0	0	0	0	0	0	0
F8J052UKWHT	::Belkin UK USB Wall Charger No Colour	Additional Promo Volume	100		0	100	0	0	0	0	0
F8J052UKWHT	::Belkin UK USB Wall Charger No Colour	TOTAL:	874	0	624	100	0	0	0	0	0
F8J052uk04-WHT	::Belkin Wall Charger w/ Lightni No Colour	Orders Raised	0	0	0	0	0	0	0	0	0
F8J052uk04-WHT	::Belkin Wall Charger w/ Lightni No Colour	Run Rate Forecast	1800	0	0	300	0	0	0	0	300
F8J052uk04-WHT	::Belkin Wall Charger w/ Lightni No Colour	Additional Promo Volume	200	0	0	0	0	200	0	0	0
F8J052uk04-WHT	::Belkin Wall Charger w/ Lightni No Colour	TOTAL:	2000	0	0	300	0	200	0	0	300
F8J090bt04-BLK	::Belkin Car charger w/ lightnin No Colour	Orders Raised	0	0	0	0	0	0	0	0	0
F8J090bt04-BLK	::Belkin Car charger w/ lightnin No Colour	Run Rate Forecast	2450	0	0	0	0	0	200	0	450
F8J090bt04-BLK	::Belkin Car charger w/ lightnin No Colour	Additional Promo Volume	0	0	0	0	0	0	0	0	0
F8J090bt04-BLK	::Belkin Car charger w/ lightnin No Colour	TOTAL:	2450	0	0	0	0	0	200	0	450
F2CU012bt2M-WHT	::Belkin Micro USB Cable 2M No Colour	Orders Raised	0	0	0	0	0	0	0	0	0
F2CU012bt2M-WHT	::Belkin Micro USB Cable 2M No Colour	Run Rate Forecast	300	0	0	0	100	0	0	0	50
F2CU012bt2M-WHT	::Belkin Micro USB Cable 2M No Colour	Additional Promo Volume	100	0	0	0	0	0	100	0	0
F2CU012bt2M-WHT	::Belkin Micro USB Cable 2M No Colour	TOTAL:	400	0	0	0	100	0	100	0	50

<tbody>
</tbody>

What I want to be able to do is copy and collate all my forecast forecasts into one sheet let’s call it “forecast sheet” and have it automatically fill in the info on a second sheet “order book” (see below). You can see now that I have one line for each product and two columns, one for promo and one for run rate.

As mentioned above, one I have collated all forecast, I have over well 1000 lines that I ship and I receive a new forecast every month so to fill this out manually is not cool. Is there a macro or something that will do this for me?

							Run Rate	Promo	Run Rate	Promo	Run Rate	Promo	Run Rate	Promo	Run Rate	Promo	Run Rate	Promo
							22-Sep	22-Sep	29-Sep	29-Sep	06-Oct	06-Oct	13-Oct	13-Oct	20-Oct	30-Oct	26-Oct	26-Oct
	JBA	Brand	Category	Merchandiser	Buyer	Description	1415W28	1415W28	1415W29	1415W29	1415W30	1415W30	1415W31	1415W31	1415W32	1415W32	1415W33	1415W33
	F8J052UKWHT	Belkin	Audio/ Visual Cable	Holly	Kayleigh	::Belkin UK USB Wall Charger No Colour	0	100	0	0	0	0	0	0	0	0	0	0
	F8J052uk04-WHT	Belkin	Audio/ Visual Cable	Holly	Kayleigh	::Belkin Wall Charger w/ Lightni No Colour	300	0	0	0	200	0	0	0	0	0	0	0
	F8J090bt04-BLK	Belkin	Audio/ Visual Cable	Holly	Kayleigh	::Belkin Car charger w/ lightnin No Colour	0	0	0	0	0	0	200	0	0	0	0	0
	F2CU012bt2M-WHT	Belkin	Audio/ Visual Cable	Holly	Kayleigh	::Belkin Micro USB Cable 2M No Colour	0	0	100	0	0	0	0	100	0	0	50	0

<tbody>
</tbody>

Thanks so much to anyone that can help. You will be saving me a massive headache as there is absolutely no chance of me working this out on my own.