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