Hello:
NOTE : MY REQUIRE HAS CHANGED LITTLE SO REFER TO MY BELOW POST #7
Please refer to attached file.
I have list as shown in column A.
I need VB code to do following:
I will enter some starting character in cell D1 and code needs to list ONLY UNIQUE name with starting character as shown in D1.
Example if i enter "2GLEN" then the result will be as shown in column F
Let me know if you have any questions.
Thanks.
Riz
Last edited by rizmomin; 03-18-2019 at 07:10 PM.
See if this works for you.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Lalalalllaaa lalalalal ... lalalalal allalal .......
In Sheet1 module:
In standard module:Please Login or Register to view this content.
Please Login or Register to view this content.
You might want to use a textbox to do that, by using a textbox (and some code) you can search as you type, meaning each time you type a letter then the result will change accordingly, while using a cell you need to exit the cell first (or hit a button) to get the result.
Hello JLG:
Works great, Thanks
Riz
You're welcome, You can comment out or delete the line for the MsgBox. It was only for testing.Originally Posted by rizmomin
regards, JLG
Last edited by JLGWhiz; 03-10-2019 at 09:04 AM.
Hello:
Please refer to attached file.
I need VB Code to do following.
WIll select Item from cell D1.
I need all items starting with text shown in cell D2 (with its UPC Code),pasted at first
availble cell in column H
Let me know if you have any questions.
Thanks.
R
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks