Macro to copy a range of cells to another location based on odd or even number in a cell

[Thupp]

I want a macro to copy a range on sheet 1 to another location on sheet 1 based on whether a separate cell has an odd or even number in it. Number can be variable from 2 to 13.
DataRange contains names. Cell with odd or even number D8. Range of cells to copy(DataRange)= K3:L15. Copy to (PasteRange)= K37:L49. If 'Even' number - reverse order paste ( K15 and L15 would end up at K37 and L37 and so on until K3,L3 were at K49,L49). If 'Odd' number - Reverse order paste as above, but also compare PasteRange K37:L49 with DataRange of K3:L15. When row (i) found that matches all 4 names, move K(i) and L(i) to first row if L(i) is blank and last row if L(i) is not blank.

I have tried several different attempts at this and ask for help on other occasions, but my lack of Excel experience and experience with Forums have created more problems than answers. I've drawn this out on paper and it should work, but the programming is beyond my ability. Any Help????

[Richard Buttrey]

Hi,

I think an example workbook is called for. Show a before and after situation, and add narrative notes which contain references to specific cell ranges that explain the results you've arrived at.