Dear all,
Here is a detailed description about my case.
Background:
A given workbook(sales.xls) inculding a worksheet of
thousands of rows and 10 columns(A...J) like as following:
---------------Sample Sheet------------
A(CC).B(PN).C(s'code).D(amt).E(qty).F...J
1.CA45...66...CK........180......8
2.JD63...53...JB.........69......4
3.DG84...34...MJ.........30......3
4.CA46...86...CK........100......7
Remark:
column A is the customer code, B is part number, each code
belong to a corresponding sales person repectively which
shown in another sheet, customer.xls;
-----------------------------------
Here I think I need a macro to help to do following by one-step:
Case:
1. Base on convesion table in customer.xls workbook, create a
column between A&B as salesperson and then copy corresponding
salesperson to this column like following:
---------------------------
A(CC).B(Sales).C(PN).D(s'scode).E(amt).F(qty).G...J
1.CA45..Clive....66.....CK........180....8
2.JD63...John....53.....JB.........69....4
3.DG84...John....34.....MJ.........30....3
4.CA46..Clive....86.....CK........100....7
---------------------------
2. Next, create a new column between column D&F of sales.xls,
as price with formula as D/F with 4 decimal.
3. Then, sorting with column B( sales ) in accending order and
then copy rows with same salesperson in column B to a new
workbook like for all column B with value equal to Clive, then
new workbook will be Clive.xls.
4. In the new workbook, hidden some column likewise G and H.
Thanks for your kind attention.
Regards,
CL
cl.wong@hongkong.com
This message was edited by clwong on 2002-05-03 00:40
Here is a detailed description about my case.
Background:
A given workbook(sales.xls) inculding a worksheet of
thousands of rows and 10 columns(A...J) like as following:
---------------Sample Sheet------------
A(CC).B(PN).C(s'code).D(amt).E(qty).F...J
1.CA45...66...CK........180......8
2.JD63...53...JB.........69......4
3.DG84...34...MJ.........30......3
4.CA46...86...CK........100......7
Remark:
column A is the customer code, B is part number, each code
belong to a corresponding sales person repectively which
shown in another sheet, customer.xls;
-----------------------------------
Here I think I need a macro to help to do following by one-step:
Case:
1. Base on convesion table in customer.xls workbook, create a
column between A&B as salesperson and then copy corresponding
salesperson to this column like following:
---------------------------
A(CC).B(Sales).C(PN).D(s'scode).E(amt).F(qty).G...J
1.CA45..Clive....66.....CK........180....8
2.JD63...John....53.....JB.........69....4
3.DG84...John....34.....MJ.........30....3
4.CA46..Clive....86.....CK........100....7
---------------------------
2. Next, create a new column between column D&F of sales.xls,
as price with formula as D/F with 4 decimal.
3. Then, sorting with column B( sales ) in accending order and
then copy rows with same salesperson in column B to a new
workbook like for all column B with value equal to Clive, then
new workbook will be Clive.xls.
4. In the new workbook, hidden some column likewise G and H.
Thanks for your kind attention.
Regards,
CL
cl.wong@hongkong.com
This message was edited by clwong on 2002-05-03 00:40