No calculations involved -- all text, but I'm trying to find a way to search a column in a table for the month, then copy all the text in the row that matches the desired month into a new table. Simple example:
Jan NY Made quota in first two weeks.
Jan OH Didn't make quota
Feb CA Didn't make quota
Mar NY Sold out of product A
The months are in column A. So in a separate worksheet, I want to say: If column A = Feb, then copy the other two columns in the rows that have Feb in column A. So the result for a search on "Feb" would be "Feb - CA - Didn't make quota" in columns A-C on the second sheet, if that makes sense.
People will be entering this data throughout the year, so each month, I want to be able to run a report on current month's comments.
The descriptions in column C would vary, so a validation list could not be used, if that makes a difference (and there are more columns, some of which are validation lists, but I'm keeping this example simple).
Thanks!
Jan NY Made quota in first two weeks.
Jan OH Didn't make quota
Feb CA Didn't make quota
Mar NY Sold out of product A
The months are in column A. So in a separate worksheet, I want to say: If column A = Feb, then copy the other two columns in the rows that have Feb in column A. So the result for a search on "Feb" would be "Feb - CA - Didn't make quota" in columns A-C on the second sheet, if that makes sense.
People will be entering this data throughout the year, so each month, I want to be able to run a report on current month's comments.
The descriptions in column C would vary, so a validation list could not be used, if that makes a difference (and there are more columns, some of which are validation lists, but I'm keeping this example simple).
Thanks!