A friend asks me this... I'm unsure of an answer, except repetitive IF statements.
I'm writing a macro that I can use to take comments from 4 separate worksheets and dump them in labeled row in the same cell.
E.g., sheet 1 cell(1,2) comments + sheet 2 cell(1,2) comments, etc with line breaks so it doesn't all run together.
Got that working pretty flawlessly, except that these sheets are from weekly reports, and sometimes the week-to-week status doesn't change.
I want to write a conditional function that does the following
if Sheet 1 cell != Sheet 2 Cell
then aggregate sheet cell = sheet 1 + sheet 2
if sheet 2 cell != sheet 3 cell
then aggregate sheet cell = aggregate sheet cell + sheet 3 cell
is there any way to do this without obnoxious, repetitive if/then statements?
Is there anything available in VBA that is equivalent to the Case function from Java?
Bookmarks