Paul, Thank you so much for this. This is exactly along the lines I am looking for. I love the error protection you built into the sheet.
I know little about excel Macros however i do have some coding experience and can pick up on what you are doing. I will mess around with it some more tonight and tomorrow morning and e-mail you with any questions. Thank you so much for your quick response. Its amazing to see so many outstadning people willing to share their knowledge with the world! On Thursday, June 12, 2014 6:34:46 AM UTC-7, Paul Schreiner wrote: ABSOLUTELY possible... and a variety of solutions. How conversant are you with VBA and userforms? Here's what I would do: I would create a userform that: Upon opening, it loads data into a Dictionary Object (MUCH easier to index than an array) Then, once the Unit and Step are entered, retrieve the data from the table. If the user overwrites the value, prompt for approval. In the attached file, the userform is opened by Double-clicking cell A1. If you REALLY wanted to, you could lock all the cells, and protect the document (Except for Cell A1) then, the user can ONLY update using the userform. In the macro, you would then unprotect the document, make the change, then re-protect. I threw this together pretty quickly (in about 40 minutes between phone calls and emails plus one trip for coffee) I didn't spend much time (if any) documenting the code, so if you have trouble following it, let me know. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- From: Michael Kohl <michael...@gmail.com <javascript:>> To: excel-...@googlegroups.com <javascript:> Sent: Wednesday, June 11, 2014 6:41 PM Subject: $Excel-Macros$ Macro Data entry by row and column search Looking for some help with a macro to run a couple operations. Here is the low down of what I am trying to accomplish. I have a sheet with 16 columns and about 500 rows. The first column contains row headers for the unit number (1-500). the first row contains the column headers for 15 steps in manufacturing.(call it A-O for example). Here is an example. A B C D E F G H I J K L M N O 1 100 874 454 456 525 2 101 845 584 588 651 3 103 654 215 4 359 5 658 489 685 6 542 7 658 2354 8 9 10 <td style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-s ... -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
