vba copy

  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. L

    Copying listrow throws an error (copy method of range class failed) why?

    Hi all, I have the following code: If Not Intersect(Selection, ActiveSheet.ListObjects(1).DataBodyRange) Is Nothing Then<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> Dim CopyRownr As Long CopyRownr = ActiveCell.Row -...
  3. dannyok90

    The Classic 'Add New Row Button' Macro

    Hi Guys, I'm aware there is tons of information on the net about this and I'm sort of biting the bullet asking such a generic question. I have a spreadsheet which is a template at the beginning of its life so there is literally no data in there what so ever. I'm wondering if someone could help...
  4. G

    VBA copy data to another file

    Hi there, I am trying to copy some data a file called "Excel Macro.xlsm" to a file called "BCH.xlsx" but cnt seem to manage it. The original file "Excel Macro.xlsm" contains 2 sheets: master and BCH. I have placed a button in the 'master' sheet which should extract cells A1:E20 from the BCH...
  5. L

    VBA worksheet copy problem

    hi, I was hoping someone might be able to help shed some light on the following. When I execute the following macro a new workbook (containing a single worksheet). However, I've noticed that when I execute the macro the name of the new workbook (containing a single worksheet) that appears...

Some videos you may like

This Week's Hot Topics