I have a spreadsheet with various dates as shown below
Col V Col W Col X Col Y
26-Feb-09 1 26-Mar-09 1
01-Feb-09 12 01-Feb-10 0
27-Feb-09 1 27-Mar-09 1
19-Feb-09 3 19-May-09 0
20-Feb-09 3 20-May-09 0
I want to replace the date in Col V with the date in Col X when Col Y = '1'. As Col X contains a formulae, I only want to be able to copy and the cell value.
I've tried filtering Col Y for '1', but as the resulting cells are non-adjacent, I can't copy and paste the resulting selection. Perhaps a simple macro might work, but I could really do with some guidance.
Regards
KW
Col V Col W Col X Col Y
26-Feb-09 1 26-Mar-09 1
01-Feb-09 12 01-Feb-10 0
27-Feb-09 1 27-Mar-09 1
19-Feb-09 3 19-May-09 0
20-Feb-09 3 20-May-09 0
I want to replace the date in Col V with the date in Col X when Col Y = '1'. As Col X contains a formulae, I only want to be able to copy and the cell value.
I've tried filtering Col Y for '1', but as the resulting cells are non-adjacent, I can't copy and paste the resulting selection. Perhaps a simple macro might work, but I could really do with some guidance.
Regards
KW