Macro to autofill document moving data from rows to cells.

bender1212

New Member
Joined
Sep 24, 2014
Messages
1
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-Sep15-Sep22-Sep29-Sep06-Oct13-Oct20-Oct27-Oct
JBADescriptionMeasureTOTAL1415W261415W271415W281415W291415W301415W311415W321415W33
F8J052UKWHT::Belkin UK USB Wall Charger No ColourOrders Raised6240624000000
F8J052UKWHT::Belkin UK USB Wall Charger No ColourRun Rate Forecast15000000000
F8J052UKWHT::Belkin UK USB Wall Charger No ColourAdditional Promo Volume100010000000
F8J052UKWHT::Belkin UK USB Wall Charger No ColourTOTAL:874062410000000
F8J052uk04-WHT::Belkin Wall Charger w/ Lightni No ColourOrders Raised000000000
F8J052uk04-WHT::Belkin Wall Charger w/ Lightni No ColourRun Rate Forecast1800003000000300
F8J052uk04-WHT::Belkin Wall Charger w/ Lightni No ColourAdditional Promo Volume2000000200000
F8J052uk04-WHT::Belkin Wall Charger w/ Lightni No ColourTOTAL:200000300020000300
F8J090bt04-BLK::Belkin Car charger w/ lightnin No ColourOrders Raised000000000
F8J090bt04-BLK::Belkin Car charger w/ lightnin No ColourRun Rate Forecast2450000002000450
F8J090bt04-BLK::Belkin Car charger w/ lightnin No ColourAdditional Promo Volume000000000
F8J090bt04-BLK::Belkin Car charger w/ lightnin No ColourTOTAL:2450000002000450
F2CU012bt2M-WHT::Belkin Micro USB Cable 2M No ColourOrders Raised000000000
F2CU012bt2M-WHT::Belkin Micro USB Cable 2M No ColourRun Rate Forecast30000010000050
F2CU012bt2M-WHT::Belkin Micro USB Cable 2M No ColourAdditional Promo Volume1000000010000
F2CU012bt2M-WHT::Belkin Micro USB Cable 2M No ColourTOTAL:4000001000100050

<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 RatePromoRun RatePromoRun RatePromoRun RatePromoRun RatePromoRun RatePromo
22-Sep22-Sep29-Sep29-Sep06-Oct06-Oct13-Oct13-Oct20-Oct30-Oct26-Oct26-Oct
JBABrandCategoryMerchandiserBuyerDescription1415W281415W281415W291415W291415W301415W301415W311415W311415W321415W321415W331415W33
F8J052UKWHTBelkinAudio/ Visual Cable HollyKayleigh::Belkin UK USB Wall Charger No Colour01000000000000
F8J052uk04-WHTBelkinAudio/ Visual Cable HollyKayleigh::Belkin Wall Charger w/ Lightni No Colour3000002000000000
F8J090bt04-BLKBelkinAudio/ Visual Cable HollyKayleigh::Belkin Car charger w/ lightnin No Colour00000020000000
F2CU012bt2M-WHTBelkinAudio/ Visual Cable HollyKayleigh::Belkin Micro USB Cable 2M No Colour00100000010000500

<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.



 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,186
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top