copy if

  1. J

    Copy rows to different sheets based on multiple criteria excel VBA macro

    Sub CopyToSheets() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA") lastrow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row For rownum = 2 To lastrow Select Case ws.Cells(rownum, 8)...
    • Jyotirmaya
    • Thread
    • copy and filter copy if copy to sheet excel vba excel vba macro if and
    • Replies: 9
    • Forum: Excel Questions
  2. N

    "Copy If" from one workbook to another code?

    Hi all, I am looking to copy a cells info from one workbook [File1.xlsm] (IF it meets a certain numerical criteria from a diff cell/same row on the same sheet/workbook [File1.xlsm]) to a specific cell in a separate workbook [File2.xlsm]. My digging so far has lead me to this formula (which...
  3. M

    Automatically Copy Certain Columns of a Row to Separate Worksheet, Based on Specific Criteria

    Hi Everyone, Before I begin, please keep in mind that I am very new to anything about VBA or codes - so please "dummy" it up for me when responding. I have looked at SEVERAL posts and tried a few codes suggested throughout them, but to no avail or success - so now I'm asking for specific help...
  4. C

    Copy values if zero, if not zero.

    Hi there, I am running into an issue when trying to run the following: *If values in column A are greater than zero, paste values in column C *If values in column A are zero, copy values from column B (in same row) and paste in column C Columns are of variable lenght and values begin from A2...
  5. I

    What's wrong with this Formula?.

    Hello, I'll make my problem short so any can help me out... I have data on a master sheet with all employees information. I have a second worksheet called "groups". Under the master sheet people are assigned group numbers.. I would like for my "groups" worksheet to copy only the...

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