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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.