Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA lookup and display data Quotation
Hi I would like to do a quotation sheet whereby a user types in the qty and code. The VBA would then lookup the description of the item and return it to the spreedsheet. Currently I am using excel and two sheets with vlookup, but this does not offer much protection of the descriptions (5800) of...- LECXE
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Reading from a text file in a macro
COuld someone please assist me with reading from a text file in a macro without all the opening and closing appearing to the user.None of my books seem to cover this topic.I know you have to use Workbooks.OpenText Filename:="C:\dir\filename.txt", Origin:=xlWindows, _...- LECXE
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Sorting alike objects under the same heading
How would I sort the following in excel: code description Main category Sub Category 1234 apple fruit tree 4567 orange fruit tree 3256 strawberry fruit ground 7890 potatoe vegetable ground 9876 gemsquash...- LECXE
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
