This may be very a very simple Q for you guys, but I have no idea.
My background is programming in SAS so excel seems to be chinese but I need help with this if possible.
What I am trying to do.
On sheet 1 I have 3 columns, Date, Dealer, Concern.
I'd like to by hitting a button, pick out a number key words from the 'concern' list and have them listed on sheet 2.
for example, I can have up to 20 rows of info in sheet 1, if in the 'concern' column the words 'broken' or 'damaged' came up (the box does have a string of text and 'broken' would possibly be one of the words), I'd like that row of info on sheet 2.
Is this possible?
Any help would be very much appreciated.