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

Randomtrackguy 1 Posts Thursday November 30, 2017Registration date November 30, 2017 Last seen - Nov 30, 2017 at 09:50 AM - Latest reply: ac3mark 8371 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen
- Nov 30, 2017 at 05:20 PM
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


See more 

1 reply

Reply to this topic
ac3mark 8371 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen - Nov 30, 2017 at 05:20 PM
0
Helpful
Look at Vlookup!

Let us know if you need help deploying that solution!
Respond to ac3mark