Hi
I'm unsure if there is a solution to this. I've created a few fields basically for the workshop foreman to fill in, however, he keeps missing out on filling out one crucial field of steel heat numbers.
Is there a way of "locking" the fields until he fills in the correct heat number first? So if let's say he fills in the "heat number" fields, then all other fields are automatically unlocked.
Regards
Try using Data Validation With Custom Formula. If you post a sample workbook then you will get exact solution.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi
Please find attached sample spreadsheet. They need to fill in Cell K3 first and then after that they can fill in other cells in that row in any order they want. I believe that Cell K3 is important to be filled out first.
Regards
ryback,
Please see attached. There is a custom formula in DV:
in cells D-J & L-M in Row 3, which prevent data entry to those cells while K3 is blank. If I may, I would suggest (from an end-user point of view) moving that column/column header nearer to the left, even to Column D, so your end-users are not having to tab/mouse over to K, then back to D to fill in the rest of the info.
Please Login or Register to view this content.
Anyway, I hope this helps.
Off-topic - '72 wasn't a bad year, eh?!
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Hi Brendan
Thanks for that, I'll take your advise on moving the Heat number column near to it.
By the way, how did you manage to Code it, as I wish to apply this further to my spreadsheets in future.
1972 was definitely a great year, unlike today! but still you have to thank todays technology!
Regards
Ben (ryback).
Hey Ben,
Sorry, I didn't notice that you were using Excel 2003, and it been a while..... I presume there's a Data Validation (DV) button/icon there somewhere, probably in the Data tab/dropdown? Actually, I just googled it, and yes, there's a Validation option within the Data dropdown So in the "settings" tab, under "Allow", select "Custom" - this allows you to input a custom formula in the "Formula" field.
Try it yourself - in your file, select/highlinght D4:J4, -> Data -> Validation -> Allow Custom -> UNCHECK THE "Ignore blank" CHECKBOX -> type/paste:
in the formula field -> Ok. You should now not be able to type anything in D4:J4 unless there's an entry in K4. And you can of course change the error alert to one of your own choosing ("I told you not to leave K4 blank!!!)Please Login or Register to view this content.
Hope this helps.
Last edited by BB1972; 11-15-2012 at 08:52 PM. Reason: Messed up the formula!
Hi Brendan, I haven't updated my profile yet, I'm actually using Excel 2010. I'll try it out.
Regards
Hi Brendan
Since I'm using Excel 2010, I've been trying it out, but I still couldn't get it to do what it suppose to do. I must be doing some thing not right.
Where are you going wrong? What isn't working? I'd imagine that you are not prevented from entering any data into the cells before there's an entry in K4, but for the sake of clarity, let's not make assumptions
Hi Brendan
See attached...I've moved the SHS Heat # closer, on the left side, and I highlighted the row from Welder ID right to the Wire Batch, then I clicked Data > Data Validation > Custom > Unchecked Ignore Blank > set the data to =D3<>"" and put in my comments. but it didnt work...it only worked when I typed in under UT report#, then the notification start....but Welder ID, Date Started can still be entered.
Not sure if you had saved your work, but there was no validation applied to E3:S3, although from what you've described, you followed the correct stops. I've applied the DV to E3:S3 (one the "1 x CrossBeam" tab) - make sure this is working for you, and see if you can apply the same to E4:S4.
Hi Brendan, hope you had a great weekend. Thanks for the worksheet, and it works perfectly well. Applied it during the weekend, so see how we go with the Supervisor's temper! hah!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks