Macro help required (Urgent)

[yrajnani]

I need your help in creating a macro to automate my data entry process
Below is how my sheet appears
A1-A554 is my product list , C1:C554 is their MRP List

Column L,Q,V,AA till IM (in a GAP of 5 have Opening Stock)
Similarly Column M,R,W,AB till IN ((in a GAP of 5 have Supply Stock)
And Column N,S,ZX,AC till IO have sales Stock (in a GAP of 5 have Sales Stock)
Counter codes are mentioned in merged cells (for e.g, L2:P2 has 1 counter code), (Q2:U2 has 1 counter code)
I need to put this data for a pivot dump in such a way that
Column A - HAS ALL PRODUCTS
Column B has their prices
Column C has their sales
Column D has supply
Column E has their opening Qty and Column F has the respective counter code..

Is it possible.. Any help with this would be highly appreciated..

Thanks,
Yogita

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=549581

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Guidelines (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.

Also note point 12 of the posting guidelines re 'urgent' requests.