- Open the Menu
- Select Stock Management
- Select More
- Select External Stocktake
- Press Export Stocktake File
- Open Excel and go into the Data menu
- Select From Text/CSV from the top left of the data menu
- Select the CSV file you exported which is located in your downloads folder
- Select Transform Data
- Right click the Barcode column, change the type to Text
- Click Close & Load and it should be displaying correctly
- In the Home tab select the Conditional Formatting button
- Select Highlight Cells Rules
- Select Duplicate Values.
- Click on the Data menu
- Select Filter
- Click the drop down arrows select Filter by Color and filter by the colour used for the duplicates
- Sort the barcode column from A to Z so that the products sharing the same barcode are next to each other.
Comments
0 comments
Article is closed for comments.