Hi all,
My name is John Quinn. I'm a test engineer at P&G-Gillette in South Boston. I have been using Excel for several years and I'm fairly proficient at its basic functionality. I've recently learned and made extensive use of pivot tables. However, I have not taken advantage of such features as Data Validation, VBA, etc.
I look forward to sharing ideas in this forum. In fact, I have a data validation question which I'll post, immediately.
Regards,
JQ
Gurus,
How do I structure a cell via data validation to enble the user to either make a manual entry or choose from the items of a picklist. Data validation seems to allow one option ro the other, but not both for any one cell.
JQ
Welcome. We look forward to your participation.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi john
Welcome to the Forum!!
Your question would be more appropriate in the Excel General Forum and I'm suggesting Alan move it there.
In the event that doesn't happen, in the Error Alert Tab uncheck the "Show Error Alert After Invalid Data is Entered".
ANYTHING will be accepted...
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
You're welcome...glad I could help. Thanks for the Rep.
Hi john
If this resolves your issue please mark your Thread as SOLVED.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks