Copy and Paste Column criteria into next empty column RRS feed

  • Question

  • I can realy use someones help on this due to time sensititivty. So basically, I need to make a macro that will copy and paste a columns worth of information into the next column empty column  continuosly.

    So everytime i run the macro, Column D needs column C's info and Column E needs Column D's info and so on and so on. The one tricky part i cant figure out is everytime i run the macro, i need the previous column to have special values.

    So if i press the macro button after the first time, Column C should have the values attribute instead of the vlookup info and column D would have the vlookup info; and so on and so on. I need it to roll over. Thank You.

    • Edited by GoQUBobcats Tuesday, August 4, 2015 7:43 PM
    Tuesday, August 4, 2015 7:17 PM

All replies