Case:
a data sheet with B1-Z1 as Vendor name;
and A2-A100 as Item number;
And B2-Z100 are their corresonding qty
If i want to move row1, i.e.B1-Z1's vendor name, into columnA and columnA to Row1 and all data move their corresponding cells.
How can I do that and it is better send me the Macro example.
Thanks a lot.
my email is :
cl.wong@hongkong.com
a data sheet with B1-Z1 as Vendor name;
and A2-A100 as Item number;
And B2-Z100 are their corresonding qty
If i want to move row1, i.e.B1-Z1's vendor name, into columnA and columnA to Row1 and all data move their corresponding cells.
How can I do that and it is better send me the Macro example.
Thanks a lot.
my email is :
cl.wong@hongkong.com