cut

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...

Hey Everyone, Any help is greatly appreciated. Every post I see for this is cut and paste into a different sheet instead of same sheet. What I am looking for would be: A marco that is always running, that when the word "Confirmed" is placed into a cell in Column E, that it will cut that row...

Hey guys! Below is a macro I have been working on, but it still does not function quite how I want it to. I have a workbook with sheet1 "Schedule" and sheet2 "Complete". I need for when I put a "99" in column P of the table on the Schedule sheet it will cut and paste the entire row to the last...

Hello, I was wondering if there is a way to cut words from sentences ? My problem is that i have information that is in one cell and i need to cut it apart in different cells. I could do it manualy but there are thousands of sheets like this. Example Johan dohan, snippersnapper, jorgen 21...

Hi Guys, Can copy and cut be disabled in all but 1 work sheet? and leave the capability of pasting in the workbook? Thanks in advance for any feedback.

Hi, Is there a way to do this cut and paste without using the recorder's Select? range("Q3").Select Selection.Cut range("P3").Select ActiveSheet.Paste Daniel

I have the following code which is giving me a " Method'Range' of object'_Global failed" error. It fails on the line with the first instance of Range("A:O" & i) The purpose of this macro is to search thru column "L". If a cell is empty, cut the data in my Range("A:O"), paste the data at the...

Take a simple example: A1 = 5 B1 = 5 C1 = '=A1 + B1 As soon as I cut A2, and paste it over A1, my function in C1 breaks. It become's =#ref + B1 I can solve this by using INDIRECT or INDEX. But these functions have 2 major drawback's: 1) I can't copy - paste these functions from C1 to C2, and...

Hello everyone, Need help on this.. Insert & Copy field in right click button disabled in excel.

Hello, I am looking for some assistance in creating a VBA macro for Excel. The macro should cut column "C' and then insert it into column "G'. If anyone would be willing to help it would be much appreciated.

Hi All, Hoping you can help. I've got a workbook which keeps breaking. It consists of quite a few coloums and about 20,000 rows. I'm trying to make it so when there is a value of "Yes" in range X on sheet "Flightlist" it cuts the entire row that the "Yes" value is on and pastes it another...

Could some kind soul please advise me on VBA coding to complete the following; Search the Completed column (G) of the ToDo List worksheet for any date entries. If any entry found to cut and paste the entire row(s) onto the Archive worksheet (Ensuring they are pasted into the next free row)...

I looked around and cannot find a macro to cut the last character from a cell and put it into the next cell over. I would just use the text to column function but there are no common deliminators or text length. For example: <tbody> 9000600B 8475A 900655888A 741548C 300B...

Hello, consider my exel data in A to L column, in exemple named sheet: I the case K column o empty, I simply need to cut and paste I & J cells content to J & K columns -same row (= if K is empty, then move I & J values 1 cell to the right). I have tried several options unsuccessflly. Any idea?

I am using Excel 2010. Row 2 in my spreadsheet is Column Headings I would like to find all instances of "Dept Operations - Tendy" in Column E. (Say cell E3) I would like to cut the number from Cell G3 Paste it to Cell G5 If in the next instance "Dept Operations - Tendy" is in Cell E71 I would...

Good Evening, Wondering is there is such a macro to do the following: I have a worksheet that has 300 rows. Every few rows (not the same distance apart) is there word "Raking" in column A. On the same row as the work ranking are values, from column D:AD. What I need to do is set up a script...

Hi, I have a few spreadsheets specifically that hangs up my excel for about 30-60 secs every time I do a copy/cut and hangs again when I paste. It goes into "not responding" for a period of time and then resumes as per normal. The time it freezes is the same no matter how many cells I copy, it...

Good morning forum! I'm a newbie to this website, so please bear with me for not finding the answer to this question (if it has already been asked). I am running a 32-bit version of Excel 2010, and I seem to have lost the ability to cut and copy ONLY when I right-click on Full Rows and/or...

Hi guys, I have a spreadsheet with several sheets which I am having a few problems with. Basically I have set up the below code so that VBA will apply an autofilter which looks for a certain criteria in a column and then cuts and pastes the relevant row to the next sheet before deleting the row...

I have a worksheet in where I have table (let's call it the summary table) with references to a another table (among others) which is 2x40 (rows x columns). I would like to tranpose this into a 40x2 table. So, first I copy tha 2x40 and transpose it using Copy and then Paste Special ->...