hat
Sipoze ou gen yon Fèy travay ki gen done nan kolòn A nan G, non vandè a se nan kolòn A epi ou bezwen otomatikman fann done sa a nan fichye miltip ki baze sou kolòn nan A nan travay la menm. Chak vandè pral separe nan yon nouvo Fèy travay. Kutools pou Excel'S Dat Split sèvis piblik ka byen vit fann done nan plizyè fich ki baze sou chwazi kolòn nan Excel.
eng
Supposing you have a worksheet that has data in columns A to G, the salesman’s name is in column A and you need to automatically split this data into multiple worksheets based on the column A in the same workbook. Each salesman will be split into a new worksheet. Kutools for Excel’s Split Date utility can quickly split data into multiple worksheets based on selected column in Excel.