VB Code to arrange data in Table format

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown in sheet.
I need VB Code to rearrange these data in Table format as shown from Row 21 down for all stores.
I have manually done for one product ID 22123.


Each item in column A Cell A3 thru A12 has 2 rows
Row 3,5,7,9 and 11 has Qty Sold
Row 4,6,8,10 and 12 has Qty on Hand.
Each Item has ProdID in column C as shown.
Each store has data for size shown in row 2.
Store Name is in row1.


Let me know if you have any questions.
Thanks.

Riz

[brant.wheeler]

Add this code to your workbook and it will do this for you.

Please Login or Register  to view this content.

[rizmomin]

hello Brant

Works great, it does not pull Store Name in Column C.
Pls modify the code to accoplish that

Thanks

Tiz

[rizmomin]

Hello Brant:

I got it by changing

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks a lot

Riz