VB Code to reorganize data

[rizmomin]

Hello:

Please refer to attached file.
I need VB code to reorganize data as shown.
Item Desc in column B
Item Code in column C
StoreName in column D
Size in Column F
Item Sold in Column G
Item Inventory on Hand in column H
I have created join in column I (StoreName&Size), this is listed in cell M1:AA1
I need code to go thru item from cell B2 down.
Enter Item Desc from column B in column K as shown with its coe in column L.
Now see Join in column I and enter sold qty as shown in cell M2 and Inventory in M3.
Now go thru anoother item from column B and enter in column K as shown with its code.
Now see Join in column I and enter sold qty as shown in cell O4 and Inventory in O5.
And so on


I hope this is clear.


Let me know if you have any questions.
Thanks.

[Olly]

Why not just use a pivot table?

[rizmomin]

Hello:

I have tried pivot but was confused how to get it as required.
Please help with pivot table if that can work.

Thanks

R

[Olly]

Insert a pivot table with Table1 as the source.

Values:
Sold (Summarize Values By: Sum)
Inv (Summarize Values By: Sum)

Columns:
Store
Join

Rows:
Desc
Store
Σ Values


Pivot Table > Design Subtotals > Do Not Show Subtotals
Pivot Table > Design > Report Layout > Show in Tabular Form

Format to suit.

[alansidman]

Riz
Attached is a Pivot Table. Advise if this works for you.



EDIT: Looks like Olly gave you the solution, already.

[rizmomin]

Hello Olly & Alan:

Thanks a lot, i will try to use this solution to fit in my situation.

R