How to: When a column has 1 of 3 values, copy text

Closed
Report
Posts
1
Registration date
Thursday November 30, 2017
Status
Member
Last seen
November 30, 2017
-
 Blocked Profile -
Hello,

I have an Excel book with 2 sheets (1 has a macro view and 1 has a micro view). The micro view sheet has a column B where the user enters a statement/sentence and column A has 3 categories. What I'm trying to do is when a user selects a category for column A (category 1), then I'd like the data from column B to copy over to the macro sheet in it's column A.

Any advice would be appreciated!

- Drew


1 reply


Look at Vlookup!

Let us know if you need help deploying that solution!