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
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
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
