Icon

How to Efficiently Manage Inventory Movements in Excel

Learn step-by-step instructions for managing inventory movements using Excel, including filtering, sorting, and updating item groups.

By Josh Robinson

In this guide, we'll learn how to manage and organize data using a series of steps involving filtering, sorting, and updating information in a spreadsheet. The process includes identifying specific movements, filtering columns to focus on relevant data, and sorting information for better clarity. We will also explore how to update item groups and utilize extended stock locations to ensure efficient space management. By following these steps, you can effectively track and move items within your system, ensuring accuracy and efficiency in your data management tasks.

Let's get started

Alright. First, click "Identify Movements."

1
Click on "Identify Movements"
Step #1: Click on "Identify Movements"
2
Click on "Movements"
Step #2: Click on "Movements"

Understood. Then, click OK.

3
Click on "OK"
Step #3: Click on "OK"

Filter column N to remove blanks.

4
Click here
Step #4: Click here
5
Click on "Blanks"
Step #5: Click on "Blanks"

I'm sorry, but there is no content to refine. Could you provide more text?

6
Click on "OK"
Step #6: Click on "OK"

Okay. Filter column N to display only the entries you want to move, such as 36, 37, 38, 39, 40, and 41.

7
Click on "T"
Step #7: Click on "T"
8
Click on "("
Step #8: Click on "("
9
Click on "("
Step #9: Click on "("
10
Click on "36/37/38/39/40/41"
Step #10: Click on "36/37/38/39/40/41"
11
Click on "OK"
Step #11: Click on "OK"

Hmm. Sort column H from H to Z.

12
Click on "26 0 36/37/38/39/40/41 36/37/38/39/40/41 ( Showing Alld 27 1 Yes Found 28 1 36/37/38/39/40/41 Yes Found 28 1 36/37/38/39/40/41"
Step #12: Click on "26 0 36/37/38/39/40/41 36/37/38/39/40/41 ( Showing Alld 27 1 Yes Found 28 1 36/37/38/39/40/41 Yes Found 28 1 36/37/38/39/40/41"
13
Click here
Step #13: Click here

Hmm. Alright. Next, we'll proceed to IP.

14
Click here
Step #14: Click here

Number 7, number 4, type 10600.

15
Click on "7. Returns"
Step #15: Click on "7. Returns"
16
Click on "4. Stock Movement"
Step #16: Click on "4. Stock Movement"

You will create an item group, OK.

17
Type "10600 + Enter"
18
Click on "Oltem group"
Step #18: Click on "Oltem group"
19
Type "Enter"

Take the GTIN of the item you want to move.

20
Click on "05050808371111"
Step #20: Click on "05050808371111"

We'll use this one.

21
Click on "05050808375850"
Step #21: Click on "05050808375850"
22
Type "Ctrl + C"
23
Click here
Step #23: Click here

Hmm.

24
Click here
Step #24: Click here
25
Type "Ctrl + V"

Press Enter, then go back.

26
Type "Enter"
27
Click here
Step #27: Click here

Click on GTIN to change it to the item group and remove the last two numbers.

28
Click here
Step #28: Click here
29
Click on "Vendor / Vendor style"
Step #29: Click on "Vendor / Vendor style"
30
Drag here
Step #30: Drag here
31
Type "Backspace"
32
Click on "049"
Step #32: Click on "049"

Okay.

33
Type "Backspace"
34
Type "Enter"

Select "Use Extended Stock Location."

35
Click on "Use extended location selection"
Step #35: Click on "Use extended location selection"

Okay.

36
Click here
Step #36: Click here

We will change this to the values in column N.

37
Click here
Step #37: Click here

36, 37, 38, 39, 40. 36, 37, 38, 39, 40.

38
Click here
Step #38: Click here

Okay.

39
Type "3637383940 + Enter"

Only move your 38s and 39s, as that is the size in column F.

40
Click here
Step #40: Click here

We will review this 38.

41
Click here
Step #41: Click here
42
Click here
Step #42: Click here
43
Click on "2026-51124-0004-049-0380"
Step #43: Click on "2026-51124-0004-049-0380"

It's 279LC, which matches D1 in the Excel file.

44
Click on "Review Detail"
Step #44: Click on "Review Detail"
45
Click here
Step #45: Click here

We will make it space-efficient.

46
Click on "Space Efficient"
Step #46: Click on "Space Efficient"

Okay.

47
Click here
Step #47: Click here

We will check D39.

48
Click on "2026-51124-0004-049-0390"
Step #48: Click on "2026-51124-0004-049-0390"

Review the details.

49
Click on "Review Detail"
Step #49: Click on "Review Detail"

That is 2860H, which matches the Excel file.

50
Click on "Location"
Step #50: Click on "Location"
51
Click on "TH"
Step #51: Click on "TH"

We have plenty of space available.

52
Click here
Step #52: Click here
53
Click on "Efficient"
Step #53: Click on "Efficient"

Okay.

54
Click here
Step #54: Click here

You may proceed.

55
Click here
Step #55: Click here

Okay.

56
Click here
Step #56: Click here

Then, open the IP dashboard.

57
Right-click here
Step #57: Right-click here

Store the sheets.

58
Click on "031PDIRECTD.vpt"
Step #58: Click on "031PDIRECTD.vpt"
59
Type "afr + Tabalfiebo@27 + Enter"
60
Click on "Putaway . Sheets"
Step #60: Click on "Putaway . Sheets"

Change the date. Change the S to M.

61
Double-click here
Step #61: Double-click here
62
Click on "06/05/25"
Step #62: Click on "06/05/25"
63
Click here
Step #63: Click here
64
Click here
Step #64: Click here

I hope I got it right.

65
Click here
Step #65: Click here
66
Click here
Step #66: Click here
67
Click on "✓"
Step #67: Click on "✓"

Then, check your last range.

68
Click on "05/06/25"
Step #68: Click on "05/06/25"
69
Click here
Step #69: Click here
70
Drag here
Step #70: Drag here
71
Click here
Step #71: Click here

You can see that they have moved to bay 36.

72
Click here
Step #72: Click here
73
Click here
Step #73: Click here
74
Click on "OK"
Step #74: Click on "OK"

Then, you print. And that's it.

75
Click here
Step #75: Click here
76
Click here
Step #76: Click here
77
Click here
Step #77: Click here
78
Click on "Print"
Step #78: Click on "Print"