GreggR57
05-24-2022, 02:43 PM
I have a packing list, where the user selects a product from a drop-down list. The filenames are usually like "xxx-xxx.xlsm". My problem comes when they have a product with a filename of "XX-10XX XX-X 4up 2High.xlsm", sometimes it's longer than that. The packing list can only use the actual product number,(XX-10XX XX-X), but needs to access one of the sheets in that file, but because of the rest of the name, the macro doesn't "see" the file, and won't get the needed info. Unfortunately I can't change the filename as there are variations in each file that need to be separated.
How it works...
The user selects the product, xxx-xxx, on the packing list, the macro then looks at the file, xxx-xxx.xlsm/"Retain Sheet" cells "C1 and E1" for the line number and Team letter respectively, and fills out the pallet ID#. A PO# can be used if available and needed. The idea is to automate, and take as much human error out as possible. When the packing list is printed, the last three numbers in the pallet ID advance by 1.
Can anyone help, please?
Thank you in advance to anyone who can help. If more info is needed, please let me know.
How it works...
The user selects the product, xxx-xxx, on the packing list, the macro then looks at the file, xxx-xxx.xlsm/"Retain Sheet" cells "C1 and E1" for the line number and Team letter respectively, and fills out the pallet ID#. A PO# can be used if available and needed. The idea is to automate, and take as much human error out as possible. When the packing list is printed, the last three numbers in the pallet ID advance by 1.
Can anyone help, please?
Thank you in advance to anyone who can help. If more info is needed, please let me know.