Search results

I’m using the formula shown below in a list data validation in cell K2. There are three possible entries in J2, they are Employee, Customer or Supplier, each of these are individual tables that have two columns each. As it is now when I select the drop down in K2 it displays the table data in a...

Perfect, does everything I was looking for, thanks for the education, you're the best

chirayu... it's like magic, very impressive. In the first code you provided you included SubRng = SubRng.Value to replace formulas with values. I tried adding this to your latest code but it's not working. I may not have been clear on this, cells in columns A, E, L, N, O, P, Q have formulas that...

Thank you for helping... it's not working and I'm not sure what's happening but it may have to do with the formula in column-A. When I run the macro it wipes out all the formulas in column-A, I'm guessing because there's a "+" in the actual formula. The reason for the replacement of + to - was...

I've been attempting to put this together and have concluded it's just beyond my skill level, any help would be awesome and greatly appreciated... thanks for looking. I'm using the code shown below which looks in column-A for "+", then for all rows that have this character it locks each cell in...

Thanks guys, I appreciate the help

Does anyone know if there is a way to use =TODAY() in a formula and once the date appears it never changes, I'm looking at something like this... thanks for looking. =IF(A1="","",TODAY())

Excellent, definitely does everything I was looking for and great idea eliminating the date list... have one on me. One last thing on this and I can put it to bed. The validation works great when typing in the date but is ignored when using an ActiveX trigger, what's up with that? If you get a...

Okay, I've been busy on this spreadsheet and with your help have figured out a few things on my own and may have hopefully simplified the issue so disregard everything prior. E2 is my only problem that I can't get past, it is the last entry done on a row. It has a data validation list...

I've made a few changes, please disregard the previous spreadsheet, I've attached the newest version here, the text in the previous post still does apply... thank you again

Good morning Luke & thanks for the help... I changed the formula a bit: =IF(COUNTBLANK(B2:D2)+COUNTBLANK(F2:Q2),"-","+") I also screwed up because I left out an important detail which is why I was looking a data validation. I was thinking that if A2 is "-" (meaning that there is at least one...

I'm on a roll here with Data Validation, hopefully with the help I'm getting it'll eventually sink in. I'm looking for a data validation that will prevent blank cells… a more specific explanation is included in the attached spreadsheet... thank you for looking

Narayan... excellent, works superbly Thank you

Thank you

Thank you Hui... very helpful information Best reguards

I'm attempting to create a custom data validation that forces only upper-case and makes the text "N/A" exception in a field that is formatted to output only numbers. I have code for the upper-case portion and the "N/A" portion but am unable to bring them together in a single validation formula...

I'm hoping this is the correct forum for this and if not then I apologize. I've searched the site for some kind of guidelines for giving donations but have not found much, except that it would make me awesome to do so... I am open to becoming awesome, but I do have just two questions. How is...

Naresh... thank you, it works perfectly

To all... thank you so much, each suggestion is very helpful and each has elevated my knowledge. The Name Manager is a new thing for me, I did some research, very cool feature. Naresh... question for you on your formula in column C. Open the attachment and you'll see #N/A in C4, this happens if...

I am attempting to tweak a spreadsheet formula and a validation list formula that I can’t get to work correctly. I’ve inserted the details of my dilemma within the attached workbook, if you can help I’d be very appreciative... thank you for looking.

Awesome... thanks Hui

Can someone tell me what the "Set UserAnswer" line would look like without the message box popup. I don't need the message box because the range is static... thank you Sub GenerateRandBetweenUniqeIntegers() Dim UserAnswer As Range LowerInteger = "1" UpperInteger = "100" Set UserAnswer =...

r2c2... just what the doctor order, works perfectly right out of the gate, thank you very much

I’m looking to create a Data Validation to confirm a proper entry into a cell. The front of the entry can have any quantity of alphanumeric characters… the middle has a hyphen… the end has three digits. Entry Examples: R365-000 11143A-001 437-005 N20267B-010 What they all do have that...

It took me a while to wrap my head around your code, "helper columns", pretty brilliant, thanks for the TEXTJOIN tip... very helpful in all respects.