vba cut and paste cells

  1. A

    VBA - Cut and Paste from a table to another if criteria is met

    Hi Guys! I've been trying to find a solution since quite a while, but nothing seems to work. I'm sure you can fin a easy solution for this : In the same Workbook, I have two sheets ; Sheet1 and Sheet2. Both of them contains similar tables, Table1 in Sheet1, Table2 in Sheet2. Table1 is...
  2. N

    VBA Code to Cut and Paste into Another Worksheet

    Hi folks, I am trying to modify this code to work as follows: When "Amelia Rollins" appears in column A of worksheet "Step1", cut range A:D (same row #) Paste range A:D into Worksheet "Amelia", row 6, down. Sub MoveStep1() Dim i As Variant Dim endrow As Integer Dim Step1 As...
  3. L

    VBA- How to shift cells up once you cut a row into new spreadsheet ??

    Hi Guys, I am trying to cut and paste rows from a worksheet(risk) into another worksheet(archive). This works, however I want to shift the empty row up from the (risk) worksheet, without losing my formatting/ formulas. Any ideas? Thanks in advance Dim LastRow As Long Dim destRng As...
  4. T

    VBA Cut and Paste Row into New Sheet based on Cell Value

    I have very little experience with VBA and I am certain my question will have an easy answer. I have seen posts related to mine and after trying about a dozen, I'm still having trouble. All I have been able to do is create a macro that when run, cuts and pastes the cells into a new worksheet...
  5. A

    Filter Cut Paste

    Hi All, I need a VBA solution. I need to filter column AL and paste the results to column AK. So far I have this, Sub Macro7() ' ' Macro7 Macro ' ' With ActiveSheet.Range("AL2:AL1859") .AutoFilter Field:=38, Criteria1:= _ "=*isolat*", Operator:=xlAnd, Criteria2:="<>*isolation*" On Error...

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