Hi
I am new to VBA so consequently am not sure how to select cells based on the values of other cells.
I have a spreadsheet with values of 1 or 2 in column C. I would like to create a macro to copy A1 and B1 if the value of C1 is 1, or F1 if it is 2, and so on until the first blank cell in column C is reached.
Hope that's clear and thank you very much for any help!