I'm new to writing macros and could really use your help - see the attached file as an example.
The "Overall Service" column has drop down list with the following options: G, A, R.
If users select A or R in this column then the following must happen:
- "Name of Client" must be copied from sheet 1 column C on to sheet 2, column B
- "Location" must be copied from sheet 1 column D on to sheet 2, column C
- "Overall Service" must be copied from sheet 1 column F on to sheet 2, column D
I have populated row 3 on sheet 2 as an example of what I need it to look like.
Any help is greatly appreciated and if you have any recommended sources for learning macro writing / VBA programming then that would be extremely useful.