MAKE EXCEL MACRO TO EDIT DATA IN EXCEL FILE

PLEASE SEE ATTACHMENT EXCEL FILE. AND DESCRIPTION SHEET IN THERE.

STEP 1

first find and replace "Item Number" values in Master-Data by looking at ItemNumberTable

STEP 2

In Master-Data, find and remove any order line, if "Item Number" is in between A-5200 to A-5400 or if "Item Number" value starts with "K-"

STEP 3

In Master-Data, look "Origin" values for each "Order Number", and fill in "Remarks" column by separating them with comma and removing duplicates.

STEP 4

In Master-Data, look at order numbers, if any order number having same "Item Number" more than once, first combine their QTY and then reduce to one line

SAVE FINAL DATA TO NEW SHEET.

SAMPLE MASTER DATA IS SMALL DATA, NORMALLY IT WILL HAVE 1,500 TO 2,000 LINES.

データ入力 エクセル HTML マイクロソフトアクセス PHP

プロジェクトID: #15366492

プロジェクトについて