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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Replace Vlookup
I'm having the same issue...but I don't understand your answer. I have Worksheet 1, with an Equipment No. column. This column can have duplicate Equipment Nos. (the same number can appear in different rows in that same column). There is also a blank column that needs a location filled in...- williards
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Macro
I guess I don't know enough about Excel or Visual Basic to understand your answer. I looked at VLookup but it didn't seem to fit what I want to do. A macro is what I use to perform an action on some data, right? So, I will need to build a macro to do the transfer of data from one worksheet to...- williards
- Post #3
- Forum: Visual Basic (Classic)
-
HOW DID HE GET THERE WERE HE IS NOW
Gates' only "luck" was to be talented in a field that was the future. His real genius is in surrounding himself with people that are also very talented in their fields (i.e.- finance, marketing, business law, etc.) and not wanting to do it all on his own. Humility is how he got where...- williards
- Post #17
- Forum: Tech Industry Trends
-
Excel Macro
I'm trying to populate a cell in a "Location" column with text from a different worksheet, based on a common "Equipment No." I.E.- Worksheet 1 has a Column C (Equipment No.) with multiple occurrences of Equipment No. 12345. It also has a Column D (Location) that is not...- williards
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
