how to write A VBA to created content List from Sheet 1 to Sheet2

Please, Please do not mix merged cells and VBA
Revisit your layout using tabular form without merged cells.
read the link attached, advice will save you potential future frustration
torachan.

https://www.excelforum.com/excel-gen...ml#post5122447

Hi Torachan,

That is not similar to my situation, I need VBA to created sheets 2, data from sheets 1 to transform into sheets 2, arrange by Po#.
For the PO# that cell no merge is ok, output on sheets 2 as per photo.

I will pass on this one - someone else may pick it up.
I have enough experience to know when to leave someone to their own demise.
torachan.

hi Torachan,

Can help me done a bit on it.

if i did it your list would have to look like the attached file.
I do not work with merged cells.
torachan.

OK, torachan done without merged cell

The Order # is in a merged cell, if this plays up just remove the two lines (merging and centering).
macro in sheet one module on green button
torachan.

Thanks, Torachan, appreciate actual what I wanted.

Thank you, kvsrinivasamurthy