cut paste

  1. N

    Improve Cut Paste to Another Sheet Based on Multiple values in cell

    Can anyone help me? This code works but it takes toooo long to run. Is there a way I can rework the de to speed it up?Thank you,Nate Sub MoveLS() Dim i As Variant Dim endrow As Integer Dim ASR As Worksheet, LS As Worksheet Set ASR = ActiveWorkbook.Sheets("Detailed Activity") Set...
  2. A

    Looping Macro That Changes The Value Of A Cell Based On Another Cell

    Hi experts, I have a spreadsheet that needs a rather complex macro solution, for someone like myself at least. I will try to explain as simple as I can and provide as much clarity as possible (please see the file in this provided link as you go over the below inquiry) Goal: Elimination Of...
  3. Roderick_E

    Easy Cut & Paste to duplicate sheet

    My company uses a lot of spreadsheets where there are 2 tabs; one for "active" and another for "completed". The user typically will cut and paste a completed row from the active sheet to the completed sheet. Both sheets have exact same headers. To automate this, I created code so that the user...
  4. K

    VBA - Find value in sheet and cut paste row on new sheet

    Hi there Can someone please help me on this one. Thank you in advance. Below is a screen dump of the data sheet that I have. The sheet is called "SMT" What I want to do is: 1. Find the cells on the SMT sheet (in column B always) that contains "12-3113-0003586-002" as value 2. Cut paste the...
  5. S

    Macro cut based on criteria and paste to another sheet

    Hi everyone, I'm struggling with a simple macro, and some help would be greatly appreciated. I've tried recording a macro as a basis, but I just don't understand how to modify it to do what I want with the ranges. What I need is: 1. to select all the used range of data in sheet 1. This range...

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