Dear Members,
I am new in Excel and want your help in generating SKIU Code in Excel. I have this question
In the For Printing worksheet in A5, generate a part code using "SKU-" followed by the Material Code, another "-" and the Part Number, e.g. SKU-07-2425. Copy the formula down. What is the value for Check Digit 1 (cell H5)?
for the 1st part, use the & function to combine the info in each cell.
For the 2nd part, I have NO clue what you mean. Try explain what you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There is a hidden sheet named Check Digit where the Check Digits H5:H9 are linked to. This is also the sheet where SKU Codes have already been generated.
Question: how did the Check Digit sheet got hidden but unable to unhide on right-clicking on any existing sheet tab?
Last edited by josephteh; 10-19-2020 at 10:28 AM.
thanks...............
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks