A
AncientLearner
I am trying to create a macro that will loop through list of items containing
4 columns and Paste Special Values Transpose into a Single column on a blank
worksheet. My problem is that Col C & D are blanks, so I need to step down 4
rows with each paste.
PartNo-Qty-Blank1-Blank2
I need it to be:
PartNo
Qty
Blank1
Blank2
PartNo
Qty
Blank1
Blank2
4 columns and Paste Special Values Transpose into a Single column on a blank
worksheet. My problem is that Col C & D are blanks, so I need to step down 4
rows with each paste.
PartNo-Qty-Blank1-Blank2
I need it to be:
PartNo
Qty
Blank1
Blank2
PartNo
Qty
Blank1
Blank2