How to: When a column has 1 of 3 values, copy text
Posts Thursday November 30, 2017Registration date
November 30, 2017
Nov 30, 2017 at 09:50 AM - Latest reply: ac3mark8371
Posts Monday June 3, 2013Registration dateModeratorStatus
December 15, 2017
- Nov 30, 2017 at 05:20 PM
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.