I am working on an estimate worksheet for lumber products and have an Excel file with two sheets:
Estimate: has list of products in Column A and various lengths in row 2
Sku data: has corresponding sku#'s for each product at their respective length
I am trying to insert sku # into a comment box for each product, for each length. Right now these sku#'s are manually enterred. Is there a way to auto populate the comment boxes using the sku data worksheet?
Hello senbi575,
Welcome to the Forum!
It would help to see a before and after example of what you want. If you can post a copy of your workbook then that would best. If not then create a workbook that has a few samples of the data (before and after) in the same places as the original. Be sure to change any information that might be confidential before you post it.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks