vba paste

  1. J

    Copying specific data to another sheet based on cell value

    Hi guys, What I am looking to do is copy data from one sheet to another, however I only want it to copy columns A and B based on the cell value of Column E in each row So far I have the following code which is able to copy the data, but currently pastes it on every column on the worksheet and...
  2. R

    VBA Paste formats and formulas only

    Please help, my code keeps pasting values. The rows im copying have values in some cells and formulas in others, i only want the formatting and the formulas this is driving me crazy, this is what i have. Is there a way to copy the formulas and leave blank the cells with just values in? Sub...

Some videos you may like

This Week's Hot Topics