copypastedata

  1. S

    Cycle and paste between workbooks with VBA

    So What I need to do is copy and paste the values from the green columns in workbook 1 into workbook 2 if its says "yes" in the last column. I then need to cycle to the next row in workbook 1 and paste the values into a NEW worksheet in workbook 2 and do the same until it no longer says yes in...
    • sjk1193
    • Thread
    • activecell.offseti advanced advanced criteria copypastedata firstname loop vba workbook
    • Replies: 10
    • Forum: Excel Questions
  2. M

    Copy specific cells based on input value in another sheet, and paste values to another sheet via VBA

    Hello, I have an area of calculated values for 7 areas in columns from V7:AC7 on sheet "LastMilePOBoxSummary." U7 is "Week" with the corresponding weeks of the year listed in each row. So, each RC contains the Last Mile % data point for each area for each week. I want to, using the...
    • Machl22
    • Thread
    • condition copy paste copypastedata sheet vba week
    • Replies: 7
    • Forum: Excel Questions
  3. A

    vba byref argument type mismatch

    Using Excel 2013. When I try to call my sub CopyPasteData, I get the error ""vba byref argument type mismatch". The problem most likely is due to the passthrough value for tofile. Can someone help, please? Thank you! Sub Main () Dim ThisPeriod as string Dim WBS As Workbook ThisPeriod =...
    • Apple1
    • Thread
    • copypastedata dim mismatch string thisperiod
    • Replies: 6
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top