Hi,
Pls help.. Im new to excel
Have an excel with 4 sheets.. each sheet represent a seller selling quota for a day in an excel.
and sales varies from seller to seller
seller1 ; can have 150 sales for a day
seller2 ; sales = 0
seller3 ; sales = 25
how can i use a macro or formula to output column A to H in a another sheet and another workbook
that will combine all 3 seller details
also In new sheet & workbook, i need to have an extra column that will contain the sheet name i.e. SELLER DETAILS,
DATE | DEPT | EMPNAME|ID | CATEGORY | DESC| CCY |REF |SELLER DETAILS
<colgroup><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody><strike></strike>
<strike></strike>
Pls help.. Im new to excel
Have an excel with 4 sheets.. each sheet represent a seller selling quota for a day in an excel.
and sales varies from seller to seller
seller1 ; can have 150 sales for a day
seller2 ; sales = 0
seller3 ; sales = 25
how can i use a macro or formula to output column A to H in a another sheet and another workbook
that will combine all 3 seller details
also In new sheet & workbook, i need to have an extra column that will contain the sheet name i.e. SELLER DETAILS,
DATE | DEPT | EMPNAME|ID | CATEGORY | DESC| CCY |REF |SELLER DETAILS
DATE | DEPT | EMPNAME | ID | CATEGORY | DESC | CCY | REF | SELLER DETAILS |
1-Aug-18 | ACCT | MICK | STATIONARY | STATIONARY DETAILS | USD | A12345 | MICK | |
1-Aug-18 | ACCT | ALADIN | STATIONARY | STATIONARY DETAILS | USD | A12345 | KIMBERLEY |
<colgroup><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<strike></strike>