Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

VBA Code to add a definition in one column for a term in another column in the corresponding line in every worksheet of a spreadsheet.


Is there an easy way to write a macro in Excel Office 2010 or insert a VBA code to insert multiple instances of the same definition for the same term that occurs on many worksheets in the file? I am new to this but the logic is like this (I am using columns c and g with a variable line x):

If c(x) = "term" Then Insert "definition" into g(x).

Any suggestions?




Sounds like a candidate for Vlookup.


Answer the Question

You must create an account to use the forum. Create an Account or Login