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
[TABLE="width: 905"]
<colgroup><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DEPT[/TD]
[TD]EMPNAME[/TD]
[TD]ID[/TD]
[TD]CATEGORY[/TD]
[TD]DESC[/TD]
[TD]CCY[/TD]
[TD]REF[/TD]
[TD]SELLER DETAILS[/TD]
[/TR]
[TR]
[TD="align: right"]1-Aug-18[/TD]
[TD]ACCT[/TD]
[TD]MICK[/TD]
[TD] [/TD]
[TD]STATIONARY[/TD]
[TD]STATIONARY DETAILS[/TD]
[TD]USD[/TD]
[TD]A12345[/TD]
[TD]MICK[/TD]
[/TR]
[TR]
[TD="align: right"]1-Aug-18[/TD]
[TD]ACCT[/TD]
[TD]ALADIN[/TD]
[TD] [/TD]
[TD]STATIONARY[/TD]
[TD]STATIONARY DETAILS[/TD]
[TD]USD[/TD]
[TD]A12345[/TD]
[TD]KIMBERLEY[/TD]
[/TR]
</tbody>[/TABLE]
<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
[TABLE="width: 905"]
<colgroup><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]DEPT[/TD]
[TD]EMPNAME[/TD]
[TD]ID[/TD]
[TD]CATEGORY[/TD]
[TD]DESC[/TD]
[TD]CCY[/TD]
[TD]REF[/TD]
[TD]SELLER DETAILS[/TD]
[/TR]
[TR]
[TD="align: right"]1-Aug-18[/TD]
[TD]ACCT[/TD]
[TD]MICK[/TD]
[TD] [/TD]
[TD]STATIONARY[/TD]
[TD]STATIONARY DETAILS[/TD]
[TD]USD[/TD]
[TD]A12345[/TD]
[TD]MICK[/TD]
[/TR]
[TR]
[TD="align: right"]1-Aug-18[/TD]
[TD]ACCT[/TD]
[TD]ALADIN[/TD]
[TD] [/TD]
[TD]STATIONARY[/TD]
[TD]STATIONARY DETAILS[/TD]
[TD]USD[/TD]
[TD]A12345[/TD]
[TD]KIMBERLEY[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
<strike></strike>