cut & paste

Hi All I am trying to find a solution to stop users from cutting and pasting values on a particular worksheet. This to avoid (hidden and protected) formula on the same worksheet from becoming corrupted. I still, however, want to provide the user the ability to copy and paste values. I used...

Hi, all I'm Creating a job board where I need a row moved from a "Working Jobs" spreadsheet to a "completed Jobs" spreadsheet once the checkbox for said row has been checked. Can I get some assistance with this? Thanks!

I have one file which behaves strangely. When I cut an area and paste it elsewhere, the orginal area, or just a part of it, is formatted. Normally cells are not formatted after a Cut and paste. Tried to look everywhere for a setting to turn this off with no luck. I know I could use Paste...

I am new to VBA so I am hoping you all can help. I have a data set that I want to cut and paste into 2 different sheets. I want to cut the rows that have data in column F to "Pending" and paste beneath the last row. The rows without data in column F would go to "Failures" and paste beneath the...

I work for a covered RV storage facility and am creating a waitlist for popular spaces. I'm trying to create a way for a row of data to be moved from the main sheet to another sheet when a drop down cell is selected to "Yes" as the value. That value resides in column R on the waitlist sheet...

I have used and adapted code from another thread on the site however there was errors regarding the size of copy and paste due to using EntireRow. On one sheet I have a data validation list of either outstanding or completed with the aim for excel to cut and paste the row to the "Done" worksheet...

Hi! I’m a beginner trying to program a macro that will cut the last cell in a row with data present and paste it to a specific cell in that same row, before going to the next line and looping. I’ve run into all sorts of issues trying to record the macro and programming it myself. Some cells are...

Hello all, I have a fairly simple code that selects a source file and then moves it to a new location and renames it. My issue is, if I put the location directly in the code it works. If I try to use a cell reference that has the same location in the cell, it doesn't. Not sure why as similar...

I am trying to cut and paste a row (and keeping the format) to another worksheet and 2 different worksheets in another workbook using a command button for rows in which column K shows a status of "Complete" and automatically save in both locations. In Sheet 1 (Profile Requests in progress) I...

Hello, I am new to this so please excuse my ignroance... this is my first post... I just have a question I want to create a macro that cuts data from a certain range in one sheet and then pastes that data into another sheet if one condition is met. So I have attached this spreadsheet as an...

Hello, Im trying to learn VBA and Macros to write a code that will cut and paste specific parts of a row repetitively throughout the whole sheet and skipping a row. I have created this so far: Range("C7 : H7") .Select Selection. Cut Range ("I6") .Select ActivateSheet .Paste Range("C9 : H9")...

Hi Guys! I have a sheet that is going to be used every day and i want to press a button and cut today's data and copy in a history sheet. Im kinda new to VBA but was able to cut and paste the data of the day successfully but when i press the button to log another day, the data overwrite the...

I run a report on a weekly basis, via separate software, and I have to distribute the data from the report into the corresponding sheets. I'm trying to do this in VBA, because i'm sick of doing it by hand, but I'm getting stuck on the most critical part: cutting the data and pasting it to the...

Hi Guys, looking for some help with some VBA code, which involves cutting and pasting a row dependent on a cell colour. there are 2 actions required, which will lead me on to a few others that I will require to write, but any help with these would point me in the right direction to complete...

Hello all Excel'ers :) I have a quick question to ask. I'm in the process of writing a While loop which would cut the first 3000 rows and paste them into a newly created worksheet. I know the code to create a new worksheet, but is there a way of automating the "cut first 3000 rows to *new*...

Hi all, I won't get into the reasons why, because I know people are going to try to solve for a different problem, but I have a data set that has blank rows, and the next row needs to be cut and appended to another column in the previous non-blank row. Below is an sample data set: <tbody> A...

Hi Guys, I'm a certified beginner here. So I have so many columns in Sheet 1 but what I need is to find the column header with text "People" then cut and move the whole data in Column A. Any help will be much appreciated. Thanks!

Hello, I'm new to vba programming and I'm stuck... How would I take a list of numbers in column A, and for every 5 rows cut and paste them to the top of the next available column until the list in the first column is empty? Any help or examples would be greatly appreciated. I think i need a...

Hi, This is my current code that is working Sub SortSCRA() Sheets("C&P Output").Select Columns("a:bku").Select Selection.Sort Key1:=Range("aye3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Application.Goto...

I am trying to make this program list for work. The first sheet is where we would enter information about the program to include machine, family, part number, operation, and program name. next to that, I have 3 columns for dates where we will enter the date when the program is ran. I want to...