mir994stan
New Member
- Joined
- Jul 18, 2021
- Messages
- 42
- Office Version
- 2016
- Platform
- Windows
Greetings to everyone,
i want to automate one procces at work, maybe it sound simple but i would need some help with macro coding. I have worksheet with unlocked 2 columns for data input, columns A and B. In column A i would like to write locations ( all locations are in this format 1-1-1, combinations of numbers from 1 to 10 ) and in column B ID numbers (Box ID format M007623121). Just to track my inventory in workshop. So i would need a macro to separate location data only to column A and box ID to column B.
What i' m trying to get here is, every value that i get with scanner that isn t location value to be writen in column B, and only locations to be in column A. Something like this in screen shot below. Any chance to make this work?
I could make this work by scanning location for each box, but i would like to scan location only once and then scan all boxes that would be stored there. To save time for scanning.
Thanks in advance!
i want to automate one procces at work, maybe it sound simple but i would need some help with macro coding. I have worksheet with unlocked 2 columns for data input, columns A and B. In column A i would like to write locations ( all locations are in this format 1-1-1, combinations of numbers from 1 to 10 ) and in column B ID numbers (Box ID format M007623121). Just to track my inventory in workshop. So i would need a macro to separate location data only to column A and box ID to column B.
What i' m trying to get here is, every value that i get with scanner that isn t location value to be writen in column B, and only locations to be in column A. Something like this in screen shot below. Any chance to make this work?
I could make this work by scanning location for each box, but i would like to scan location only once and then scan all boxes that would be stored there. To save time for scanning.
Thanks in advance!