Previous Topic Next Topic

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

Closed
Randomtrackguy Posts 1 Registration date Thursday November 30, 2017 Status Member Last seen November 30, 2017 - Nov 30, 2017 at 09:50 AM
 Blocked Profile - 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


1 response

Answer 1 / 1
Blocked Profile
Nov 30, 2017 at 05:20 PM
Look at Vlookup!

Let us know if you need help deploying that solution!
0