Hey everyone,
I am new here and have a question. Bare with me though because I am not sure if my explanation is going to be clear.
Attached is the sheet I am currently working on.
There are multiple sheets with lists with multiple columns.
The first sheet, the setup sheet, is where the user is to input data.
I want to be able to input a part no. and have the rest of the fields either input the correct data, or create a drop down to select from (if the part is in multiple machine lists). From here, i would like all of the information to fill in properly from there.
I have yet to use macros myself, but i feel like this is able to be done.
Any help would be appreciated.
Thank you!
Fred
Hi Fred
Seems a bit complex...but...I'll bite.
Give me 4 or 5 part numbers, part number descriptions and their dependencies (OP#, S/O...don't know what this is, OP Description, Tool Description, etc.)
Having given that, please fill out a worksheet in a NEW attached workbook detailing what you expect to see for a given part number.
Perhaps I can help...perhaps not.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks