|
Answer» Hi!
I am trying to find a macro to use in excel VBA
I have two worksheets in excel. One contains a masterdatabase of all the information I have, and the other contains a subset of that information, with some columns having been updated. I need to find a way to search through my masterdatabase, and WHENEVER a cell in a certain COLUMN (C) matches a Cell value in Column B of the second worksheet, I want to use the values/formulas from that second worksheet. If they do not match, than I want to leave it as is..
I TRIED a do while loop that set my rows and columns as integers, but I had ERRORS with that.. any options with this?
Thanks!Without using vba, can you use the vlookup function? I know it sounds simplistic and thus probably isn't what you need but I thought I would put it out there just in case.
|
